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
Learning Objectives :
• 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
