Advanced Excel with data analytics

28 Feb '20 friday

10:00 AM - 5:00 PM

technology and personality - development center, Faridabad

I-18, 3rd Flr, DLF Industrial Area, Ph-1, Sec - 32, Faridabad

www.tapdc.in || contact@tapdc.in || 9910112999 || 9717012999

Just behind NHPC Metro Station

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 Advanced Excel 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 – Hands-on learning with Challenges/ Projects across all Modules.
  • Use of MS Office 2016. Previous versions mayn’t have all features available.
  • Coaching by Industry Leader/ Experienced Corporate Trainer/ Professionals.
  • Accentuated with Relevant Reference Study Material.
  • Guidance & hand-holding post session, on need basis, can be arranged.

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 organization

Module 2: Working With Data - This module is all about working with data – and making it easy to work with. Learners will learn how to manage data by:

  • Filtering: AutoFilter, Filter by Colour, Date, Number and Text Filters
  • Criteria – contains, equal to, not equal to
  • Grouping & Subtotals
  • Using Sorting Options – Custom, ascending and descending, A-Z, Z-A
  • Creating Custom Lists

DATA ANALYSIS & BUSINESS REPORTING

Module 3: 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 4: 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 for productivity improvement

    • Import from Data Sources
    • Excel Shortcuts, Tips & Tricks
    • Introduction to Macros

SERVERAL INDIVIDUAL DO-IT-YOURSELF CHALLENGES & A TAKE HOME PROJECT EVERYDAY.

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

TRAINING METHODOLOGY

Tap-DC conducts these sessions in classroom style through

    • Pre & Post Training Assessments
    • Expert Lectures
    • Video playback
    • Group Discussions
    • Role Plays
    • Case Studies
    • One to One Mentoring Sessions
    • Exercises
    • Accentuated with Self-Paced Learning Material.

PROGRAM FEES - AN INVESTMENT FOR YOUR GROWTH

  • 2000/- (Including 18% GST)
  • Training Manual, Certificate of Training Completion, Stationery is included.
  • Morning/Evening High Tea & Lunch will be served in all full day training programs.

GLIMPSES OF OUR TRAINING PROGRAMS

VENUE

ADDRESS:

I-18, 3RD FLOOR,

DLF INDUSTRIAL AREA,

PHASE-1, SECTOR - 32,

FARIDABAD - 121002

(4 mins walking distance from NHPC Metro Station)