top of page
Ananta final logos (2) (1)_IMGCentury_edited.png

Deep dive with real world use cases, solve like professionals

Take your Excel skills to the next level! This intermediate course dives deeper into powerful functions, data organization techniques, and visualization tools. Learn to handle larger datasets, create dynamic charts, and utilize features that streamline your workflow for more sophisticated analysis."

Starts On:

29 July 2025

Intermediate

On Offer

Download Brochure
Contact Us

This Course includes :

Live lectures

QnA Sessions for doubts

Practical Understanding

Career guidance and mentorship

Round the clock support

Completion Certificate

What you'll learn

  • Conditional Formatting for Data Highlighting

  • Working with Tables (Sorting, Filtering, Slicers)

  • Using Logical Functions (IF, AND, OR)

  • Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)

  • Text Functions (CONCATENATE, LEFT, RIGHT, TRIM)

  • Creating and Customizing Charts (Line, Bar, Pie, Scatter)

  • Introduction to PivotTables for Summarizing Data

Curriculum

  • Module 1: Advanced Formatting & Tables
    Description: Go beyond basic formatting with Conditional Formatting rules to highlight data based on criteria. Learn to convert data into Excel Tables for easier management, sorting, and filtering.

  • Module 2: Powerful Lookup Functions
    Description: Master essential lookup functions like VLOOKUP and HLOOKUP to retrieve specific data from large datasets. Get an introduction to the more versatile XLOOKUP for modern data retrieval.

  • Module 3: Logical & Text Functions
    Description: Utilize IF, AND, and OR functions for decision-making within your spreadsheets. Explore text functions like CONCATENATE, LEFT, RIGHT, and TRIM to manipulate string data.

  • Module 4: Dynamic Charting
    Description: Create various chart types (column, bar, line, pie, scatter) to visualize your data effectively. Learn to customize chart elements, add trendlines, and make your charts dynamic.

  • Module 5: Introduction to PivotTables
    Description: Discover the power of PivotTables for summarizing, analyzing, and exploring large datasets. Learn to create basic PivotTables, add fields, and change summary calculations.

Requirements

MS Office, Computer or laptop, Internet connection

Description

"Take your Excel skills to the next level! This intermediate course dives deeper into powerful functions, data organization techniques, and visualization tools. Learn to handle larger datasets, create dynamic charts, and utilize features that streamline your workflow for more sophisticated analysis."

Excel Intermediate - Solve Real World Problems

 Course Duration

25 days

₹

6000

50% Off!

Login Please!
Purchase
bottom of page