New user? Register as member

(1-day Advanced Excel) Build Interactive Dashboards and Learn advanced Excel Techniques

This workshop is designed for all professionals who are ready to work on complex business problems. This workshop is focused on learning excel formulas and functions and learning new excel tips and tricks to use them in their daily routines

Our expert trainer will work with all the participants on huge data sets and work on practical examples to help them gain expertise in all the advanced formulae and functions, complex charting techniques with enhanced functionalities, and mastering pivots

Hands-on exercises will be given by working on complex workbooks helping participants to summarize and organize data for meaningful reporting and help them derive insights.

Objective

The participants of this workshop will learn complex calculations through nested functions, dynamic formulas, enhanced pivot tables, and its features, modifying and creating complex charts, dynamic filtering conditions and creating meaningful and insightful information using excel and use them to perform their daily tasks efficiently

This workshop will also help the participants to learn new excel shortcuts that will help them increase their productivity in their day-to-day work

In addition, participants will understand about VBA and get knowledge of Recording macros and creating their own macros and use them to perform their daily tasks efficiently

This workshop will also help the participants to learn new excel shortcuts that will help them increase their productivity in their day-to-day work

Outline

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. Creating complex Pivot charts
2. Creating summaries in Pivots
3. Adding and Removing Subtotals
4. Using Slicers in Pivot Table
5. Creating graphical representations through pivots
6. Inserting formulae’s in Pivots

Participants to work on multiple examples to master creating complex reporting solutions through pivot tables

Expertise in graphical representation through Charts

1. Summarizing data visually through charts
2. Mastering the art of depicting information graphically by working on multiple 2D and 3D charts.
3. Creating combination charts and customized version of different charts to show the information as per the problem statement
4. Developing 3 dimensional charts with practical examples
5. Use of waterfall charts for professionals from various industries
6. Uses and applicability of Bubble charts
7. Creating Gauge Charts

Dashboard designing

1. What is Management Dashboard
2. Principles of dashboard design
3. Using Advanced formulas to create dynamic data
4. Linking humungous data with customized view and selections
5. Mastering Developer Tab

Work with the trainer on Hands-on exercises and create dashboard examples


Practical scenarios and examples to perform Hands on exercises

Who should attend

All professionals who use excel not only for day to day processing but also for interpretation and insight generation in their day to day work and use them for drawing out interpretations in the form of dashboards, MIS or any other form of data mining to convert raw data to meaningful analysis.

The aim of the course is to make the participants learn advanced excel tips and techniques in a way that helps you enhance your productivity, speed and make your work much easy to interpret.

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.