Microsoft Excel Beginner and Intermediate with Certificate

• 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