Advanced Excel Training for Corporate Professionals in Pune and Mumbai
Prabhas Panda
Founder @ Excel4all??Microsoft Office Specialist??Microsoft Excel Expert??Professional PowerPoint??Power BI Trainer ??Finance for Non Finance??MS Visio ??Excel VBA and Macro??Power Query??Power Pivot??Microsoft Project
Unleash the power of Excel and become an Excel Pro
Objective:
Microsoft Excel, is the widely used program across the world, which is used for performing numerous computations, manipulations and compilation of data. There are so many useful features that are available on this spreadsheet application, which go unused. Hence Excel4all has designed a two days’ workshop not only to empower the participants with the unexplored features, tools, hidden functions and tips and tricks in Microsoft Excel but also to save TAT, work smart and 10x faster and also can apprehend the significant growth in their productivity. JOIN the workshop and make the difference at your workplace.
Who Can Attend:
This workshop would be very useful to participants across various industries and functional specializations such as MIS, Finance, Marketing, Operations, Human Relations, Information Technology and Administration.
Contents in Brief:
- Excel 2013/2016 Quick Overview with exploration of QAT.
- Overlook basics
- Fill Series & exploring Flash Fill
- Absolute Referencing & Working with name Manager
- Solving Date related Puzzles and feel of Business Maths.
- Understanding the Data Type, Clean them , format them and Mine same
- usage of Text functions to extract relevant Information from Data Columns.
- Condition Formatting with formulas
- Advanced Sorting and Filter Options and Hidden tricks.
- Prevention of Data Error and Duplicate entry with Data Validation.
- Vlookup & Hlookup with 2Dimensional Look up and many more.
- Pivot Table Data Analysis, Drill Down data Mining features, Designing multiple pivot Table with no time, Designing Dashboards with Pivot Table, Other Pivot Table Data Presentation techniques.
- If & Nested If with Single and multiple criteria
- Usage of Dashboard Functions
- Charts & Graphs
- Advance Filter with Formula.
- Group & Outline and Auto outlining
- Consolidation of multiple workbooks and worksheets
- Subtotal for preparing a quick summary out of any data
- Custom List to define your own list and work conveniently
- Link & Hyperlink to create a link and share information
- Sharing & Protection to protect data from unauthorised access.
- Macros ( Basic, Run and Record Macro, Editing a macro, Designing your first macro program, Demonstration of macro tools)
Course Benefits:
- Comprehensive Course Coverage
- Certified Master Instructor
- Hands-on-Training
- Excel Tips, Tricks and Best Practices
- Post training Support for 90 days
- Soft Copies of the reference manual and hands in exercise.
For any further details, queries or clarifications and Registration:
Please call : Mr.Prabhas: +917875726961 ( Technical Discussion)
or Mrs. Nivedita: +91-9049824030 (For Registration)
Email Us: [email protected]
Visit Us: https://www.excel4all.in/