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

Master Excel from Basic to Advanced in 2025

Name: Master Excel from Basic to Advanced in 2025
Rating: 4.5 (121 reviews)

Excel in 2023 : Learn the power of every aspect of Excel from Data Entry to Functions to Pivot Tables and M-code.

Created byMarlon Anan

Last updated 3/2026

English

What you'll learn

Students will learn a basic to advanced comprehension and usage of the Excel interface. They will know who to use the commands and manipulate the basic ribbon.
Students will also learn a basic to advanced comprehension and usage of a large array of functions.
Students will learn the fundamentals of programming using VB Excel.
Students will learn basic to advanced Power Query, and an introduction to M-code.
Students will learn about ActiveX, Form objects and the usage of the Excel Forms
Students will learn how to use the basic default commands on the default Excel ribbon.

Course content

33 sections • 352 lectures • 32h 7m total length

Excel Basic Overview11:57
A basic overview of the Excel interface.

Section Overview0:42
An overview of the section.
Create a New Document3:20
Learn how to create a new document.
Keyboard Movements3:25
Students will get a basic introduction to basic keyboard movements.
Basic Input4:07
Students will learn basic input of data into cells.
Basic Input 25:16
Students will get further exposure of basic data input techniques.
Basic Commands Section Quiz
Custom Ribbon3:51
This video class explains the procedure of creating a custom ribbon of user-specific tools/commands.
Quick Access Tool Bar3:30
This video class explains the procedure of creating a custom quick access tool bar of user-specific tools/commands.
Basic Commands Quiz 2

Section Overview0:31
A brief overview of basic spreadsheet commands.
Copy, Move, Rename Sheets3:50
Students will learn how to copy, rename and delete a worksheet.
Adjust Column and Row Size3:31
Students will learn how to adjust the column and row sizes.
Insert and Delete Rows and Columns4:37
Learn how to insert and delete rows and columns.
Using the Shift Key3:25
Use the SHIFT key to move rows or columns within a range of values.
Format Painter3:15
Use the Format Painter button to copy and paste the format from one cell to another cell.
Basic Quiz 1
Clipboard4:02
Students will learn how to save data to the clipboard.
Cut and Paste3:31
Students will learn how to cut and paste values.
Copy and Paste 15:45
Students will learn how to copy and paste values.
Copy and Paste 25:36
Students will learn how to copy and paste formatting.
Copy/Cut with Enter1:27
A quicker way of pasting is to simply use the Enter key instead of using Ctrl+ V
Basic Quiz 2
Save Options4:19
Students will learn how to save a document.
Save As/ Save6:27
Students will learn the difference between Save and Save As.
Basic Quiz 3

Section Overview0:43
Brief overview on formatting text.
Font7:20
Students will learn how to format font.
Wrap Text4:08
Students will learn how to wrap elongated text values.
Border 15:48
Students will learn how to create a cell border.
Formatting Quiz
Borders 210:04
Students will learn how to add more colorful border styles.
Merge Cells3:44
Students will learn how to merge cells.
Formatting Quiz 2

Section Overview0:46
A brief overview of various data tools.
Consolidate6:01
Students will learn how to combine two or more tables.
Data Validation 15:57
Students will learn how to apply validation rules to a user's input.
Data Validation 24:55
Students will learn how to apply advanced validation rules.
Data Tools Quiz 1
Data Form Entry4:12
Students will learn how to use the data entry form box.
Remove Duplicates4:29
Students will learn how to remove duplicates in a column.
Data Tools Quiz 2
Scenario Manager7:45
The Scenario function allows a user to insert imaginary values into a table or range of values.
Goal Seek4:15
Use Goal Seek to insert a single hypothetical value and have it alter a new total result.

Requirements

Students should have a very basic exposure to Excel. Some minor exposure to programming would be helpful but the programming aspect of the course is geared towards a novice.

Description

Hi, and welcome on behalf of all of us here at Xcell’N Excel. Our team has put together an ongoing and current course on the major aspects of Excel. In this course, you will learn:

· Basic data entry - learn simple and advanced data input and keystrokes.

· Formatting - learn how to affect the font, styles, border colors and sizes.

· Functions - learn the power of Excel through basic to advanced inbuilt functions.

· Dynamic Arrays – learn about the power of this new technology for performing calculations.

· Pivot Tables - learn how to summarize and analyze data.

· Power Query - learn how to transform and connect to different data forms.

· Printing – learn the seeming mysteries of printing documents.

· VBA - learn the basics of VBA coding

· Charts - insert charts of different formats for professional visual presentation of your data.

· M-Code – learn the basics of this robust language that powers Power Query and a lot more...

Our course will be updated on a weekly basis to help keep you up to date.

Although we have tried to cater this course to users of 2010 upwards, be aware that some of the material such as Dynamic Arrays will not work with older, legacy versions.

Plus, we will always be here to hear what you have to say and help as you grow in your knowledge of the most popular spreadsheet software in the world.

Who this course is for:

Beginner Excel learner and user.

Master Excel from Basic to Advanced in 2025

What you'll learn

Explore related topics

Course content

Overview1 lecture • 12min

Basic Commands7 lectures • 24min

Basic Commands 213 lectures • 50min

Formatting6 lectures • 32min

Shapes and Texts6 lectures • 36min

Referencing4 lectures • 22min

Tables5 lectures • 24min

Data Tools8 lectures • 38min

Conditional Formatting4 lectures • 16min

Find and Replace3 lectures • 12min

Requirements

Description

Who this course is for: