Advanced Excel

Advanced Excel
Objectives— Objectives— This hands-on workshop builds on intermediate skills in the use of Microsoft Excel, presenting some very useful productivity tools for simplifying tasks and enhancing reporting. Some of the topics to be covered are: 1. Working with multiple worksheets 2. Working with advanced formulas (sumif, vlookup, pivot) 3. Creating graphs and charts (reconciliation, optimal performance, correlation XY) 4. Variance analysis for management reporting 5. Data validation techniques to minimize reporting errors 6. Sensitivity & Scenario Analysis 7. 10 best short cut tips in Excel
When
2018-05-15 8:30 AM - 4:30 PM
Where
Courtyard By Marriott Hastings Christ Church

Program


Tuesday, 15 May 2018

 
Time
8:30 AM - 4:30 PM
2018-05-15 8:30 AM

Sign In

Connect with Us
On Facebook