When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Microsoft Excel Beginner and Intermediate with Certificate
Learn how to use Excel for Mac and PC with this beginner and intermediate excel certificate class. Top Rated Training.
This Course Includes
udemy
3.4 (269 reviews )
7h 18m 
english
Online - Self Paced
professional certificate
Udemy
About 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
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 You Will Learn?
- 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 Show moreShow less.