Microsoft Excel - Excel from Beginner to Advanced 2025
- Objectifs pédagogiques
- Sections du cours
- Avis
Did you know…
Over 750 million people have Excel on their computers, but most don’t know how to use it!
This might be because Excel can come across as being a little awkward with first-time users.
Well, within this course, ‘Microsoft Excel – Excel from Beginner to Advanced 2025′, I’d like to dispel any awkwardness you may encounter, while using Excel, and quickly get you to the point where using Excel is as natural as rolling out of bed in the morning.
How do I do this?
– I explain concepts within Excel simply and clearly.
– I break down Excel’s various tools, features, and functionality into the finest of detail, so you can gain a much deeper understanding of the program.
– I re-visit areas already taught every now and again, to reinforce what you would have already learned.
– I created this course to suit any level of learner.
I understand that learning Excel can feel like a huge undertaking, as it was for me when I first started using the program over 10 years ago. And so, you might ask yourself, “Do I have to learn everything in Excel before I can use it effectively?”.
Well, the answer is, NO!
You don’t have to learn every aspect of Excel before you can consider yourself qualified. The truth is, there is a certain level of proficiency that once reached, will make you considerably more qualified than the average Excel user.
To help you achieve this level of proficiency, I’ve created a very useful Excel workbook called, « main-workbook-section2 » to accompany you throughout the first part of the course (After the basic introduction videos/material). In this workbook, I cover most (if not all) of the most important features and functionality you must know to get up to speed with Excel. Then as you progress further into the course there are various other pre-prepared spreadsheets and workbooks you can download and use to follow along with my instructions.
There’s also a really useful section within the course that covers AI in Excel. This is where you’ll see how artificial intelligence can help speed things up, make your work more efficient, and even help you get more done in less time. As Excel continues to evolve, learning how to take advantage of Excel AI tools and techniques is a smart way to stay ahead of the curve and stand out from the crowd.
What can you expect after enrolment?
We’ll start with a few introductory tutorials to get you set up for the course along with a basic introduction to Excel itself. Then, it’s onto section two, which I hope you’ll complete, and of course, ENJOY! Then, once this part of the course is completed, we’ll start diving into other areas of Excel to really start sharpening the skills you would have already learned, along with learning some new things as well.
Student Success Stories:
“It’s an amazing Excel course! Well explained, and detailed. Great Job Warrick!” Student J – January 2023.
“I like the course very much, clear/detailed explanations and good way tutor mix dense and easy topics.” Student A – January 2025.
“I loved this course! It’s clear that the instructor cares about the students who take this course and makes sure the information is clear and easy to understand. I have learned a lot of new and useful tools in Excel. 100% would recommend.” Student K – December 2024.
“He is stepping into the course in a very smooth way making it easier for the client to understand more” Student Q – June 2022.
“I have never been able to get halfway through a course before. That is until now. Warrick is a brilliant tutor, everything is explained so well that I’ve learnt so much and feel more confident in what I’m doing with Excel now. Such a great feeling of self-achievement and that is genuinely because of Warrick. Thank you” Student J – February 2025.
What do you get when you enroll:
– A 30-day money-back guarantee, so you can enroll risk-free.
– A lifetime access guarantee so you can re-visit the course whenever you want.
– Access to the Q and A section so you can get help at any point during the course.
– A certificate of completion to add to your resume/CV.
So, whatever your reason for wanting to learn Excel, enroll in ‘Microsoft Excel – Excel from Beginner to Advanced 2025′ today! And see where my course will take you 🙂
I’ll see you in the first lesson.
Warrick Klimaytys.
-
1A Brief Introduction to ExcelLeçon vidéo
-
2A Quick Message Before ContinuingLeçon de texte
-
3The Components That Make Up a Spreadsheet: An IntroductionLeçon vidéo
-
4The Components That Make Up a Spreadsheet and MoreLeçon vidéo
-
5Test Your Knowledge on Excel SpreadsheetsQuiz
-
6Udemy's AI AssistantLeçon vidéo
-
7Open This Website for the Next TutorialLeçon de texte
-
8Basic Text/Data ManagementLeçon vidéo
-
9Test Your Knowledge on Basic Text/Data ManagementQuiz
-
10Autofill/FlashfillLeçon vidéo
-
11Test Your Knowledge on Autofill/FlashfillQuiz
-
12Autofill/Flashfill: Part 2Leçon vidéo
-
13Autofill/Flashfill: Part 3Leçon vidéo
-
14Test Your Knowledge on Autofill/FlashfillQuiz
-
15Exercise InstructionsLeçon vidéo
-
16Solution VideoLeçon vidéo
-
17Course Notebook PreviewLeçon vidéo
-
18Download Your Notebook Templates and First Instruction Manual HereLeçon de texte
-
19Must-Know Keyboard Shortcuts when Doing an Online CourseLeçon vidéo
-
20Download Your List of Keyboard Shortcuts HereLeçon de texte
-
21General Course Overview and Instructor Introduction (MUST WATCH)Leçon vidéo
-
22The Main Workbook InstructionsLeçon vidéo
-
23The Main Workbook Download and Instructions (Article)Leçon de texte
-
24The Three Different Types of References: Part 1Leçon vidéo
-
25The Three Different Types of References: Part 2Leçon vidéo
-
26A Quick Note on the References ExerciseLeçon de texte
-
27References ExerciseLeçon vidéo
-
28Your 3-Page Instruction Manual on Excel ReferencesLeçon de texte
-
29Test Your Knowledge on ReferencesQuiz
-
30What's the Difference Between a Formula and a Function in Excel?Leçon vidéo
-
31Introduction to FormulasLeçon vidéo
-
32How to Write Formulas in ExcelLeçon vidéo
-
33Test Your Knowledge on Formula WritingQuiz
-
34How to Write Formulas Using BODMASLeçon vidéo
-
35Test Your Knowledge on the BODMAS RuleQuiz
-
36How to Verify Excel FormulasLeçon vidéo
-
37Methods for Creating and Using FunctionsLeçon vidéo
-
38Basic Function Variations You Must Know: Part 1Leçon vidéo
-
39Basic Function Variations You Must Know: Part 2Leçon vidéo
-
40Functions Exercise: SUMIFS, AVERAGEIFS, & COUNTIFSLeçon vidéo
-
41Uniting Data with the Concatenate FunctionLeçon vidéo
-
42Concatenate Function ExerciseLeçon de texte
-
43Test Your Knowledge on the Concatenate FunctionQuiz
-
44The IF Function in ExcelLeçon vidéo
-
45Test Your Knowledge on the IF FunctionQuiz
-
46Introduction to ChartsLeçon vidéo
-
47How to Insert a ChartLeçon vidéo
-
48Test Your Knowledge on ChartsQuiz
-
49Chart Exercise InstructionsLeçon vidéo
-
50Charts Solutions Video and Additional InsightsLeçon vidéo
-
51Formatting Data into a TableLeçon vidéo
-
52Formatting Data into a Table: Part 2Leçon vidéo
-
53The IF, AND, and OR Functions: Part 1Leçon vidéo
-
54Test Your Knowledge on the IF and AND FunctionsQuiz
-
55The IF, AND, and OR Functions: Part 2Leçon vidéo
-
56Test Your Knowledge on the IF and OR FunctionsQuiz
-
57An Introduction to Printing in ExcelLeçon vidéo
-
58Printing Your First SpreadsheetLeçon vidéo
-
59Test Your Knowledge on Printing in ExcelQuiz
-
60Exploring Printer SettingsLeçon vidéo
-
61Printing the Second Spreadsheet: Solution and ExerciseLeçon vidéo
-
62Building a Navigation Pane: A Few Things to NoteLeçon vidéo
-
63HEX to RGB Converter LinkLeçon de texte
-
64Building a Navigation Pane: Part 1Leçon vidéo
-
65Building a Navigation Pane: Part 2Leçon vidéo
-
66Test Your Knowledge on Navigation Panes and Hidden LinksQuiz
-
67The VLOOKUP FunctionLeçon vidéo
-
68Note About the Next TutorialLeçon de texte
-
69Conditional Formatting - A Student's RequestLeçon vidéo
-
70Subtotalling Data: Part 1Leçon vidéo
-
71Subtotalling Data: Part 2Leçon vidéo
-
72'Goals' Spreadsheet: Exercise InstructionsLeçon vidéo
-
73'Goals' Solution VideoLeçon vidéo
-
80Correcting the VBA DefinitionLeçon de texte
-
81Introduction to MacrosLeçon vidéo
-
82How to Save an Excel Macro-Enabled DocumentLeçon vidéo
-
83How to Create a MacroLeçon vidéo
-
84Test Your Knowledge on MacrosQuiz
-
85How to Create Macros Using Relative ReferencingLeçon vidéo
-
86Test Your Knowledge on MacrosQuiz
-
87Instructions for Macros ExerciseLeçon vidéo
-
88Macros Exercise SolutionLeçon vidéo
-
89How to Conveniently Work with MacrosLeçon vidéo
-
90Test Your Knowledge on MacrosQuiz
-
91Final Thoughts on MacrosLeçon vidéo
-
92Your 8-Page Instruction Manual on MacrosLeçon de texte
-
93A Quick Introduction to This SectionLeçon vidéo
-
94How to Work Out Monthly Payments with the PMT FunctionLeçon vidéo
-
95How to Work Out Monthly Payments with the IPMT FunctionLeçon vidéo
-
96How to Calculate Yearly Loan Payments Using PMT and IPMT FunctionsLeçon vidéo
-
97Exercise Instructions and Solutions: PMT, IPMT, and MoreLeçon vidéo
-
98Working Out Variable Rate Payments with the PMT FunctionLeçon vidéo
-
99Interest-Only and Weekly Payment Example SpreadsheetsLeçon vidéo
-
100Your 4-Page Instruction Manual on PMT and IPMT FunctionsLeçon de texte
-
108Must-Know Functions: Part 1Leçon vidéo
-
109Test Your knowledge on FunctionsQuiz
-
110Must-Know Functions: Part 2Leçon vidéo
-
111Test Your knowledge on FunctionsQuiz
-
112Must-Know Functions: Part 3Leçon vidéo
-
113Your 4-Page Instruction Manual on Must-Know FunctionsLeçon de texte
-
114Splitting Names with the 'FIND', 'LEFT', 'RIGHT', and 'LEN' Functions: Part 1Leçon vidéo
-
115Splitting Names with the 'FIND', 'LEFT', 'RIGHT', and 'LEN' Functions: Part 2Leçon vidéo
-
116How to Add the 'Draw' Tab (If It's Missing)Leçon vidéo
-
117Mastering Excel's Drawing Tools and BeyondLeçon vidéo
-
118Introduction to AI in ExcelLeçon vidéo
-
119Install This Add-In for the Next Two TutorialsLeçon de texte
-
120The Data Analyze Feature in Excel: Part 1Leçon vidéo
-
121The Data Analyze Feature in Excel: Part 2Leçon vidéo
-
122ChatGPT in Excel (Add-in)Leçon vidéo
-
123ChatGPT for Excel (Add-in) ParametersLeçon vidéo
-
124ChatGPT for Excel (Add-in): Final PartLeçon vidéo
-
125How to Use Microsoft Copilot with ExcelLeçon vidéo
-
126Uploading Screenshots for Copilot to AnalyzeLeçon vidéo
-
127Asking ChatGPT to Act in a Specific WayLeçon vidéo
-
128New Lecture to be Added SoonLeçon de texte
-
129Introduction to Charts in ExcelLeçon vidéo
-
130Introduction to Chart FormattingLeçon vidéo
-
131Test Your Knowledge on ChartsQuiz
-
132Charts in Excel. The Chart Design TabLeçon vidéo
-
133Test Your Knowledge on ChartsQuiz
-
134Charts in Excel. Advanced Formatting ToolsLeçon vidéo
-
135Inserting and Managing SparklinesLeçon vidéo
-
136Test Your Knowledge on SparklinesQuiz
-
137Pictures in Charts and Exercise InstructionsLeçon vidéo
-
138Test Your Knowledge on Pictures in ExcelQuiz
-
139Chart and Table Exercise SolutionLeçon vidéo
-
140Common Charts: Part 1Leçon vidéo
-
141Common Charts: Part 2Leçon vidéo
-
142Introduction to This SectionLeçon vidéo
-
143Where to Get Free High-Quality Datasets for ExcelLeçon de texte
-
144Collaborating/Sharing in ExcelLeçon vidéo
-
145Test Your Knowledge on Data Analysis and ManagementQuiz
-
146Data Validation: Part 1Leçon vidéo
-
147Data Validation: Part 2Leçon vidéo
-
148Test Your Knowledge on Data ValidationQuiz
-
149Data Validation Solution VideoLeçon vidéo
-
150Locating and Deleting Duplicate DataLeçon vidéo
-
151Test Your Knowledge on Removing Duplicate DataQuiz
-
152Advanced FilteringLeçon vidéo
-
153Test Your Knowledge on Advanced FilteringQuiz
-
154Advanced Filtering Solution VideoLeçon vidéo
-
165The 4-Point Source Data ChecklistLeçon vidéo
-
166Test Your Knowledge on Pivot Tables and Pivot ChartsQuiz
-
167Creating a Pivot Table: Part 1Leçon vidéo
-
168Test Your Knowledge on Pivot Tables and Pivot ChartsQuiz
-
169Creating a Pivot Table: Part 2Leçon vidéo
-
170Test Your Knowledge on SlicersQuiz
-
171Pivot Tables: A little Extra InformationLeçon vidéo
-
172Pivot Table and Chart: Scenario 1Leçon vidéo
-
173Test Your Knowledge on Pivot ChartsQuiz
-
174Pivot Table and Chart: Scenario 2Leçon vidéo
-
175Pivot Table and Chart: Scenario 3Leçon vidéo
-
176Building a Pivot DashboardLeçon vidéo
-
177End of Course: A Farewell MessageLeçon de texte
-
178Farewell MessageLeçon vidéo
-
179Link to Udemy Student SupportLeçon de texte