Name: Microsoft Excel - Excel from Beginner to Advanced
Rating: 4.7 (534619 reviews)

Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Created byKyle Pew • 2,000,000+ Students, Office Newb

Last updated 3/2026

English

What you'll learn

Create and manage organized, professional Microsoft Excel spreadsheets from scratch
Master essential Excel functions like SUM, VLOOKUP, IF, and more
Analyze large Excel data sets with confidence and find key insights
Build dynamic reports using Excel PivotTables and visualizations
Automate repetitive tasks efficiently with Excel Macros and VBA
Design interactive dashboards and reports with Excel PowerPivot
Use advanced Excel functions to tackle real-world business problems
Improve productivity with time-saving Excel shortcuts and best practices
Gain the confidence to solve complex Excel tasks with ease

Course content

45 sections • 349 lectures • 22h 22m total length

Ask Questions4:17
Participants are encouraged to ask questions throughout the course to enhance their understanding.
Course Exercise Files - DOWNLOAD1:22
Downloadable exercise files are provided to facilitate hands-on learning.
Certificate of Completion1:49
Upon course completion, participants have the opportunity to earn a certificate as recognition.

Launching Excel2:04
Learn how to open Microsoft Excel and access its features.
Microsoft Excel Startup Screen1:47
Explore the initial screen and its functionalities.
Introduction to the Excel Interface4:41
Get acquainted with the Excel user interface.
TIP - Hide Excel Ribbon1:45
Hide the Excel ribbon to save screen space by double-clicking a tab; collapse and expand it to access commands on tabs like Home, Insert, Draw, and Page Layout.
TIP - Customizing the Excel Quick Access Toolbar2:19
Discover how to personalize the Quick Access Toolbar for efficiency.
Understanding the Structure of an Excel Workbook3:48
Gain insight into the structure of Excel workbooks.
Saving an Excel Document3:42
Understand the process of saving Excel files.
Opening an Existing Excel Document2:22
Learn how to access and work with previously created Excel files.
Common Excel Shortcut Keys2:51
Master essential keyboard shortcuts for increased productivity.
Microsoft Excel Shortcut Keys Resource0:05
Excel Fundamentals Quiz

Entering Text to Create Excel Spreadsheet Titles3:57
Explore techniques for entering text to create informative spreadsheet titles.
Entering Column Header Text for Excel Spreadsheet3:04
Enter date headers above each column in Excel, using regional date formats; see dates align to the right while text values stay left, and adjust column width as needed.
Using Excel Autofill for Dates3:29
Learn how to use the Excel autofill for dates to extend a date series by dragging the fill handle, then choose fill months to create monthly headers.
Working with Numeric Data in Excel2:23
Understand how to input and manipulate numeric data effectively.
Working with Cell References2:59
Master the use of cell references in Excel formulas.
Microsoft Excel Basic Mathematical Operators3:10
Explore basic mathematical operators in excel, including addition, subtraction, multiplication, division, and exponents, with parentheses to control order of operations in formulas like summing cells and multiplying price by quantity.
DOWNLOAD - Formulas Exercise File0:05
Excel Addition Formulas4:36
Get hands-on experience in creating basic Excel formulas.
Excel Multiplication Formulas1:11
Learn to use the Excel multiplication operator to calculate total amounts by multiplying price by quantity in a simple item table.
BONUS - More Excel Formula Examples3:01
Calculate monthly gross pay using hourly pay, hours per week, and weeks per month; compute the savings amount as 15 percent and determine what's left over after savings.
Using Parenthesis in Excel Formulas3:35
Compute total travel time by dividing distance by speed and adding rest time, using parentheses to clarify order of operations in Excel formulas.
Adding Total Formulas to the Monthly Budget Spreadsheet2:26
Apply addition formulas using cell references in a monthly budget spreadsheet to calculate February totals and a grand total, improving accuracy and maintainability of your Excel workbooks.
Working with Relative References in Formulas4:20
Master the art of building formulas with relative references and autofill to save time, replace tedious manual sums, and automatically adjust references when copied across cells.
TIP - Show & Hide Excel Formulas2:58
Discover how to show and hide Excel formulas, audit worksheet formulas, and quickly edit formulas using the formula bar and Ctrl + tilde shortcut.
Relative Versus Absolute Cell References in Formulas5:13
Differentiate between relative and absolute cell references.
Understanding the Order of Operation (DOWNLOAD EXERCISE FILE)6:05
Grasp the order in which Excel calculates formula operations.
Entering and Editing Text and Formulas Quiz

