Microsoft Excel: From zero to hero

Scenario based training on Excel for learners of all levels.

How does learning from someone who started Excel training in his company in 1995 sound?

What you’ll learn

  • Build a solid understanding on the Basics of Microsoft Excel.
  • Microsoft Excel from Beginner to Advanced using real scenarios and downloadable working files.
  • Practice the use of dynamic functions like IF, VLOOKUP, HLOOKUP, PMT, INDEX, MATCH, SUBTOTALS and many more.
  • Create great looking reports using Pivot tables, Slicers and Sparklines.
  • Automate daily routine work using Macros.
  • Practice Excel Tips and Tricks to work more effective.

Course Content

  • Introduction –> 12 lectures • 5min.
  • Excel Options –> 5 lectures • 3min.
  • Mouse Pointer Shapes –> 1 lecture • 1min.
  • Mouse Selection Techniques –> 2 lectures • 1min.
  • Entering and Editing of Data –> 6 lectures • 3min.
  • Working With Sheets –> 7 lectures • 4min.
  • Working with Rows and Columns –> 6 lectures • 3min.
  • Copy and Paste & Moving and Insertion of Text –> 2 lectures • 1min.
  • Autofill –> 2 lectures • 2min.
  • Formatting of Cells –> 12 lectures • 6min.
  • Basic Calculations –> 7 lectures • 3min.
  • Working With Functions –> 3 lectures • 2min.
  • Sorting –> 5 lectures • 2min.
  • Paste Special –> 5 lectures • 2min.
  • Cell References –> 2 lectures • 2min.
  • Count –> 5 lectures • 3min.
  • Logical Functions –> 3 lectures • 2min.
  • Financial –> 2 lectures • 2min.
  • What-If Analysis (Goal Seek) –> 2 lectures • 2min.
  • What-If Analysis (Data Tables) –> 2 lectures • 2min.
  • Validation –> 7 lectures • 5min.
  • Filter –> 4 lectures • 2min.
  • Conditional Format –> 3 lectures • 4min.
  • Charts –> 8 lectures • 5min.
  • Headers and Footers –> 1 lecture • 1min.
  • Subtotals –> 3 lectures • 2min.
  • Links –> 5 lectures • 4min.
  • Printing –> 9 lectures • 6min.
  • Protection –> 8 lectures • 6min.
  • Freeze Panes –> 2 lectures • 1min.
  • Removing Duplicates –> 1 lecture • 1min.
  • Match –> 2 lectures • 2min.
  • Logical Functions –> 4 lectures • 3min.
  • Count –> 3 lectures • 2min.
  • Lookups –> 5 lectures • 3min.
  • Tables –> 4 lectures • 2min.
  • Slicers –> 3 lectures • 2min.
  • Sparklines –> 1 lecture • 1min.
  • SheetVeryHidden –> 1 lecture • 1min.
  • Pivot tables –> 7 lectures • 5min.
  • Macro’s –> 7 lectures • 4min.
  • Switch between Excel spreadsheets only –> 1 lecture • 1min.
  • Use Ctrl + Enter to fill an entire range –> 1 lecture • 1min.
  • Copy formula on clipboard to be used later –> 2 lectures • 1min.
  • Finding and removing blanks –> 1 lecture • 1min.
  • Snap objects to cell borders –> 1 lecture • 1min.
  • Sort according to a custom list –> 2 lectures • 1min.
  • Enter bullets in Excel –> 1 lecture • 1min.
  • Autofill growth trend –> 1 lecture • 1min.
  • Join the content of two or more cells –> 1 lecture • 1min.
  • IFERROR function –> 12 lectures • 7min.

Microsoft Excel: From zero to hero

Requirements

  • This course was created with Excel as compiled in Microsoft Office 365 ProPlus..
  • Do not worry if you have a lower version of Excel. The functions are the same across the versions and you will easily find your way.

How does learning from someone who started Excel training in his company in 1995 sound?

Today you have this opportunity!

For over 26 years Wilkie has laid the foundation for thousands of people teaching Microsoft Excel.

In this course, he will share his knowledge with you.

He will lay the foundation starting with the Basic principles and then build towards the Advanced features.  Whether you have never opened an Excel file ever before, you want to brush up on your skills and the newest features, or you are well versed in Excel and want to learn more advanced functions, this course has it all!

The course also includes valuable tips and tricks to work more effectively in Excel, and is designed from a basic to advanced level.  We’ll discuss topics such as:

  • Entering and editing data
  • Autofill
  • formatting of cells
  • working with functions
  • sorting of data
  • past special
  • The What-if-analysis
  • One- and two data table
  • validations
  • conditional format
  • charts
  • subtotals
  • links
  • protection
  • Lookups
  • Pivot tables, and macros

The training is built on scenarios and you can practice what you have learned using downloadable Excel working files, and is for anyone who wants to work more effectively in Microsoft excel. Whether in a corporate or personal capacity, if you use excel regularly this course is for you!

Remember: You don’t know what you don’t know, so it is worth your time investing in this course.

See you online!