Free Course: Microsoft Excel Beginner and Intermediate with Certificate

This is a beginner and intermediate Microsoft Excel training class that requires no prior knowledge of Excel. The training provided in this class covers MAC and PC. Ideal for students who use a MAC and just as applicable to students who use a PC.
The class starts be describing the interface and then explains different functions a user can utilize to perform a variety of analysis.
This is a beginner and intermediate level class, no prior excel experience necessary.
Following is a list of topics covered in class:
Layout
Standard Toolbar
Formatting Toolbar
Home Tab
Layout Tab
Tables Tab
Charts Tab
Smart Art
Formulas
Data
Review
Functions
Sum
Average
Max
Min
Count
Vertical and Horizontal Lookup
Vertical and Horizontal Lookup with Index
SumIf and AverageIf
The IF Statement
Nested IF Statement
Vlookup nested inside an if statement

What are the requirements?

Microsoft Excel

What am I going to get from this course?

Over 34 lectures and 7.5 hours of content!
To educate on Microsoft Excel
Layout: Standard Toolbar​
Layout: Formatting Toolbar
Layout: Home Tab
Layout: Layout Tab
Layout: Tables Tab
Layout: Charts Tab
Layout: Smart Art
Layout: Formulas
Layout: Data
Layout: Review
Functions: Sum
Functions: Average
Functions: Max
Functions: Min
Functions: Count
Functions: Vertical and Horizontal Lookup
Functions: Vertical and Horizontal Lookup with Index
Functions: Sumif and Averageif
Functions: The IF statement
Functions: The nested IF statement
Functions: Vlookup nested inside an IF Statement

What is the target audience?

Beginner
Intermediate
Advanced
Anyone interested in harnessing the power of Microsoft Excel
Mac users