Microsoft Excel Beginner and Intermediate with Certificate

Brief Summary

Hey there! Want to become an Excel wizard without tearing your hair out? This course is just for you! Whether you're a Mac or PC user, we’ve got you covered. From the layout to the fancy functions, we’ll walk you through in the easiest way possible!

About This Course

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

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

• To educate on Microsoft Excel

• Layout: Standard Toolbar​

• Layout: Formatting Toolbar