Microsoft Excel Master Class
The course shows how to analyze and review data extracted from accounting systems and databases in order to prepare management reports and build efficient financial models.
The course studies Excel’s functions and how to use these effectively. The program also shows how to access the Visual Basic Editor and use macros and user defined functions in order to enhance Excel’s functionality. Half a day will also be spent showing attendees how to use Excel’s pivot table functionality. Pivot tables are often poorly understood and yet are the most powerful feature in Excel. A basic pivot table will allow you to summarize 50,000 rows of data in 30 seconds
The course is highly practical: delegates will be exposed to examples (in Microsoft Excel) throughout the duration for the course.
This is a self-paced course that can be taken in 10 Weeks.
In this section you will learn how to Merge multiple sheets and workbooks
Data Analysis with Pivot Tables
Optimization with Goal Seek, Scenarion Manager and Solver Addin
What-If Analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet. Three kinds of What-If Analysis tools come with Excel: Scenarios, Goal Seek, and Data Tables. Scenarios and Data tables take sets of input values and determine possible results.
0.00 average based on 0 ratings