Excel Foundation for Analytics

A Comprehensive hands on foundation program covering the basic and advanced analytics over Excel. Training program leverages the critical functions of Excel to impart the analytics thinking and begin the journey into advanced analytics.

Course Outline:
  • Module 1: Understanding the Excel
  • Module 2: Usage of Formula
  • Module 3: Excel Functions & Formulas
  • Module 4: Writing Advanced Formula
  • Module 5: Data Analysis
  • Module 6: Macros
  • Module 7: Compatibility
Learn How to:
  • Use Functions of Excel for Analytics and Data Management
  • Basic and Advanced Analytical functions
  • Leveraging Formula and Functions for Analytics
  • Handling Macros
  • Problem Solving using Analytics on Excel
Topic 1: Understanding Excel
  • Architecture of Spreadsheet
  • Excel Interface
  • Different types of values
  • ​Characteristics of Excel
  • Entering Values into Excel
Topic 2: Usage of Formula
  • Understanding a Formula
  • Rules of the Formula
  • Understanding the Syntax
  • Different Categories of Functions
  • Characteristics of Arguments
  • Types of Cell References
  • Define Names
Topic 3: Excel Functions and Formula
  • 70+ Excel Functions includes
  • Mathematical Functions (SUM, SUMIF, SUMIFS, AGGREGATE, SUBTOTAL, SUMPRODUCT etc.,)
  • Text Functions (LEFT, RIGHT, MID, LEN, FIND, SUBSTITUTE etc.,)
  • Logical Functions (IF, IFERROR, AND, OR etc.,)
  • Lookup Functions (VLOOKUP, HLOOKUP, CHOOSE, INDEX, MATCH, INDIRECT etc.,)
  • Financial Functions (FV, PV, NPV, IRR, RATE etc.,)
  • ​Statistical Functions (AVERAGE, MAX, MIN, COUNT, RANK etc.,)
  • Date & Time Functions (DATE, MONTH, YEAR, DATE, WEEKDAY, DATEDIF etc.,)
Topic 4: Writing Advanced Formula
  • Writing Nested Formula
  • Array Functions
  • Re-Engineering of Formula
  • Formula Auditing
  • ​Watch Window
Topic 5: Data Analysis
  • Text to Columns
  • Sorting includes Custom Sorting
  • Filtering includes Advanced Filtering
  • Consolidation of more Datasets
  • Using Subtotals
  • Pivot Tables for
    • Range
    • Tables
    • External Data
  • Charts
  • Data Validation
Topic 6: Macros
  • Recording a Macro
  • Editing the Recorded Macro VBA Code
  • Saving the Macro for all workbooks
  • Assigning a Shortcut or Button to Macro
Topic 7: Compatibility
  • Comparison of Version 2007 Vs Version 2010 Vs Version 2013 Vs 2016
    • Sparklines
    • Slicers
    • Timeline
    • Flash Fill
    • Recommended Charts / Pivot Tables
    • Relationships under Pivot Table
    • Query etc.,

Fees & Details:

  • Mode: Online LIVE
  • Date: 9th Dec, 2019 to 3rd Jan, 2020
  • Time: 06:30 AM to 08:30 AM
  • Fees: INR 5,000