Intermediate Excel Training

Live Online & Classroom Enterprise Training

Builds on Excel fundamentals with advanced formulas, pivot tables, data validation, and dashboards. Enhances productivity in data analysis and reporting.

Looking for a private batch ?

REQUEST A CALLBACK

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is Intermediate Excel Training about?

Intermediate Excel focuses on enhancing productivity and analytical capabilities using Excel. Learners will master functions, tables, charts, pivot tables, and conditional formatting while understanding shortcuts and best practices to work with large datasets efficiently. This course is ideal for professionals who want to improve their Excel expertise for real-world business applications.

What are the objectives of Intermediate Excel Training ?

Learn advanced formulas and functions for data analysis.
Create and manage PivotTables and PivotCharts effectively.
Utilize conditional formatting and data validation for better insights.
Automate repetitive tasks using macros and shortcuts.
Analyze and visualize data with charts and dashboards.

Who is Intermediate Excel Training for?

Office professionals looking to enhance Excel skills.
Data analysts and business analysts.
Finance, accounting, and marketing professionals.
Students preparing for corporate roles.
Anyone who wants to handle data efficiently in Excel.

What are the prerequisites for Intermediate Excel Training?

Prerequisites:

Basic knowledge of Excel (cells, rows, columns, basic formulas).
Familiarity with simple functions like SUM, AVERAGE.
Understanding of basic formatting tools.
Knowledge of saving, opening, and editing Excel files.
Comfortable navigating Excel interface.

Learning Path:

Basic Excel
Intermediate Excel
Advanced Excel
Excel for Data Analysis
Excel Dashboards.

Related Courses:

Advanced Excel & VBA
Excel for Data Analysis
Excel Dashboard & Reporting
Power Query & Power Pivot in Excel

Available Training Modes

Live Online Training

2 Days

Course Outline Expand All

Expand All

Module 1: Introduction

Course Introduction

Module 2: Spreadsheet Fundamentals for Good Design

Design Better Spreadsheets

Improve Readability with Cell Styles

Control Data Input: Data Validation

Add Navigation Buttons

Create a Summary Sheet

Use Forms to Input Data Quickly

Module 3: Make Better Decisions with Logical Functions

Logical Functions: Basic Recap

Logical Functions: AND and OR

Nested IF Statements

The IFS Function: Simplified Nested Ifs

Conditional IF: COUNTIFS and SUMIFS

Error Handling with IFERROR and IFNA

Use Logical Functions with Conditional Formatting

Module 4: Work with Lookup Formulas

VLOOKUP: Exact and Approx Match

Horizontal Lookups: HLOOKUP

Flexible Lookups: INDEX and MATCH

Modern Lookups: XLOOKUP and XMATCH

Lookups with Duplicates

Lookups with the CHOOSE Function

The SWITCH Function

Module 5: Sort and Filter Like a Pro!

Sort on Multiple Columns

Sort with a Custom List

The SORT and SORTBY Functions

The FILTER Function

Extract and Sort Unique Values

Module 6: Compare Data

Find Duplicates with Conditional Formatting

Find Duplicates with Formulas

Module 7: Statistical Functions

Use Mean, Median and Mode

The LARGE and SMALL Functions

Rank and Rank Average

The SUBTOTAL and AGGREGATE Functions

Module 8: Math Functions

ROUND Values

Special Rounding

Module 9: Formatting

Custom Formatting Explained

Practical Uses of Custom Formatting

Advanced Conditional Formatting

Module 10: Work with Date and Time

Understand Dates and Times

Apply Custom Formats

Common Time and Date Functions

WORKDAY and NETWORKDAYS

Calculate Dates with EDATE and EOMONTH

Module 11: Text and Array Manipulation

Import Data from a Text File

Clean a Dataset

Clean a Dataset with Power Query

Split Data: Text to Columns

Split Data: The TEXTSPLIT Function

Split Data: TEXTBEFORE and TEXTAFTER

Join Data: CONCAT and TEXTJOIN

TOCOL and TOROW

WRAPROWS and WRAPCOLS

TAKE and DROP

CHOOSECOLS and CHOOSEROWS

Module 12: Analyze Data with PivotTables

PivotTables Explained

Create a PivotTable from Scratch

Pivot the Fields

Apply Number Formatting and Totals

Show Values As and Summarize By

Group PivotTable Fields

Format Error Values and Empty Cells

Choose a Report Layout

Apply and Modify PivotTable Styles

Module 13: Pivot Charts

Create a Pivot Chart

Formatting a Pivot Chart

Using Map Charts

Module 14: Add Interaction to PivotTables and Charts

Insert Slicers

Format Slicers

Insert Timeline Slicers

Connect Slicers to Pivot Charts

Update PivotTable Data

Module 15: Formula Auditing

Troubleshoot Common Errors

Trace and Evaluate Formulas

Module 16: Data Validation

Dynamic Drop-down Lists

Input Messages and Error Alerts

Who is the instructor for this training?

The trainer for this Intermediate Excel Training has extensive experience in this domain, including years of experience training & mentoring professionals.

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree