fbpx
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"ec9c1":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default","value":{"colors":{"ec9c1":{"val":"var(--tcb-skin-color-0)"}},"gradients":[]},"original":{"colors":{"ec9c1":{"val":"rgb(57, 163, 209)","hsl":{"h":198,"s":0.62,"l":0.52,"a":1}}},"gradients":[]}}]}__CONFIG_colors_palette__

Today’s workforce is highly competitive

What is going to set you apart and get you the career you've been chasing?
To differentiate yourself from others, you need proficiency in skills and programs that improve your productivity.

Our Mastering Excel training program will give you that proficiency. 


Each engaging and interactive lesson contains full audio-visual explanations and demonstrations. The training approach we've taken will appeal to Visual, Auditory, or Kinesthetic learners and is a proven effective way to train your brain for maximum skill retention.


We teach Excel like
Nobody else

Mastering Excel: Formulas and Functions not only gives an easy-to-understand explanation of the more complicated aspects of Excel, this course teaches you the steps by allowing you to practice them inside the course.


After each lesson, practice exercises allow you to demonstrate what you've learned with a custom-built Excel spreadsheet inside our app that will test you on what you've just been shown. 


Unlike every other Excel training course, these demo-spreadsheets offer the opportunity to use Excel's functionality without becoming quickly overwhelmed with the entire suite of tools the full Excel program offers. 


Additionally, it gives you the freedom to practice using Excel without the requirement of having it installed on the device you're using Mastering Excel to train with.

What you'll see after you sign up

This Course Includes:

  • 6 Modules of Training Using 22 Short Videos
  • Audio-Visual Guided Learning
  • Transcripts and Sample Worksheets
  • Watch it / Try it Interactive Challenges
  • Knowledge Checks
  • Micro-learning Format
  • PC or Mac Installation Compatibility
  • Also included is an information packed resource library:

  • Transcripts for each lesson
  • Excel worksheets designed specifically for each lesson
  • 352 Excel Shortcuts for PC and Mac
  • Certificate of completion once the course has been successfully completed
  • Your Lesson Plan:

    Module 1: Define and Manage Named Date Ranges and Objects

    Lesson 1: Define and Manage Named Date Ranges

    Lesson 2: Define Named Ranges Using the Name Box Only

    Lesson 3: Define Named Objects

    Lesson 4: Manage Named Ranges and Objects

    Lesson 5: Naming Cells 

    Lesson 6: Using Named Cells in a Formula 

    Module 2: Apply Functions in Formulas

    Lesson 1: Apply Functions in Formulas 

    Lesson 2: Perform Logical Operations by Using Nested Functions 

    Lesson 3: Perform the AND Function and the OR Function 

    Lesson 4: Perform NOT Function 

    Lesson 5: Perform SUMIF, AVERAGEIF, and COUNTIF Functions

    Module 3: Use Functions to Look Up Data

    Lesson 1: Look Up Data by Using the VLOOKUP Function

    Lesson 2: Look Up Data by using the MATCH Function    

    Lesson 3: Look Up Data by Using the HLOOKUP Function

    Lesson 4: Look Up Data by Using the INDEX Function

    Module 4: Apply Advanced Time and Date Functions

    Lesson 1: Reference the Date and Time Using the NOW and TODAY functions     

    Lesson 2: Serialize Numbers by Using Date and Time Functions 

    Module 5: Perform Data Analysis and Business Intelligence

    Lesson 1: Import, Transform, Combine, Display, and Connect to Data

    Lesson 2: Consolidate Data

    Lesson 3: Perform What-If Analysis by Using Scenario Manager

    Lesson 4: Perform What-If Analysis by Using Goal Seek

    Module 6: Troubleshoot Formulas

    Lesson 1: Trace Precedence and Dependence

    Lesson 2: Monitor Cells and Formulas using the Watch Window

    Lesson 3: Validate Formulas by Using Error Checking Rules         

    Lesson 4: Evaluate Formulas