What you'll 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
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
