Classroom/ Online: Yes/ Yes
Scheduling Date(s):
Note: Please click specific date for detailed venue and course fee etc.
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.
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
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
Expert Speaker, Business Consultant with almost 20yrs experience in field of Artificial Intelligence, Data Science, Gen AI, Machine Learning, Digitalization, Data & Predictive Analytics, Creating Interactive Dashboards, Data Storytelling, Data Visualizations, Creating automated reports for real time reporting, Data & Visual Analytics using Excel and business intelligence tools like Power BI and Tableau.
In addition Divya also specializes in Academic and Corporate and Government Trainings and consulting engagements, Insights generation, decision making, driving efficiency in processes, Process Automations and creating roadmap for use of Artificial Intelligence and automation for organizations to enhance data driven decision making.
She has excellence in her oration and has been responsible for conducting CEO round tables and training Faculty members, Students and staff of prestigious Academic institutions and Leadership teams across public sector , corporates,
Government and SME’s both in Singapore and Globally
Key Experience
• National University of Singapore (NUS)
• Nanyang Technological University (NTU) – Training Adult Learners
• Singapore Management University (SMU)
• Singapore University of Social Sciences (SUSS)
• Ministry of Foreign Affairs Singapore– Trained across 25 countries
• Ministry of Defence (MINDEF)
• Institute of Singapore Charted Accountants (ISCA)
• 1FSS
• Agency for Integrated Care- Ministry of Health
• UWCSEA – United world college South east Asia
• Murdoch University – Australian university
• Association of Chartered Certified Accountants (ACCA)
Sector Experience
• Academia
• Universities
• Education Sector
• Finance and Accounting
• Government Sector – Multiple Ministries across Singapore
• Public sector
• FMCG
• Healthcare
Key Trainings conducted across above sectors
• Artificial Intelligence & Generative AI
• Data Visuaization
• Power BI and Tableau Trainings
• Data Analytics & Machine Learning
• Data Visualization and Big Data
• Creating Data Dashboards & Excel Expertise
Professional and Technical qualifications
• Masters in Business Economics
• Masters in Business Administration
• a certified Green Belt Six sigma professional.
• Economics (Hons)
