Learn Microsoft Excel from Scratch

In this lesson, we dive into four of Excel’s most essential formulas — SUM, AVERAGE, MIN, and MAX. These functions are the building blocks of data analysis, helping you quickly total numbers, find averages, and identify the lowest and highest values in your dataset.

What you’ll learn in this video:
✅ How to use the SUM function to add numbers across rows and columns
✅ How to calculate averages with the AVERAGE function
✅ How to find the smallest number using MIN
✅ How to find the largest number using MAX
✅ Practical demo with a monthly sales dataset
✅ A quick tip: How to use the AutoSum button for faster results

Tired of repetitive typing in Excel? In this lesson, you’ll learn how to save time and reduce errors using two smart automation tools – AutoFill and Flash Fill. These features make copying formulas, detecting patterns, and reformatting data effortless.

What you’ll learn in this video:
✅ How to use AutoFill to copy formulas quickly across rows and columns
✅ How AutoFill can extend patterns like days, months, and number sequences
✅ How to use Flash Fill to split full names into first and last names
✅ How Flash Fill helps in combining or reformatting text (e.g., phone numbers, email IDs)
✅ Practical keyboard shortcut: Ctrl + E to instantly apply Flash Fill

Formula errors can look scary, but they’re actually Excel’s way of showing you what’s wrong. In this lesson, you’ll learn how to identify, understand, and fix common Excel errors like #DIV/0!, #N/A, #VALUE!, #NAME?, and #REF!. More importantly, you’ll discover how to use the powerful IFERROR() function to replace messy errors with clean, professional results.

What you’ll learn in this video:
✅ The most common Excel errors and what they mean
✅ Real-world examples of errors in formulas
✅ How to apply IFERROR() to clean up your data
✅ Practical use cases: replacing errors with “0”, blank cells, or friendly messages
✅ Keeping your spreadsheets professional and error-free

Conditional formulas are some of the most powerful tools in Excel. In this lesson, you’ll learn how to use IF, COUNTIF, and SUMIF to evaluate conditions, count qualifying entries, and sum values that meet specific criteria. These formulas are essential for anyone who wants to analyze data with precision.

What you’ll learn in this video:
✅ How to apply the IF function to check if employees met their sales targets
✅ Using COUNTIF to quickly count how many entries meet a given condition
✅ Applying SUMIF to total sales by region or category

Master some of Excel’s most powerful text functions to clean, analyze, and format data with ease. In this lesson, you’ll learn:

• How to split names into first and last using LEFT, RIGHT, and MID

• How to count characters (including spaces) with LEN

• How to combine text using CONCAT and TEXTJOIN

• Practical examples for names, codes, and custom formats

By the end of this video, you’ll be able to confidently manipulate text data — a must-have skill for data cleaning, reporting, and professional Excel use.

Perfect for beginners and intermediate learners looking to level up their Excel skills!

Working with dates in Excel is crucial for more effective planning, reporting, and tracking. In this lesson, you’ll learn how to use four powerful date functions:

TODAY() – Automatically returns today’s date (updates daily)
NOW() – Displays current date and time in real time
DATEDIF() – Calculates age, tenure, or duration between two dates (in years, months, or days)
EOMONTH() – Finds month-end deadlines or a project's future due dates

By the end of this video, you’ll be able to confidently handle deadlines, age calculations, and date-based reports in Excel — saving time and avoiding manual tracking errors.

Perfect for professionals, students, and business users who want to make Excel work smarter for them.

Looking up data is one of the most common Excel tasks — whether it’s checking a product price, employee details, or matching records from large tables. In this lesson, you’ll master two of Excel’s most powerful lookup functions: VLOOKUP and HLOOKUP.

What you’ll learn in this video:

• VLOOKUP basics – find values vertically in a table

• Step-by-step demo – pull prices by typing product names

• Limitations of VLOOKUP – why it can’t “look left”

• Error handling with IFNA() – replace #N/A errors with friendly messages

• HLOOKUP explained – when your data is structured across rows

By the end, you’ll know exactly when to use VLOOKUP vs HLOOKUP, how to structure your data, and how to handle errors gracefully — giving you the confidence to manage large datasets like a pro.

In this lesson, you’ll master INDEX + MATCH — one of Excel’s most powerful lookup combinations and a smarter alternative to VLOOKUP. We’ll start by breaking down how INDEX retrieves values by position and how MATCH finds row or column numbers. Then, you’ll learn how to combine them into dynamic, flexible lookups that work in any direction without breaking when columns are moved.

You’ll also see how to wrap your formulas with IFNA() for clean error handling, making your lookups user-friendly. By the end of this video, you’ll be able to create a fully dynamic model that instantly returns values based on different department and month inputs.

✅ What you’ll learn in this video:

• Why INDEX + MATCH is more reliable than VLOOKUP

• How to use INDEX() to fetch values from a table

• How to use MATCH() to locate row/column positions

• How to build dynamic lookups using INDEX + MATCH

• Error handling with IFNA() for missing data

• A step-by-step walkthrough with a practice dataset

Perfect for learners who want to level up from VLOOKUP and build smarter, flexible formulas in Excel.

In this lesson, you’ll discover how to use Excel’s core logical functions — AND, OR, and NOT — to build smarter formulas that check multiple conditions and return meaningful results. Starting with a student marks table, we’ll walk through step-by-step examples to validate pass/fail status, highlight excellent performers, and flag students who need extra attention.

You’ll also learn how to combine these logical functions with IF() for flexible decision-making, and finish with a bonus tip on Conditional Formatting to instantly color-code results in red/green for easier analysis.

✅ What you’ll learn in this video:

• How to use AND() when all conditions must be true

• How to use OR() when any one condition is enough

• How to use NOT() to reverse logic and flag exceptions

• Building IF + Logical combinations for smarter checks

• Bonus: Using Conditional Formatting to highlight Pass/Fail results

Perfect for learners who want to automate decisions and validations in their Excel sheets, eliminating the need for manual checks.

In this lesson, you’ll master one of Excel’s most essential data management tools — Sorting and Filtering. Whether you’re working with HR data, sales figures, or project lists, these features help you quickly organize and extract exactly the information you need.

We’ll begin with an employee dataset and walk through sorting salaries from high to low, applying filters by department, and even creating custom number filters. You’ll also learn how to perform multi-level sorting (e.g., Department first, then Salary), and how to reset everything back to the original view in one click.

✅ What you’ll learn in this video:

• How to sort data alphabetically (A–Z) or numerically (Low–High / High–Low)

• Applying filters by text, numbers, and custom conditions

• Multi-level sorting for grouped analysis

• Shortcuts: Ctrl + Shift + L to toggle filters instantly

• Clearing filters and sorts to restore your dataset

Perfect for learners who work with large datasets and want to quickly organize, analyze, and drill down into details without manual effort.

In this lesson, you’ll learn how to make your Excel sheets smarter and error-proof with Data Validation. From creating simple drop-down lists to restricting inputs and adding helpful messages, Data Validation ensures that your data stays clean, consistent, and reliable.

We’ll build a student marks entry form and apply validation step by step — including subject drop-downs, score limits, date ranges, and input messages. By the end, you’ll know how to design forms that guide users and prevent mistakes.

✅ What you’ll learn in this video:

• How to create drop-down lists using Data Validation

• Restricting inputs by number ranges, dates, and text length

• Adding input messages to guide users

• Setting up custom error alerts to prevent wrong entries

• Building a complete, validated form in Excel

Messy data slows you down — but Excel has built-in tools to fix it fast! In this lesson, you’ll learn how to clean up contact lists, names, and addresses using Remove Duplicates and Text to Columns.

We’ll walk through practical, step-by-step examples to make your data tidy and ready for analysis.

✅ What you’ll learn in this video:

• How to remove duplicate records from contact lists

• Splitting full names into First Name and Last Name

• Breaking down comma-separated addresses into multiple columns

• Using custom delimiters (space, comma, tab, semicolon, etc.)

Perfect for professionals, students, and anyone dealing with large datasets, exports, or contact lists who want to save time and avoid errors.

Ever copied something in Excel only to overwrite more than you wanted?
That’s where Paste Special comes in — giving you full control over exactly what you copy and paste.

In this lesson, you’ll learn:
✅ How to paste values only (remove formulas, keep results)
✅ How to paste formats or formulas only without disturbing your data
✅ A powerful trick to transpose data — flipping rows into columns or columns into rows

By the end, you’ll be able to flatten formulas, copy styles instantly, and reshape data layouts like a pro.

Tired of confusing formulas filled with cell references like B2:B13?
In this lesson, you’ll discover how Named Ranges can make your formulas easier to read, maintain, and share.

We’ll cover:
✅ Why Named Ranges improve readability and reduce errors
✅ Step-by-step guide to creating Named Ranges using the Name Box & Name Manager
✅ How to replace cell references in formulas with clear, meaningful names
✅ Managing, editing, and deleting ranges using Name Manager

By the end, you’ll be able to simplify your formulas and organize your workbooks like a pro.

Tired of scrolling endlessly through messy spreadsheets?
Excel’s Grouping & Outlining features let you hide the clutter and focus on what matters. With just a click, you can collapse detailed rows or columns, show only totals, and instantly create a cleaner, more professional report.

In this lesson, you’ll learn:
✅ How to group rows and columns for quick expand/collapse views
✅ Keyboard shortcuts to group/ungroup data instantly
✅ How to use Auto Outline to let Excel detect and organize subtotals automatically
✅ Tricks to show only totals for reports or printouts

By the end, you’ll be able to organize complex spreadsheets into neat, structured summaries that make analysis and reporting much easier.

Struggling to keep track of your data while scrolling through massive spreadsheets?
In this lesson, you’ll master Excel’s Freeze Panes and Split View — two powerful tools that keep your headers, labels, and key data always in sight.

You’ll learn how to:
✅ Freeze the Top Row to keep column headers visible
✅ Freeze the First Column to lock important labels (like IDs)
✅ Apply Custom Freeze Panes to lock both rows and columns together
✅ Use Split View to compare different parts of your sheet side by side
✅ Easily remove freezes or splits when you’re done

By the end, you’ll be able to navigate large datasets like a pro, without ever losing track of headers or key information.

Ready to bring your numbers to life?
In this lesson, you’ll learn how to transform raw data into clear, impactful charts — starting with the three most common ones: Column, Line, and Pie.

You’ll discover:
✅ How to set up sample sales data for charting
✅ Creating a Column Chart to compare product sales side by side
✅ Building a Line Chart to highlight trends and growth over time
✅ Designing a Pie Chart to show proportions and share of totals
✅ Key chart elements — titles, axes, legends, labels, and formatting tricks
✅ Quick customization tips to make your charts clean and professional

By the end of this video, you’ll know which chart type to use and when — so your reports, presentations, and dashboards instantly grab attention.

Make your charts not just functional — but powerful and professional.
In this lesson, you’ll learn how to style and customize Excel charts so they communicate insights clearly and grab attention instantly.

You’ll discover:
✅ How to edit Chart Titles, Legends, and Axis Labels for clarity
✅ Adding Data Labels to bars, lines, and pie charts — with values or percentages
✅ Changing colors, chart styles, and fonts for a clean, professional look
✅ Refining gridlines and axis scales to highlight the right trends
✅ Using the Format Tab for advanced polish with fills, outlines, shadows, and effects

By the end of this session, you’ll be able to transform a plain, default Excel chart into a visually impactful story that your audience can understand at a glance.

Struggling to compare two very different types of data in one chart?
That’s where Combo Charts with a Secondary Axis become a game-changer. In this lesson, you’ll learn how to combine columns and lines to clearly present both large values and smaller percentages — on the same chart.

You’ll discover:
✅ Why Combo Charts are perfect for comparing different metrics
✅ Preparing a dataset with Sales & Profit %
✅ Inserting a Clustered Column + Line Combo Chart
✅ Adding a Secondary Axis to handle different scales
✅ Formatting chart elements — titles, labels, axis bounds, and markers
✅ Customizing colors, layouts, and styles for maximum clarity

By the end of this video, you’ll know exactly when and how to use Combo Charts to turn complex data into easy-to-understand visuals.

Conditional Formatting in Excel is a game-changer for turning raw numbers into instant insights. In this lesson, you’ll learn how to automatically highlight important values, trends, and errors — without manual effort.

We’ll start with simple rules like highlighting low scores, then explore built-in options such as Top 10 items and duplicate detection. You’ll also discover how to make your data visually engaging with color scales, data bars, and icon sets — perfect for reports and dashboards.

By the end, you’ll not only know how to apply Conditional Formatting but also how to use it strategically for clarity and impact.

What you’ll learn in this video:
✔ Highlight cells with rules like “Less Than” or “Above Average”
✔ Detect duplicates and find top/bottom performers instantly
✔ Apply Color Scales, Data Bars, and Icon Sets for visual summaries
✔ Use best practices to keep formatting clean and effective

This session will help you bring your spreadsheets to life and make them tell a story at a glance.

In this lesson, you’ll discover how to transform plain data into compact visuals using Sparklines and Data Bars in Excel. These lightweight, cell-level visualizations are perfect for dashboards, trend analysis, and quick comparisons — without the need for bulky charts.

What you’ll learn in this video:

• How to insert and format Line Sparklines to show row-wise trends.

• Customizing sparklines with colors, markers, and consistent axis scaling.

• Using Data Bars via Conditional Formatting to highlight value intensity in a single column.

By the end, you’ll know exactly how to make your data visually powerful and presentation-ready — all inside your cells.

Microsoft Excel - Mini Project

