Zero to Hero Excel Course

Course Content

Introduction to Excel

What is Excel?
why use Excel?
Understanding the Excel interface (Ribbon, Toolbar, Sheets, Formulas Bar, Quick Access Tool, Name Bar)
Creating, opening, saving, and printing workbooks
Saving workbooks in different formats
Moving around the worksheet
Selecting cells, rows, and columns
Data entry, formatting, and basic navigation
Using AutoFill for sequences
Understanding cell referencing (Relative, Absolute, Mixed)

Alignment and Text Control

Conditional formatting for better visualization

Styles and Themes

Essential Excel Functions & Formulas

Data Management & Formatting

Data Visualization with Charts & Graphs

Pivot Tables & Pivot Charts

Advanced Excel Functions

Data Analysis & Power Query

Macros & VBA (Automation)

Power BI & Power Pivot

Collaboration and Sharing

Real-World Projects

Student Ratings & Reviews

No Review Yet

Course Content

Introduction to Excel

What is Excel?

why use Excel?

Understanding the Excel interface (Ribbon, Toolbar, Sheets, Formulas Bar, Quick Access Tool, Name Bar)

Creating, opening, saving, and printing workbooks

Saving workbooks in different formats

Moving around the worksheet

Selecting cells, rows, and columns

Data entry, formatting, and basic navigation

Using AutoFill for sequences

Understanding cell referencing (Relative, Absolute, Mixed)

Alignment and Text Control

Merging cells, wrapping text, and orientation

Conditional formatting for better visualization

Highlighting cells based on rules

Data bars, color scales, and icon sets

Styles and Themes

Applying built-in styles

Customizing themes

Essential Excel Functions & Formulas

Introduction to Formulas

Basic arithmetic functions: SUM, AVERAGE, MIN, MAX

Logical functions: IF, AND, OR, NOT

Lookup functions: VLOOKUP, HLOOKUP, XLOOKUP

Text functions: CONCATENATE, LEFT, RIGHT, MID, LEN, TRIM

Date and time functions: TODAY, NOW, DATE, YEAR, MONTH, DAY

Nested IF statements

Data Management & Formatting

Sorting and filtering data

Data validation (Dropdown lists, Restrictions)

Removing duplicates and handling blank cells

Data Visualization with Charts & Graphs

Creating and customizing bar, pie, and line charts

Dynamic charts using tables and named ranges

Adding trendlines and data labels

Combo charts, sparklines, and trendlines.

Pivot Tables & Pivot Charts

Creating Pivot Tables for data analysis

Using Pivot Charts to visualize Pivot Table data

Grouping, filtering, and summarizing data in Pivot Tables

Slicers and Timelines for interactivity

Advanced Excel Functions

Advanced Lookup: INDEX-MATCH

VLOOKUP, HLOOKUP, INDEX, MATCH.

Array formulas & Dynamic Arrays (FILTER, SORT, UNIQUE)

Advanced IF formulas (IFS, SWITCH)

Working with Named Ranges

Data Analysis & Power Query

Introduction to Power Query

Importing and transforming data

Merging and appending data

Cleaning data efficiently

Solver

Macros & VBA (Automation)

Introduction to Macros and Recording Macros

Modifying macro code. / Assigning macros to buttons.

Basic VBA programming for automation

Creating custom functions using VBA

Automating repetitive tasks

Power BI & Power Pivot

Introduction to Power BI

Power Pivot for handling large datasets

DAX formulas for data modeling

Collaboration and Sharing

Protecting Workbooks and Worksheets

Sharing Workbooks

Real-World Projects

Budgeting and Financial Analysis

Sales and Inventory Management

Dashboard Creation

Student Ratings & Reviews