The structure of an Excel Function5:35
Learn about the components and structure of Excel functions.
Working with the SUM() Function4:47
Understand how to use the SUM function to total values.
Adjacent Cells Error in Excel Calculations2:52
Understand and troubleshoot errors that may occur in Excel calculations.
Working with the AVERAGE() Function2:40
Discover how to calculate averages using the AVERAGE function.
Working with the MIN() and MAX() Functions2:44
Explore the MIN and MAX functions for finding minimum and maximum values.
Working with the COUNT() Function2:34
Learn to count cells containing data with the COUNT function.
Using the AutoSum Command4:24
Simplify summation with the AutoSum command.
Excel's AutoSum Shortcut Key1:47
Speed up calculations with a handy keyboard shortcut.
Using the AutoFill Command to Copy Formulas2:32
Efficiently replicate formulas using the AutoFill command.
Basic Excel Functions Quiz

Intro to Modifying Excel Worksheets0:58
Learn to copy, cut, and paste data within and across worksheets, modify structure by inserting or deleting rows and columns, hide content, and manage worksheets by inserting, deleting, or renaming.
Moving Data in an Excel Worksheet2:08
Learn how to rearrange and duplicate data within a worksheet.
Copying Excel Data2:44
Copy data between sheets using copy and paste, and create a new worksheet to paste into. After pasting, adjust absolute references in formulas and fill down as needed.
Changing the Width and Height of Cells3:34
Customize cell dimensions to accommodate your data.
TIP - Fixing the ##### Marks in an Excel Column1:24
Fixes the issue of #### appearing in narrow Excel columns by auto-fitting column widths; double-click the boundary between column headers to display dates and numbers properly.
Hiding and Unhiding Excel Rows and Columns2:21
Control the visibility of rows and columns as needed.
Renaming an Excel Worksheet1:58
Learn how to rename worksheets to improve organization.
Deleting Excel Worksheets2:25
Discover methods for adding or removing rows and columns.
Moving and Copying an Excel Worksheet3:29
Master techniques for relocating or duplicating entire worksheets.
Modifying Worksheets Quiz

Introduction to Formatting Data in an Excel Worksheet1:16
Explore formatting data in an Excel worksheet to improve readability and clarity. Adjust fonts, colors, borders, and sizes, and format currencies or dates, and add images.
Working with Font Formatting Commands4:30
Explore font formatting options to style your text.
Changing the Background Color of a Cell4:58
Customize cell backgrounds for visual impact.
Adding Borders to Cells3:32
Apply borders to cells for improved data separation.
Excel Cell Borders Continued2:31
Delve deeper into cell border formatting.
Formatting Data as Currency Values4:30
Format numbers as currency for financial presentations.
Formatting Percentages1:50
Learn to display numbers as percentages.
Using Excel's Format Painter1:58
Copy formatting from one cell to another with the Format Painter tool.
Creating Styles to Format Data5:31
Create and apply custom styles to format data consistently.
Formatting Dates in Excel3:05
Format dates in Excel by applying date formats from the Home tab, then create a custom format like 'mmm' to show the abbreviated month, with regional settings affecting display.
Merging and Centering Cells3:15
Combine cells and center content for neat formatting.
Using Conditional Formatting3:33
Apply conditional formatting rules to highlight specific data conditions.
Editing Excel Conditional Formatting2:39
Modify and manage conditional formatting rules.
Formatting Data Quiz