Struggling to make sense of large datasets? Pivot Tables are your secret weapon! In this lesson, you’ll learn how to create powerful summaries and reports without writing a single formula.

✅ What you’ll learn in this video:

• What Pivot Tables are and why they’re so powerful

• How to insert and set up your first Pivot Table

• Understanding Rows, Columns, Values, and Filters

• Building a summary report (Total Revenue by Region)

• Adding filters, grouping dates, and breaking down data

By the end, you’ll be able to turn raw data into clean, insightful summaries — all in just a few clicks.

Unlock the full power of Pivot Tables by learning how to summarize and analyze your data in multiple ways. In this lesson, we’ll use a sales dataset to explore how to add fields, rearrange layouts, and apply different calculation types such as SUM, COUNT, and AVERAGE. You’ll see how quickly raw data can be transformed into meaningful insights — like product performance, regional breakdowns, and sales totals — all without writing a single formula.

By the end of this video, you’ll be able to:

• Insert and structure a Pivot Table with rows, columns, and values

• Summarize your data using totals, counts, and averages

• Use subtotals and grand totals to view data at a glance

• Rearrange fields to uncover hidden trends

Whether you’re tracking sales, inventory, or performance metrics, these Pivot Table skills will help you summarize large datasets with ease and confidence.

Take your Pivot Table skills to the next level by learning how to organize, filter, and sort your data for clear, actionable insights. In this lesson, you’ll discover how to group dates into months, quarters, and years, apply filters to focus on specific regions or products, and sort your results to highlight top-performing items.

By the end of this video, you’ll be able to:

• Group data by periods or custom categories

• Filter Pivot Tables to zoom in on targeted details

• Sort values to identify top/bottom performers quickly

Whether you’re preparing monthly reports, quarterly dashboards, or ranking sales by revenue, these techniques will help you transform raw data into powerful business insights.

Bring your Pivot Tables to life with Pivot Charts — dynamic visuals that automatically update as your data changes. In this lesson, you’ll learn how to insert Pivot Charts, apply interactive filters, and customize chart elements to create clear, presentation-ready visuals.

By the end of this video, you’ll be able to:

• Insert Pivot Charts directly from your Pivot Tables

• Use filters and slicers to create interactive dashboards

• Customize titles, colors, and labels for professional reports

• Present data visually for faster, clearer insights

Perfect for dashboards, client reports, and business presentations, Pivot Charts will make your data not just useful — but unmissable.

Make your Pivot Tables more interactive and user-friendly with Slicers! In this lesson, you’ll learn how to insert slicers, use them to filter data with a single click, and style them for professional dashboards.

By the end of this video, you’ll be able to:

• Insert slicers to filter Pivot Tables visually

• Use multiple slicers for layered analysis

• Apply professional styles and layouts for reports

• Build interactive dashboards that impress

Slicers turn your Pivot Tables into dynamic, clickable reports — no more dropdown menus, just instant insights.

Sharing your Excel files with others? Don’t let accidental edits ruin your formulas or layouts! In this lesson, you’ll learn how to protect your worksheets and lock or unlock specific cells so users can only edit what you allow.

What you’ll learn in this video:

• How cell locking works by default in Excel

• Unlocking specific input cells for data entry

• Applying sheet protection with or without a password

• Allowing only certain actions (like selecting unlocked cells)

• How to unprotect a sheet when changes are needed

By the end of this video, you’ll be able to build error-free Excel sheets where users can safely enter data without breaking formulas. Perfect for budgets, reports, and professional templates!

Learn how to hide and unhide sheets, rows, and columns in Excel without losing data.
In this lesson, you’ll discover how to:
✔ Hide sensitive or helper data in rows and columns
✔ Unhide content with simple right-click or shortcut methods
✔ Hide and restore entire worksheets

This feature is perfect for keeping your workbooks clean, protecting sensitive information, and improving readability — all while keeping your data safe.

Make your Excel workbooks more interactive and collaborative with hyperlinks and comments.
In this lesson, you’ll learn how to:
✔ Insert hyperlinks to navigate between sheets, workbooks, websites, and email addresses
✔ Use comments for modern team collaboration with @mentions and threaded discussions

These features are especially powerful when working on shared projects or large datasets — helping you save time, improve teamwork, and keep your files organized.

Master the art of printing in Excel without cut-offs or messy layouts.
In this lesson, you’ll learn how to:
✔ Adjust page layout with margins, orientation, and paper size
✔ Define a print area to focus only on what matters
✔ Add headers and footers with titles, dates, and page numbers
✔ Preview your report before printing to avoid mistakes

By the end, you’ll be able to create polished, professional printouts of your Excel sheets — perfect for reports, presentations, or record-keeping.