Excel Core From Basic to Advanced

Classroom

Workshop Overview

Excel tools enable us to be more productive and efficient By attending participants will learn to leverage
the powerful features of Excel from basic to advanced covering Calculation, Formatting, Analysis and
Reporting

 

The Learning Journey:

• Reviewing the basics of Formatting and Calculation tools
• Mastering Excel most important functions
• Analyzing Data and Alternative data sets
• Apply the key Excel functions to prepare data for analysis
• Apply advanced calculations
• Create and customize pivot tables to reconcile and analyze accounts efficiently
• Utilize pivot tables functions and calculations to generate a set of management and
business analysis reports
• Creating Advanced charts and graphics
• Changing workbook Appearance