The Microsoft Training Bundle: ZERO to ADVANCED

6 Courses & 25 Hours
$25.00$1,200.00
You save 97% -

What's Included

Microsoft Excel: From ZERO to ADVANCED
  • Experience level required: Beginner
  • Access 42 lectures & 7 hours of content 24/7
  • Length of time users can access this course: Lifetime

Course Curriculum

42 Lessons (7h)

  • Your First Program

  • Section I: Getting Started with Excel

    Chapter 1: Introducing Excel4:16
    Chapter 2: Entering and Editing Worksheet Data9:28
    Chapter 3: Performing Basic Worksheet Operations8:10
    Chapter 4: Working with Excel Ranges and Tables4:08
    Chapter 5: Formatting Worksheets11:34
    Chapter 6: Understanding Excel Files and Templates3:37
    Chapter 7: Printing Your Work7:13
    Chapter 8: Customizing the Excel User Interface1:47

  • Section II: Working with Formulas and Functions

    Chapter 9: Introducing Formulas and Functions5:26
    Chapter 10: Using Formulas for Common Mathematical Operations7:41
    Chapter 11: Using Formulas to Manipulate Text10:13
    Chapter 12: Using Formulas with Dates and Times6:33
    Chapter 13: Using Formulas for Conditional Analysis16:58
    Chapter 14: Using Formulas for Matching and Lookups12:14
    Chapter 15: Using Formulas for Financial Analysis11:56
    Chapter 16: Using Formulas for Statistical Analysis11:44
    Chapter 17: Understanding and Using Array Formulas7:47
    Chapter 18: Making your Formulas Error-Free8:41

  • Section III: Creating Charts and Other Visualizations

    Chapter 19: Getting Started with Excel Charts15:27
    Chapter 20: Using Advanced Charting Techniques36:46
    Chapter 21: Creating Sparkline Graphics5:50
    Chapter 22: Visualizing with Customer Number Formats and Shapes20:02
    Chapter 23: Implementing Excel Dashboarding Best Practices31:33

  • Section IV: Managing and Analyzing Data

    Chapter 24: Importing and Cleaning Data10:08
    Chapter 25: Using Data Validation9:47
    Chapter 26: Worksheet Outlines3:47
    Chapter 27: Linking and Consolidating5:55
    Chapter 28: PivotTables16:38
    Chapter 29: What-If Analysis15:11
    Chapter 30: Goal Seek and Solver15:10
    Chapter 31: ToolPak6:22
    Chapter 32: Protecting Data3:56

  • Section V: Understanding PowerPivot and PowerQuery

    Chapter 33: Introducing Power Pivot3:42
    Chapter 34: Data Model7:57
    Chapter 35: Adding Formulas to Power Pivot12:42
    Chapter 36: Power Query10:52

  • Section VI: Automating Excel

    Chapter 37: VBA14:45
    Chapter 38: User Defined Functions6:32
    Chapter 39: UserForm6:12
    Chapter 40: UserForm Example12:19
    Chapter 41: Excel Events4:15
    Chapter 42: Add in6:49

Microsoft Excel: From ZERO to ADVANCED

L
LearningWhilePracticing

LearningWhilePracticing

4.5/5 Instructor Rating: ★ ★ ★ ★ ★ ★

LearningWhilePracticing has one of the most practical approaches when it comes to learning. Their goal is to let you be operational as quickly as possible while at the same grasping all the concepts required. Being able to work on your projects through a software while learning it at the same time, is a source of motivation that will make you go further.

Description

Microsoft Excel is one of the most advanced spreadsheet software and one with a high demand on the market. Whether it is for data science, finance, accounting, or administration, Microsoft Excel has the tools and libraries that will make your project come to life. If you have no knowledge whatsoever of this software, this course is for you! You will be gaining all the required skills to be a complete professional in no time.

4.9/5 average rating: ★ ★ ★ ★ ★ ★

  • Access 42 lectures & 7 hours of content 24/7
  • Learn to create workbooks & spreadsheets
  • Acquire critical Excel knowledge including keyboard shortcuts
  • Learn how to add formulas to power pivot
  • Create custom Excel add-ins
  • Discover how to customize the Excel user interface
  • Learn how to work with Excel ranges & templates

NOTE: Software NOT included

Specs

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any version of Excel including Excel in Microsoft Office 365

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Your cart is empty. Continue Shopping!
Processing order...