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

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!