About the Program

The world of business thrives on MS Excel. There are estimated 750 million users worldwide and Satya Nadella proclaims it as Microsoft’s most important consumer product. It is being used by businesses across all Industry verticals. However, despite its popularity, a large percentage of Excel users are unaware of its true potential, often, failing to get the most out of this superbly powerful tool. We are here to make sure it doesn’t happen to you. TAP-DC’s 3 Days Advanced Excel Training program is a great way to shorten the learning curve timeline. The program is open to new & seasoned Professionals working in any department.

Key Features

Mode of training – Live Online Interactive with Exercises/ Projects.
Use of MS Office 2016.
Coaching by Industry Expert/ Experienced Corporate Professional.
Accentuated with Relevant Reference Study Material.
Guidance & hand-holding post session, on need basis.

Course Objectives

Data Management

Module 1: Excel Master Functions – Increase productivity with functions from the following categories: Logical, Statistical, Lookup and Reference, Text, Date and Time, Information, Engineering and User Defined. Learn how to combine other functions for more powerful, dynamic functions

Understand the concept of Relative/ Absolute/ Mixed References
Using Simple IF, Compound IF, Nested If, Ifs function; Using AND/OR Functions
Understand why Lookup is preferred over IF
Using the LOOKUP/ VLOOKUP/ HLOOKUP Functions
Understand why Lookup fails.
Using Index & Match
Text Functions: Using CONCATENATE, TRANSPOSE, PROPER, UPPER, and LOWER Functions, TRIM, LEFT, RIGHT, MID & LEN Functions.
Date Functions – Using DAY, DAYS, NETWORKDAYS, NOW, TODAY, TEXT Functions
Nested Formulas & Functions.
Trace Errors & Arrows
Watch Window & Evaluate Formulas

Data Analysis & Business Reporting

Module 2: Pivot Tables: After completion of this module, learners will be equipped with managing worksheet data by summarizing and manipulating your data in different ways using Pivot Tables – to answer different questions & even experiment with your data to discover new trends and patterns.

Excel – Pivot Tables Recommendations
Creating and Formatting Pivot Tables
Understanding Pivot fields – Rows/ Columns/ Values/ Filter
Use of Slicer & Timeline – When & Why
Creating dynamic Pivot Charts
Creating Pivot on multiple Tables – Using SIMPLE Data Model
Creating Pivot using Multi Sources

Business Intelligence – Data Visualization

Module 3: Data Visualization: Data visualization is the graphical representation of information and data. By using visual elements like charts, graphs, and maps, data visualization tools provide an accessible way to see and understand trends, outliers, and patterns in data.

Understand & Identify the use of various Chart types based on the Data availability
Switching Data/ Switching Chart Location
Customizing Charts – Handling and Controlling of Data
Manipulating Chart titles, Chart Legend, Chart Data, and Chart labels
How to create a Combination Chart
Dynamic Dashboard – Use of MATCH, INDEX, OFFSET & other functions, together to retrieve data dynamically.
Hands on exercise on dynamic dashboards – Animating Changes over time; Automatic Chart Updates; Image Overlay Charts; Gauge Charts

Additional Concepts

Module 4: Additional Concepts

Excel Shortcuts, Tips & Tricks for productivity improvement & Macros.

FACULTY – Charu Smita Malhotra

Founder CEO of Technology and Personality – Development Center (Tap-DC), which addresses the growing Skill Enhancement/ Skill Development needs of the Corporates/ Industries & Institutions.

She’s over 18 years of experience designing & delivering solutions for Fortune 500 clients globally. She’s passionate about Data, Analytics, Information & Visualization. Her constant endeavor is to train & engage professionals globally in Tools that justify the importance of Data & Information; Excel being one of the basic & the best.

Over the years of Advanced Excel & Office 365 trainings, she has trained thousands of corporate professionals (Business Owners (CXOs)/ Sales Team/ HR Team/ Marketing/ Finance & Accounts/ IT professionals) & has empowered them to increase their work productivity 5X and drastically reduce the time spent on excel operations.