About the Course
Advanced Excel training session will be of 16 hrs program. in these 16 hours program the students gonna explore the features of DATA Analysis tools which will help them to analyse, budgeting, forecasting and decision making. Besides folks will learn the visual presentation techniques to address the target audience exceeding their expectation.
Topics CoveredOur Workshop will empower you with the Following:
Hidden functions and Features along with tips and tricks.
Usage of Data summarising tool like Pivot, Subtotal, Table styles etc.
Data Analytical tool like Solver, Goal Seek, Data Table.
Working with the other applications in Excel.
Usage of Conditional Formatting in Template.
Protection Techniques and Hiding techniques
Easy working with huge volume of data.
Consolidation of workbooks, worksheets, Notepads / textfiles in 10 seconds.
Who should attendMBA Students from any stream like Finance, HR, Telecom Management or any other management course.
Pre-requisitesBasic Knowledge of Microsoft Excel
What you need to bringLaptops installed with MS Office 2010 and Avove version
Key TakeawaysHands in Experience in Excel.
TAT Saving tips and tricks.
Softcopies of reference manual
Post Training Support for 90 days