Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Practical Microsoft Excel: Excel Beginner To Advanced 2025
Rating: 4.4 out of 5(1,377 ratings)
5,343 students

Practical Microsoft Excel: Excel Beginner To Advanced 2025

Practical Microsoft Excel | Compatible with Microsoft Excel 2016, 2019, 365 | Microsoft Excel Beginner To Advanced
Created bySix Sigma Academy Amsterdam (SSAA)
Last updated 10/2025
English
English [Auto],French [Auto],

What you'll learn

  • Learn real life MS Excel skills that actually matter in practice!
  • Structure and analyze data, find patterns and visualize data.
  • Use Excel functions and save time.
  • Predict future demand, sales, needed resources etc.

Course content

6 sections • 83 lectures • 6h 0m total length

  • STRUCTURE OF THIS MS EXCEL COURSE2:29

    Structure of this Excel course is explained.

  • QUESTIONS0:50
  • HARLINGEN START1:14

    We start our Excel course in Harlingen.

  • LINKING SHEETS IN MS EXCEL4:03

    Excel allows us to link sheets. How do we do that in Excel?

  • KEYBOARD SHORTCUTS IN MS EXCEL2:33

    Maybe you use Excel on a Windows computer, maybe you use Excel on an Apple computer. Regardless, you can speed up Excel commands with shortcuts.

  • APPEARANCE OF DATA FILE IN MS EXCEL6:00

    Let's change the appearance of our Excel file.

  • BASIC REFERENCES IN MS EXCEL PART 14:33

    We can give Excel commands. Let's see how that works in Excel.

  • BASIC REFERENCES IN MS EXCEL PART 23:22

    We can give Excel commands. Let's see how that works in Excel.

  • RELATIVE & ABSOLUTE REFERENCING IN MS EXCEL7:55
  • CONDITIONAL FORMATTING IN MS EXCEL3:43
  • ADDING, REMOVING AND HIDING CELLS IN MS EXCEL3:17

    Learn to add a new column between B and C in a data file, insert rows, delete columns or rows, and hide or unhide columns to control visible data.

  • EXERCISE 1-14:32

    Practice excel skills by analyzing a shrimp sales dataset: hide the dates column, compute leftover shrimp, calculate daily revenue with absolute references, and highlight values over 100 across multiple sheets.

  • SOLUTION EXERCISE 1-13:50
  • DATA VALIDATION IN MS EXCEL6:25
  • FIND AND REPLACE IN MS EXCEL2:24
  • FREEZE PANE IN MS EXCEL3:13

    learn how to use freeze panes in MS Excel to keep the top row or first column visible while scrolling, using the view tab, freeze panes, and unfreeze when needed.

  • PATTERN RECOGNITION IN MS EXCEL1:51

    Discover how Excel recognizes patterns in sequences like days, dates, and numbers, and extend data with the fill handle, while understanding its limitations.

  • PROTECTING DATA IN MS EXCEL3:44
  • SORT & FILTER IN MS EXCEL4:29
  • INFINITE FORMULAS IN EXCEL5:14

    Copy formulas across large data sets in Excel fast with keyboard shortcuts: select with Ctrl+Shift+Down, fill down, then fill right with Ctrl+Shift+Right and Ctrl+R.

  • EXCEL EXERCISE 1-24:20

    Practice Excel tasks across shrimp, fish, and total sheets: use find and replace to correct Martha to John, compute drinks revenue, enforce numeric input for broken-glasses, and freeze header row.

  • SOLUTION EXCEL EXERCISE 1-26:42
  • SECTION 1 CONCLUSION1:04

    Conclude part one by recapping the basics of Microsoft Excel; prepare learners for the next section on Excel functions, from sum to nested functions.

Requirements

  • You preferably have access to Excel (version is not that important).

Description

Microsoft Excel Beginner to Advanced (Compatible with Microsoft Excel versions 2016, 2019, 2021, Excel Windows 365/2025)

Being able to to work with Microsoft Excel is considered to be a very important skill in today's data driven economy. But how much Microsoft Excel skills is enough and how much Microsoft Excel skills is too much? While you want to learn the needed Microsoft Excel skills for the labor market, you might not want to write a book about Microsoft Excel. What we have done is to create a Microsoft Excel course for you based on our research and experience. This Microsoft Excel course will very efficiently show you the important Microsoft Excel skills that you are supposed to have to function in practice, in a bank, a hospital, a school, a production plant etc.


We teach you to:

  • structure data with Microsoft Excel and get overview.

  • analyze data with Microsoft Excel functions and save time.

  • visualize data with Microsoft Excel and better understand relationships and trends.

  • predict future developments with Microsoft Excel.

  • build dashboards with Microsoft Excel and monitor information.

We, as seasoned lecturers, have come to the conclusion that students learn more effectively when the content is being delivered in an engaging way. This Microsoft Excel course is set up as a road trip from the North of Holland all the way To Paris, France. Along the way, we will have stops. Each stop will provide us with a context for our Microsoft Excel videos. So, you will learn about Microsoft Excel and a little bit about the history and culture of Europe.


Note: The version of Microsoft Excel you use (as long as it is not be older than 2016) is not of vital importance if you want to keep up. 


*You get a 30 day money back guarantee.

*You get a certificate of completion at the end.

Who this course is for:

  • If you work with data and need to structure, analyze and visualize it, this course is for you.

Report abuse