Instructor-led class. Designed for corporate exclusively. Can be customised for 8 hrs or 16 hrs or 24 hrs. Flexible Schedule.
Topics Covered
Our Workshop will empower you with the Following: Keyboard Shortcuts. 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. Dashboard designing. Working with the other applications in Excel. Usage of Conditional Formatting in Template. Different ways to visualise the data, Data Cleaning like professionals, Data Mining and Data Analysis Techniques, Protection Techniques and Hiding techniques,Easy working with huge volume of data. Consolidation of workbooks, worksheets, Notepads / textfiles in 10 seconds. Basics of Macro , Recording and running macro and many more.....
Who should attend
Persons who are already aware of excel environment and would like to enhance their knowledge to the next level. Finance executives, MBA Professionals MIS executives HR Professionals Sales or Marketing Professionals, Engineers,
Pre-requisites
Minimum or basic working knowledge of Microsoft excel.
What you need to bring
Laptop"
Key Takeaways
Pre and Post Training Support on demand
Soft copy of the Reference Manual Hands in Practice Excel Workbooks
Post Training support for 90 days
NInja SHortcuts to save TAT, Increase Speed, Efficiency and Productivity