New user? Register as member

1-Day Advanced Excel Workshop

Advanced Excel Training course is focused on learning advanced excel formulae’s and functions. The participants of this workshop will learn complex calculation through nested functions, dynamic formulae’s, pivot tables, modifying charts, enhanced filtering conditions and creating meaningful and insightful information using excel tips and tricks.

Our expert trainers will work with all the participants on huge data sets and practical examples to help them bring in use all the above mentioned functions and functionalities. Hands on exercises will be given by working on multiple workbooks and giving insights on summarizing and organizing data in a meaningful reporting.

Objective

This workshop is best suited for all individuals who work on humongous data and use excel in their day to day work. The participants attending this workshop are expected to know the basics of MS excel so that they can further work on complex formulaes and calculations. This course will help its participants to master the art of excel and analyze data, slice and dice the data and use enhanced features offered by MS excel

Outline

Mastering advanced formulae’s like
1. Look up functions,
2. IF conditions and nested IF’s,
3. Date and Time Functions,
4. SUMIF and COUNTIF,
5. Text functions,
6. Creating references,
7. INDEX,
8. MATCH,
9. ADDRESS,
10. OFFSET, etc.

Creating Dynamic excel workbooks
1. Learning on Data mining and slicing and dicing the data using Creating customized formulae’s
2. Mastering the art of creating tables and its use in day to day work
3. Creating Data validations and linking it with data
4. Use of named ranges and creating the same
5. Creating Dynamic dropdowns and linking data basis different criteria’s

Mastering Pivot Tables
1. Understanding the uses of pivot tables
2. Sorting and filtering in Pivot tables
3. Working on advanced pivot functionalities
4. Customizing Pivots

Expertise in graphical representation through Charts like:
1. Bar charts,
2. line charts,
3. Pie charts,
4. radar charts,
5. scatter charts,
6. area charts,
7. bubble charts,
8. waterfall charts,

Learning about Macros
1. Use of Macros
2. Automating repetitive tasks
3. Mastering Developer Tab
4. Creating Combo Boxes and List Boxes

Who should attend

Intermediate & Advanced Excel User

Profile of Divya Arora Hans

Divya is an expert Speaker and Trainer with more than decade experience in field of Management Reporting, Data Analytics, Business Intelligence and Change Management. She has excellence in her oration and has been responsible for training Corporates, Self employed, Individuals and stakeholders in areas of Advanced MS Excel, Mastering Power Point, Data Analytics, Delivering Impactful Presentations, Data visualizations, Advanced business communications, Wow your audience and many Soft Skills Trainings

Her Span of Experience has been to varied CXO’s, Department Heads and leadership teams across Finance, Accounting, Insurance, Engineering, Healthcare and FMCG industries

Her experience has been with ACCA Singapore, NTU, Delphi Technologies and multiple Retail trainings in Singapore

Her core skills are trainings in areas of MS Office, Power BI, Project Management, Business Intelligence, Business Communication Skills, Stakeholder Management, Team management/leadership, Process Transitions, Process excellence, Continuous Improvement and Change Management. She has varied experience working with big giants like Glaxo Smith Kline, ABN AMRO Bank and Max Life Insurance joint venture with MITSUI SUMITOMO and various training institutes in India and Singapore.

She has been a key contributor to Quality and service excellence and is a certified Green Belt Six sigma professional.