Microsoft Excel Beginner and Intermediate with Certificate

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

Learn how to use Excel for Mac and PC with this beginner and intermediate excel certificate class. Top Rated Training.

Url: View Details

What you will learn

• To educate on Microsoft Excel
• Layout: Standard Toolbar​
• Layout: Formatting Toolbar

Rating: 4.25

Level: All Levels

Duration: 7.5 hours

Instructor: Startup Saturdays