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
