Learn to Use Excel

Excel interface & basic navigation

Understanding common Functions

Formatting & Conditional Formatting

Charts and Data Visualisation

Pivot Tables & Power Query

Macros & explore VBA to automate tasks

& a lot more — get a Certification!

Overview of Excel and its applications

Understanding the Excel interface

Ribbon, Quick Access Toolbar, Workbook

Basic navigation and shortcuts

Saving, opening, and managing files

Entering and editing data (text, numbers, dates)

Formatting cell (Fonts, alignment, borders etc)

Basic mathematical operations

Introduction to AutoFill and Flash Fill

Sorting and filtering data

Using conditional formatting

Data validation and drop-down lists

Removing duplicates

Understanding formulas and cell references

Relative, absolute, and mixed references

Common functions:

Math: SUM, AVERAGE, MIN, MAX

Text: CONCATENATE, LEFT, RIGHT, LEN, TRIM

Logical: IF, AND, OR, NOT

Lookup: VLOOKUP, HLOOKUP, XLOOKUP

Date & Time: TODAY, NOW, DATEDIF, WORKDAY

Creating and customizing charts

Understanding chart elements

Advanced charts

Using PivotCharts

Creating and formatting pivot tables

Sorting, filtering, and grouping data

Using slicers and timelines

Calculated fields and PivotCharts

Creating, formatting, and filtering

Advanced data analysis functions

Index, Match, Offset

Goal Seek and Solver

What is a Macro?

Recording and running macros

Relative vs Absolute macros

Basics of VBA and VBE environment

Objects, Modules, and Variables

Conditional Statements

Loops

Error handling and debugging

Automating tasks with VBA