Lookup and reference functions (VLOOKUP, HLOOKUP, INDEX, MATCH).

  • Home
  • / Courses
  • / Lookup and reference functions (VLOOKUP, HLOOKUP, INDEX, MATCH).
Course Content
Excel Basics Review
0/1
Quick recap of formulas, formatting, and basic functions.
Advanced Functions
0/2
Logical functions (IF, AND, OR).
Lookup and reference functions (VLOOKUP, HLOOKUP, INDEX, MATCH).
Data Management
0/2
Data validation and filtering.
Sorting and conditional formatting.
Data Analysis
0/2
Pivot tables and charts.
Analyzing data trends with Sparklines.
Automation with Macros
0/3
Recording and running macros.
Recording and running macros.
Introduction to VBA for custom automation.
Advanced Excel
Previous
Next

      © 2024 Montek Learning Solution. All Rights Reserved.