Microsoft Excel Complete Training

From Fundamentals through Advanced Functions

This course is a fully detailed exploration of the major tools in Microsoft Excel. Over 12 hours of videos cover foundational skills - selection, calculation, and keyboard shortcuts - as well as more complicated tools - Pivot Tables, nested functions, and recording macros. This course is a combination of the Foundational Skills class and an additional 7+ hours of tutorials.

Who should take this course? Anyone who wants to add skills like color-coding, charting, and report-building to their skillset. Anyone who wants to learn how to combine functions in creative ways to cut hours from their work. Anyone who needs a library of Excel how-to material at their fingertips, ready for any situation.

Topics include:

  • Entering, Editing, and Selecting Data
  • Creating Simple Calculations
  • Sorting, Filtering, and Creating Subtotals
  • Pivot Tables and Pivot Charts
  • Building Effective Charts
  • Working with External Data
  • VLOOKUP and Logical Functions
  • Combining Functions
  • Recording, Editing, and Using Macros


Your Instructor


Neil Malek
Neil Malek

Neil Malek has been teaching software courses for professionals for twenty years. As a Microsoft Certified Trainer, Microsoft Certified Technology Specialist, Microsoft Certified Professional Developer, Adobe Certified Instructor, Adobe Certified Instructor, and CompTIA Certified Technical Trainer, he covers a range of topics from Microsoft and Adobe software, to Google and third-party software services, to professional skills like presentation design and public speaking. He's been running Knack Training for the last five years, and is thrilled to get some of his best live material into these videos.


Course Curriculum


  Module 01: Introduction to Excel
Available in days
days after you enroll
  Module 02: Calculating Values
Available in days
days after you enroll
  Module 03: Managing Your Workbook
Available in days
days after you enroll
  Module 04: Working with Lists and Tables
Available in days
days after you enroll
  Module 05: Charting
Available in days
days after you enroll
  Module 06: Pivot Tables and Pivot Charts
Available in days
days after you enroll
  Module 07: Pre-Setting Your Spreadsheet
Available in days
days after you enroll
  Module 08: Working with External Data
Available in days
days after you enroll
  Module 09: Using Powerful Functions
Available in days
days after you enroll
  Module 10: Nesting Functions
Available in days
days after you enroll
  Module 11: What if Analysis
Available in days
days after you enroll
  Module 12: Recording Macros
Available in days
days after you enroll

Frequently Asked Questions


When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Get started now!