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 From Beginners to Expert
Rating: 4.2 out of 5(65 ratings)
6,352 students

The Complete Microsoft Excel From Beginners to Expert

Mastering Formulas, Functions, and Data Analysis for Business Professionals
Created bySkillify Academy
Last updated 8/2025
English

What you'll learn

  • Introduction to the Excel Interface
  • Move and Copy Data in Worksheet
  • Working with Rand & Randbetween
  • Working with ROUND, ROUNDUP and ROUNDDOWN
  • Date and DATEDIF Function
  • CHOOSE and SWITCH Function
  • UPPER, LOWER, PROPER & TRIM
  • LEFT, MID, RIGHT & LEN
  • SORT and SORTBY Functions
  • INDEX, MATCH, XMATCH and EXTACT Function
  • Combining EXTACT & VLOOKUP
  • Custom Data Validation
  • XLOOKUP Function
  • Creating a PivotTable from Scratch
  • Applying PivotTable Styles
  • Create a Bar, Column, Line and Pie Chat
  • Inserting and Formatting Slicers
  • Proetect Worksheet and Workbook
  • Inserting Headers and Footers
  • Printing a Workbook

Course content

1 section • 29 lectures • 3h 20m total length

  • Introduction to the Excel Interface7:32

    Explore the Excel interface, including workbooks, worksheets, the ribbon with core tabs, and the quick access toolbar, formula bar, name box, and status bar.

  • Move and Copy Data in Worksheet6:15

    Move and copy data in an Excel worksheet using drag-and-drop, cut and paste, and copying with the control key and fill handle to rearrange and duplicate data.

  • Working with Rand & Randbetween5:11
  • Working with ROUND, ROUNDUP and ROUNDDOWN6:19
  • WORKDAY and WORKDAY.INT Functions8:06
  • Date and DATEDIF Function5:57
  • EDATE and EOMONTH Function8:52
  • CHOOSE and SWITCH Function10:49
  • LEFT, MID, RIGHT & LEN7:29
  • UPPER, LOWER, PROPER & TRIM6:35

    Explore four essential Excel text functions—upper, lower, proper, and trim—that standardize case, clean spaces, and format names and titles. Learn to combine them for professional, consistent data presentation.

  • YEAR, MONTH, DAY, HOUR, MINUTE & SECOND7:23
  • SORT and SORTBY Functions8:55

    Master Excel sorting with sort and sort by functions to sort data by columns or by values from another range, in ascending or descending order, without altering the original data.

  • FILTER Function5:32

    Discover how the filter function extracts data that meets specific criteria in Excel, enabling dynamic, multi-criteria filtering and graceful handling of empty results.

  • UNIQUE Function3:59
  • INDEX, MATCH, XMATCH and EXTACT Function7:13
  • Approximate MATCH Lookups7:55
  • VLOOKUP Function7:14
  • Combining MATCH & VLOOKUP5:16
  • Combining EXTACT & VLOOKUP5:16
  • HLOOKUP Function4:04

    Explore the hlookup function to perform horizontal lookups in Excel, using the lookup value in the top row to return data from a row via exact or approximate range lookup.

  • XLOOKUP Function6:25

    Xlookup, a function replacing vlookup and hlookup, enables searches in any direction with settings like lookup value, return array, if not found, match mode, and search mode.

  • Creating Dynamic Drop-down Lists8:25
  • Creating a PivotTable from Scratch7:28

    Master pivot tables to quickly summarize, analyze, and present data by dragging fields into rows, columns, and values, then use filters to refine revenue by salesperson and product.

  • Applying PivotTable Styles6:39
  • Create a Bar, Column, Line and Pie Chat8:47
  • Inserting and Formatting Slicers5:54
  • Proetect Worksheet and Workbook6:59
  • Inserting Headers and Footers5:37
  • Printing a Workbook8:33

Requirements

  • No prior Excel experience is needed

Description

Embark on a transformative journey with The Complete Microsoft Excel: From Beginner to Expert, the only course you'll ever need to master this powerful software. Whether you've never opened Excel before or you're an intermediate user looking to unlock its full potential, this comprehensive program will guide you from the very basics to the most advanced and sought after skills in the industry.


This course is meticulously designed to provide a structured, step by step learning experience. I start with the absolute fundamentals, ensuring you have a rock solid foundation before moving on to more complex topics. Each module is built upon the last, allowing you to build your knowledge and confidence incrementally.


What You'll Learn:

  • The Absolute Basics: Get comfortable with the Excel interface, navigate worksheets with ease, and master the essentials of data entry and formatting.

  • Fundamental Formulas & Functions: Dive into the world of formulas with a clear and concise approach. You'll master essential functions like SUM, AVERAGE, MIN, MAX, and COUNT, and learn how to use them to perform quick and accurate calculations.

  • Data Organization & Management: Learn how to sort, filter, and manage large datasets efficiently. I'll show you how to use powerful tools like Text to Columns, Flash Fill, and Remove Duplicates to clean and prepare your data.

  • Essential Lookup Functions: Become a pro at finding and retrieving data. You'll master the widely used VLOOKUP and HLOOKUP, and then graduate to the more modern and powerful XLOOKUP and INDEX/MATCH combination.

  • Logical & Text Functions: Take control of your data with logical functions like IF, AND, and OR. I’ll also show you how to manipulate text strings with functions like LEFT, RIGHT, FIND, and TEXTJOIN.

  • PivotTables & Dashboards: Learn the single most important skill for data analysis. You'll master PivotTables to summarize and analyze massive datasets, and create dynamic, interactive dashboards using PivotCharts, slicers, and timelines.

  • Advanced Features: Go beyond the basics with advanced topics like Power Query for data automation, What If Analysis for forecasting, and the new Dynamic Array Functions (FILTER, UNIQUE, SORT) that are changing the way Excel users work.

  • Data Visualization: Transform raw data into compelling visuals. You'll learn to choose the right chart type for your data and create professional, impactful graphs.


Why This Course?

  • Step by step lessons starting from scratch and progressing to expert level

  • Practical examples and real world projects to apply what you learn

  • Suitable for students, professionals, and anyone eager to master Excel


By the end of this comprehensive course, you will not only have a deep understanding of Excel but also the confidence to tackle any spreadsheet challenge. You'll be able to automate tasks, analyze data with ease, and create professional reports and dashboards that make you a valuable asset to any team.


Enroll now and take the first step towards becoming an Excel Master!

Who this course is for:

  • Anyone learn everything from Excel basics to advanced features.
  • Business owners and entrepreneurs who need to manage their finances and data more efficiently.
  • Anyone who uses Excel and wants to save time and automate repetitive tasks.

Report abuse