Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
The Complete Microsoft Excel Course: Beginner to Advanced
Rating: 3.7 out of 5(52 ratings)
4,581 students

The Complete Microsoft Excel Course: Beginner to Advanced

Master Microsoft Excel From Basics to Advanced Techniques, Including Formulas, Data Analysis & Automation for Success.
Created byBrighter Futures Hub
Last updated 9/2025
English

What you'll learn

  • Navigating the Excel Interface
  • Understanding Workbooks, Worksheets, and Cells
  • Date and Time Functions
  • Sorting and Filtering Data
  • Removing Duplicates
  • Logical Functions: AND, OR, NOT
  • Conditional Functions: IF, IFS
  • TEXT functions: CONCATENATE, LEFT, RIGHT, MID
  • Mathmetical Functions: SUM, AVERAGE, COUNT, ROUND
  • Lookup Function: INDEX, MATCH, VLOOKUP, HLOOKUP
  • Bar Chart
  • Pie Chart
  • Bubble Chart
  • Line Graph
  • Creating and Managing Excel Tables amd more

Course content

1 section • 21 lectures • 2h 28m total length

  • Navigating the Excel Interface4:52

    Navigate the Excel interface to support data analysis, modeling, and reporting by exploring the ribbon, tabs, Quick Access Toolbar, name box, formula bar, worksheet area, sheet tabs, and status bar.

  • Understanding Workbooks, Worksheets, and Cells3:19

    Explore how workbooks, worksheets, and cells organize data in Excel, using tabs, sheets, rows, and columns to manage sales data and basic file saving with extensions.

  • Date and Time Functions9:52
  • Sorting and Filtering Data7:13

    Learn to sort data in Excel by columns and filter lists to meet criteria, using the data tab to sort from A to Z or by salary values.

  • Removing Duplicates4:19

    Learn how to remove duplicates in Excel to clean data, using the whole dataset or per-column checks, and highlight duplicates with conditional formatting.

  • Logical Functions: AND, OR, NOT6:40

    Master and, or, and not in Excel to build conditional formulas for passing criteria and dashboards, using example data to illustrate true and false outcomes.

  • Conditional Functions: IF, IFS5:33

    Explore conditional functions in Excel, including IF and IFS, to evaluate scores and determine pass or fail based on a 60 threshold, with practical examples.

  • TEXT functions: CONCATENATE, LEFT, RIGHT, MID6:26

    Explore four powerful text functions in Excel—concatenate, left, right, and mid—to combine data, extract initials and IDs, and streamline customized reports.

  • Mathmetical Functions: SUM, AVERAGE, COUNT, ROUND6:05

    Explore how to use Excel's sum, average, count, and round functions on a sample data set of sales units and prices, and learn to create a table for accurate calculations.

  • Lookup Function: INDEX, MATCH, VLOOKUP, HLOOKUP8:58

    Explore how to use vlookup and hlookup to search values by column or row, and index and match to locate student grades in large data sets.

  • Bar Chart5:34
  • Pie Chart6:28
  • Area Chart6:49

    Learn to create an area chart in Excel to visualize monthly sales trends for two products, add data labels and a chart title, and keep the design simple for clarity.

  • Heatmap Chart10:21

    Learn to create a heat map chart in Excel to visualize monthly sales across products and regions, using conditional formatting and color scales to highlight highs and lows.

  • Scatter Plot Chart7:10

    Create a scatter plot in Excel from a sample data set, convert to a table, insert the chart, and add a trend line to analyze study hours and exam scores.

  • Bubble Chart8:56

    learn to create and customize a bubble chart in Excel that compares unit sold, revenues, and profit margins, set data labels, and title the chart 'sales performance by product'.

  • Line Graph5:14
  • Waterfall Chart6:51

    Learn to create waterfall charts in Excel to visualize how starting balances, revenues, and expenses drive net profit. The video covers data setup, inserting the chart, and interpreting changes.

  • Using Excel Functions for Data Transformation9:54

    Learn to transform messy data in Excel by applying data transformation functions for cleaning, reshaping, and converting names, departments, dates, and salaries into a usable, analyzable table.

  • Creating and Managing Excel Tables7:03

    Learn to create and manage excel tables, name and style them, enable the total row, and use sort, filter, and sum functions for dynamic data ranges.

  • Advanced Data Analysis Techniques with PivotTables10:59

    Unlock advanced data analysis techniques in Excel by building pivot tables, grouping data, and using calculated fields, filters, slicers, and timelines to create dynamic dashboards.

Requirements

  • No prior Excel experience needed.

Description

Master Microsoft Excel from the basics to the most advanced functions, formulas, and data analysis techniques. Become an Excel Power User in just one comprehensive course!


Master Microsoft Excel from the ground up and unlock the full power of spreadsheets for personal, academic, and professional success. Whether you are just starting out or want to take your skills to an advanced level, this comprehensive course will guide you step by step through everything you need to know about Excel.


From building your very first spreadsheet to creating automated dashboards and advanced data models, this course covers it all. With practical examples and handson exercises, you’ll gain the skills to confidently use Excel in any career path—business, finance, data analysis, project management, and beyond.


What You’ll Learn:

  • Navigating the Excel interface with ease

  • Entering, formatting, and organizing data

  • Basic formulas and functions (SUM, AVERAGE, COUNT, etc.)

  • Essential tools: sorting, filtering, and conditional formatting

  • Advanced formulas and logical functions (IF, AND, OR, nested formulas)

  • Lookup functions: VLOOKUP, HLOOKUP, INDEX & MATCH, XLOOKUP

  • Working with tables, named ranges, and structured references

  • Data validation, what if analysis, and scenario tools

  • Mastering PivotTables & Pivot Charts for dynamic data analysis

  • Creating professional reports and interactive dashboards

  • Advanced charting and data visualization techniques


Why Enroll in This Course?

  • Start as a beginner and progress to an advanced Excel user in one course.

  • Work on real world datasets and exercises for immediate application.

  • Excel proficiency is one of the most indemand skills for professionals worldwide.

  • Learn with structured lessons, examples, and walkthroughs.


By the end of this course, you’ll have the ability to build complex spreadsheets, analyze data, create reports, and even automate repetitive tasks in Excel. You’ll gain lifelong skills that can transform how you work with data and help you stand out in your career.


Take the leap today and become a Microsoft Excel expert from beginner to advanced!

Who this course is for:

  • Anyone who wants to confidently use Excel for personal or professional tasks
  • Beginners who want to learn Excel from scratch
  • Professionals who need Excel for reporting, data analysis, or productivity
  • Students who want to boost their academic projects with Excel skills
  • Analysts, accountants, managers, and entrepreneurs seeking to streamline work with data-driven tools

Report abuse