Intermediate Excel

Languages
English + Hindi
Batch Size
18-22
Duration
7 hours
Investment
$$$$$
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

instructor_image

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