Intermediate Excel

English + Hindi
Batch Size
7 hours
Request Training Proposal

Course Contents

The training will help you discover a whole new set of Excel functionalities which can be applied to day-to-day tasks to save time and effort to a great extent. Learn a whole new range of Excel formula.

  • Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch.
  • Automate, streamline, and completely revolutionize your workflow with Excel.
  • Master unique tips and tools.
  • Important formula covered in details.
  • Go rogue and design your own formula-based Excel formatting rules.
  • Discover multiple functionalities in Excel like LOOKUP and many more.

  1. Quick Tour of Excel:
    ● Excel Workbook, Worksheet, Cell Structure
    ● Quick Tour of Excel - Ribbon & Quick Access Toolbar
    ● Summary: Important Points to Remember (Terminology & Shortcuts)
  2. Lookup function in Excel
    ● Introduction
    ● Working with Named Ranges
    ● Counting Rows & Columns with ROW/ROWS & COLUMN/COLUMNS
    ● Introduction to VLOOKUP
    ● Joining Data with VLOOKUP
    ● Fixing Errors with IFERROR & VLOOKUP
    ● VLOOKUP Reference Array Options
    ● Approximate Match Lookups
    ● Navigating Cell Ranges with INDEX
    ● Matching Text & Values with MATCH
    ● Combining INDEX & MATCH to Dynamically Search Ranges
    ● Combining MATCH & VLOOKUP for More Flexible Lookups
  3. Conditional Statement & Logical Operator
    ● IF Statement
    ● Nesting Multiple IF Statement
    ● Adding Conditional AND/OR Operators
    ● Using NOT & "<>" Conditionals
    ● Fixing Errors with IFERROR
  4. Advance Excel function
    ● Solver and Goal seek function for forecasting
    ● Let’s learn to back calculate your expected Income
  5. Making life easier with Excel Pivots
    ● Sort, filter, Group data
    ● Aggregating & Summarizing Data with Pivot Tables
    ● Visualizing Data with Excel Pivot Charts
    ● Pivot table real life case study: Analyzing stock market data and Apple App Store Data with Pivot tables

Instructor Profile


Advanced Excel knowledge with success in maintaining and organizing data, including dictionaries, power pivot, power query and cross-reference indexes across a broad range of industries.

This course includes:

  • 100% Online Sessions
  • Instructor led
  • Customizable Syllabus
  • Customizable Schedule
  • Certificate of Completion
  • Training Recordings
  • Training Resources
  • Learner Assessment
Request Training Proposal

Related courses