iCademy :: Courses

What you'll learn

Master Core Functionality: Perform seamless data entry, formatting, and use fundamental formulas ($SUM$, $AVERAGE$, $IF$) with absolute and relative cell referencing.
Advanced Data Retrieval: Implement powerful lookup functions like XLOOKUP, VLOOKUP, and INDEX-MATCH to connect disparate data sets.
Dynamic Data Analysis: Summarize massive datasets using PivotTables, Slicers, and Power Query for automated data cleaning.
Interactive Dashboards: Create professional-grade visualizations and interactive reports using advanced charting and Conditional Formatting.
Automation & Macros: Record and edit VBA Macros to automate daily reports and simplify complex workflows.

Course Content

5 sections • 20 lectures • 3min total length

Navigation, Interface, and Selection Techniques

00:08
Basic Formulas: Addition, Subtraction, Mean, and Count

00:11
Cell Referencing: Relative ($A1$) vs. Absolute ($\$A\$1$)

00:14
Formatting Cells and Printing Professional Reports

00:12

Sorting and Multi-Level Filtering

00:07
Logical Functions: IF, Nested IF, AND, OR, and IFERROR

00:13
Data Validation: Creating Drop-Down Lists

00:08
Text Functions: TRIM, CONCATENATE, and FLASH FILL

00:11

Mastering VLOOKUP and HLOOKUP

00:07
The Power of XLOOKUP (Horizontal & Vertical)

00:11
INDEX and MATCH: Why it’s better than VLOOKUP

00:10
Dynamic Array Functions: UNIQUE, SORT, and FILTER

00:11

Creating and Modifying PivotTables

00:07
Grouping Data and Calculated Fields in Pivots

00:11
Advanced Charting: Combo Charts and Sparklines

00:07
Building an Interactive Dashboard with Slicers

00:10

Intro to Power Query: Automating Data Cleaning

00:11
What-If Analysis: Goal Seek and Scenario Manager

00:11
Introduction to Macros: Recording your first Automation

00:11
Basic VBA: Editing Code for Custom Workflows

00:08

Requirements

Basic Computer Literacy: Familiarity with using a keyboard, mouse, and managing files on Windows or Mac.
Software Access: Access to Microsoft Excel (2019, 2021, or Office 365 recommended).
No Prior Math/Coding Skills: We start from the absolute basics; a general comfort with numbers is all you need.
Curiosity for Data: A desire to solve problems and improve efficiency in professional tasks.

Industrial Training/ Market Trend

High Demand for Data Literacy: Over 80% of administrative, management, and finance roles specifically list "Advanced Excel" as a mandatory skill in 2025.
Transition to XLOOKUP and Dynamic Arrays: Modern companies are moving away from older functions toward more robust tools like XLOOKUP and FILTER for efficiency.
Automation via Power Query: Industry is shifting from manual data cleaning to "Get & Transform" (Power Query), saving up to 90% of data preparation time.
The Excel + AI Synergy: The integration of AI (like Copilot in Excel) requires users who understand the underlying logic of formulas to prompt and audit results correctly.

Description

In today’s data-driven world, Excel remains the most essential tool for professionals across all industries. This course provides a comprehensive roadmap starting from fundamental spreadsheet operations to advanced business intelligence techniques. You will learn to clean messy data, perform complex logical analysis, build interactive visual dashboards, and use VBA to automate repetitive tasks. Whether you are in Finance, HR, Marketing, or Operations, this course will empower you to turn raw data into actionable insights and save hours of manual work.