Excel Intermediate Course (Total: 16 Hours)

Objective: Enhance efficiency by learning data analysis tools, advanced formulas, and data visualization techniques.

Click Here for Excel Beginner Course.

Module 6 : Advanced Formatting & Data Validation (2 Hours)

  • Conditional formatting rules (color scales, icon sets, formulas)
  • Data validation (drop-down lists, input messages, error alerts)
  • Custom number formats
  • Cell protection and worksheet security

Module 7 : Advanced Formulas & Functions (3 Hours)

  • Logical functions: IF, AND, OR, NOTCell formatting (font, colors, borders, alignment)
  • Lookup functions: VLOOKUP, HLOOKUP, XLOOKUP
  • Text functions: LEFT, RIGHT, MID, LEN, CONCATENATE, TEXTJOIN
  • Date and time functions: TODAY, NOW, DATEDIF, EDATE, WORKDAY

Module 8: Data Sorting, Filtering & Tables (2 Hours)

  • Sorting data (single and multiple criteria)
  • Advanced filtering options (AutoFilter, Custom Filter)
  • Creating and managing Excel Tables
  • Removing duplicates and cleaning data

Module 9: PivotTables & PivotCharts (3 Hours)

  • Creating and customizing PivotTables
  • Grouping, filtering, and summarizing data
  • Creating PivotCharts for visual analysis
  • Slicers and timelines for interactive filtering

Module 10: Introduction to Data Analysis Tools (3 Hours)

  • What-If Analysis (Goal Seek, Data Tables, Scenario Manager)
  • Descriptive statistics using Excel
  • Introduction to Solver for optimization problems
Enroll Now

This course provides a structured learning path from beginner to advanced Excel skills, covering data analysis, automation, business intelligence tools, and real-world applications.

Scroll to Top