Creating an Excel Column Chart4:39
Learn to create column charts to visualize data.
Working with the Excel Chart Ribbon2:39
Explore chart-related options in the Excel Ribbon.
Adding and Modifying Data on an Excel Chart2:43
Modify chart data to reflect changes in your worksheet.
TIP - Non-Adjacent Chart Data Source4:07
Add non-adjacent data sources to an Excel chart by selecting February and May, then fix gaps by changing the axis type to text in format axis.
Excel Charts - Switch Row/Column2:26
Learn to use Excel charts to visualize data effectively and switch row/column to group by bills or months, improving clarity in decision making.
Formatting an Excel Chart4:07
Customize chart elements for better presentation.
Excel Chart Data Labels4:54
Add and format data labels in a clustered column chart to show values clearly, adjust colors, and remove clutter by managing the y-axis and grid lines.
Modifying the Excel Chart Title2:54
Rename the chart title to monthly budget, adjust font size and color, resize the legend, and link the title to a worksheet cell via the formula bar for auto-update.
Moving a Chart to another Worksheet2:32
Relocate charts to different worksheets for organization.
Working with Excel Pie Charts4:30
Create and work with pie charts to represent data.
Microsoft Excel Charts Quick Guide (DOWNLOAD)0:09
Download a quick reference guide for Excel charts.
Working with Excel Charts Quiz

Viewing your Document in Print Preview1:57
Review how your document will appear when printed.
Changing the Margins, Scaling and Orientation5:54
Adjust page margins, scaling, and orientation for printing.
Excel Worksheet Margins5:39
Explore margin settings for better page layout control.
Working with Page Layout View2:35
Utilize Page Layout View to optimize your worksheet for printing.
Adding Header and Footer Content2:33
Include custom headers and footers in printed worksheets.
Printing a Specific Range of Cells2:06
Print only selected cells or ranges from your worksheet.
Printing an Excel Worksheet Quiz

Requirements

No Prior Excel Knowledge Required
Microsoft Excel 2007-2024 or Microsoft 365 Excel Loaded on Computer to Follow Along with Instructor Lectures is Recommended

Description

Master Microsoft Excel: Beginner to Expert All-in-One Course

Unlock the full potential of Microsoft Excel in this comprehensive course designed to take you from beginner to advanced—plus expert-level tools like Macros and VBA. Perfect for any version from Microsoft Excel 2007 to 2025, this course bundles four intensive classes into one powerful package.

What You’ll Learn
Whether you’re just starting or looking to automate your workflow, we’ve got you covered:

Building organized and effective spreadsheets
Managing and analyzing large data sets with ease
Mastering essential Excel functions like SUM, VLOOKUP, IF, and INDEX/MATCH
- Including new Microsoft 365 Functions like XLOOKUP, SWITCH, TEXTSPLIT and more
Creating dynamic reports with PivotTables
Harnessing PowerPivot for more advanced data modeling
Cleaning and auditing formulas to ensure accuracy
Automating tasks with Macros and VBA

What’s Included?

22+ hours of in-depth video instruction led by a Microsoft Certified Trainer
Downloadable exercise files to follow along and practice
Section quizzes to reinforce learning
An interactive Q&A board for questions and support

Student Success Story

"This course is amazing. Not everyone has the gift of teaching, but Kyle truly makes Excel easy and engaging. I now know Excel better than ever and feel ready to tackle any project!"
"This course made me an Excel pro! I was a total beginner, and now I feel confident tackling any Excel task. Kyle’s course is well-structured and easy to follow—highly recommend!"
"Excel has been a mystery to me until this course! Kyle’s teaching made it simple to understand. If you’re hesitant, don’t be—this is the course to buy!"

Take the next step in mastering Excel. Enroll now and transform from an Excel novice to an Excel expert!

Who this course is for:

This Microsoft Excel courses will take you through 4 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced and Macros/VBA).
If your looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.

What you'll learn

Explore related topics

Course content

Microsoft Excel 101 Course Introduction3 lectures • 7min

Microsoft Excel Fundamentals10 lectures • 25min

Entering and Editing Text and Formulas16 lectures • 53min

Working with Basic Excel Functions9 lectures • 30min

Modifying an Excel Worksheet9 lectures • 21min

Formatting Data in an Excel Worksheet13 lectures • 43min

Inserting Images and Shapes into an Excel Worksheet4 lectures • 15min

Creating Basic Charts in Excel11 lectures • 36min

Printing an Excel Worksheet6 lectures • 21min

Working with Excel Templates3 lectures • 10min

Requirements

Description

Who this course is for: