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.
Requirements
• Microsoft Excel
Description
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
Who this course is for:
• Beginner
• Intermediate
• Advanced
• Anyone interested in harnessing the power of Microsoft Excel
• Mac users
Download More Latest Courses Visit ==>> Course Drive