Advanced Excel Training

Course Objectives

This workshop is designed for all professionals, who are involved in data gathering, analysis and creating meaning inferences for the business. This workshop will be suitable for those who are aware about the intermediate excel functionalities and are ready to work on complex business problems.

This workshop is focused on learning advanced excel formulae’s and functions and learn 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’s and functions, complex charting techniques with enhanced functionalities, mastering pivots and learning MACROS.

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

Course 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.

Mastering lookup functions

1. Nested IF’s conditions
2. Creating cell references
3. Create complex nested formulae’s
4. Advanced Date Functions
5. Statistical Functions
6. OFFSET
7. INDEX
8. ADDRESS
9. SUMIF S
10. MATCH, etc

Hands on exercises for applicability of complex formulae’s

Creating Dynamic excel workbooks:

Working on humungous data sets and Creating robust data and making it user friendly
Creating Dynamic dropdowns and linking data basis different criteria’s

Mastering Pivot Tables:

Creating complex Pivot tables
Creating summaries in Pivots
Adding and Removing Subtotals
Using Slicers in Pivot Table
Creating graphical representations through pivots
Inserting formulae’s in Pivots
Customizing pivot data
Using advanced filters
Managing rows and columns to achieve required results
Creating reports out of pivot tables
Introduction to Power Pivots

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

Forecasting data and graphs

Expertise in graphical representation through Charts

1. Summarizing data visually through charts like pie charts, bar graphs, line charts,area charts and many more
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
6. Uses and applicability of Bubble charts
7. Use of combination charts
8. Plotting and Highlighting geographical presence
9. Analysing different business solutions diagrammatically and mastering the art of creating charts

Learning about Macros for efficient effectiveness and automating the regular reporting of KPIs

What is VBA
Uses and applicability of Macros
Identifying power of Excel
Recording and Testing of Macros
Mastering the developer tab
Relative and Absolute Recording
Running and deleting macros
Examining the MACRO codes
Altering and Modifying macros
Creating your own macros

Learning Outcomes

The participants of this workshop will learn logic, and statistics that save your time. The partciapnts will be able to efficiently work on day to day processing but also for interpretation , uncovering insights and insight generation in their day to day work, increasing accuracy of work, preparing forecasts and any other form of data driven decision making. In addition, you can learn about creating customizations, add your own data driven decision variables, and modify functions, using complex calculation 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.
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

Pre-Requisites

All participants should have their laptop with preinstalled MS office.

Who Should Attend

All Corporate professionals, sole proprietors, SMP’s or any company personnel or individual who are involved in managing raw datasets who use excel not only for day to day proceesning but for 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.

Contact Us

Name

Phone Number

Company Name

Message