Microsoft Excel - Excel from Beginner to Advanced 2025
- الوصف
- أقسام الدرس
- رأي
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 Excelدرس فيديو
-
2A Quick Message Before Continuingدرس نصي
-
3The Components That Make Up a Spreadsheet: An Introductionدرس فيديو
-
4The Components That Make Up a Spreadsheet and Moreدرس فيديو
-
5Test Your Knowledge on Excel Spreadsheetsاختبار
-
6Udemy's AI Assistantدرس فيديو
-
7Open This Website for the Next Tutorialدرس نصي
-
8Basic Text/Data Managementدرس فيديو
-
9Test Your Knowledge on Basic Text/Data Managementاختبار
-
10Autofill/Flashfillدرس فيديو
-
11Test Your Knowledge on Autofill/Flashfillاختبار
-
12Autofill/Flashfill: Part 2درس فيديو
-
13Autofill/Flashfill: Part 3درس فيديو
-
14Test Your Knowledge on Autofill/Flashfillاختبار
-
15Exercise Instructionsدرس فيديو
-
16Solution Videoدرس فيديو
-
17Course Notebook Previewدرس فيديو
-
18Download Your Notebook Templates and First Instruction Manual Hereدرس نصي
-
19Must-Know Keyboard Shortcuts when Doing an Online Courseدرس فيديو
-
20Download Your List of Keyboard Shortcuts Hereدرس نصي
-
21General Course Overview and Instructor Introduction (MUST WATCH)درس فيديو
-
22The Main Workbook Instructionsدرس فيديو
-
23The Main Workbook Download and Instructions (Article)درس نصي
-
24The Three Different Types of References: Part 1درس فيديو
-
25The Three Different Types of References: Part 2درس فيديو
-
26A Quick Note on the References Exerciseدرس نصي
-
27References Exerciseدرس فيديو
-
28Your 3-Page Instruction Manual on Excel Referencesدرس نصي
-
29Test Your Knowledge on Referencesاختبار
-
30What's the Difference Between a Formula and a Function in Excel?درس فيديو
-
31Introduction to Formulasدرس فيديو
-
32How to Write Formulas in Excelدرس فيديو
-
33Test Your Knowledge on Formula Writingاختبار
-
34How to Write Formulas Using BODMASدرس فيديو
-
35Test Your Knowledge on the BODMAS Ruleاختبار
-
36How to Verify Excel Formulasدرس فيديو
-
37Methods for Creating and Using Functionsدرس فيديو
-
38Basic Function Variations You Must Know: Part 1درس فيديو
-
39Basic Function Variations You Must Know: Part 2درس فيديو
-
40Functions Exercise: SUMIFS, AVERAGEIFS, & COUNTIFSدرس فيديو
-
41Uniting Data with the Concatenate Functionدرس فيديو
-
42Concatenate Function Exerciseدرس نصي
-
43Test Your Knowledge on the Concatenate Functionاختبار
-
44The IF Function in Excelدرس فيديو
-
45Test Your Knowledge on the IF Functionاختبار
-
46Introduction to Chartsدرس فيديو
-
47How to Insert a Chartدرس فيديو
-
48Test Your Knowledge on Chartsاختبار
-
49Chart Exercise Instructionsدرس فيديو
-
50Charts Solutions Video and Additional Insightsدرس فيديو
-
51Formatting Data into a Tableدرس فيديو
-
52Formatting Data into a Table: Part 2درس فيديو
-
53The IF, AND, and OR Functions: Part 1درس فيديو
-
54Test Your Knowledge on the IF and AND Functionsاختبار
-
55The IF, AND, and OR Functions: Part 2درس فيديو
-
56Test Your Knowledge on the IF and OR Functionsاختبار
-
57An Introduction to Printing in Excelدرس فيديو
-
58Printing Your First Spreadsheetدرس فيديو
-
59Test Your Knowledge on Printing in Excelاختبار
-
60Exploring Printer Settingsدرس فيديو
-
61Printing the Second Spreadsheet: Solution and Exerciseدرس فيديو
-
62Building a Navigation Pane: A Few Things to Noteدرس فيديو
-
63HEX to RGB Converter Linkدرس نصي
-
64Building a Navigation Pane: Part 1درس فيديو
-
65Building a Navigation Pane: Part 2درس فيديو
-
66Test Your Knowledge on Navigation Panes and Hidden Linksاختبار
-
67The VLOOKUP Functionدرس فيديو
-
68Note About the Next Tutorialدرس نصي
-
69Conditional Formatting - A Student's Requestدرس فيديو
-
70Subtotalling Data: Part 1درس فيديو
-
71Subtotalling Data: Part 2درس فيديو
-
72'Goals' Spreadsheet: Exercise Instructionsدرس فيديو
-
73'Goals' Solution Videoدرس فيديو
-
80Correcting the VBA Definitionدرس نصي
-
81Introduction to Macrosدرس فيديو
-
82How to Save an Excel Macro-Enabled Documentدرس فيديو
-
83How to Create a Macroدرس فيديو
-
84Test Your Knowledge on Macrosاختبار
-
85How to Create Macros Using Relative Referencingدرس فيديو
-
86Test Your Knowledge on Macrosاختبار
-
87Instructions for Macros Exerciseدرس فيديو
-
88Macros Exercise Solutionدرس فيديو
-
89How to Conveniently Work with Macrosدرس فيديو
-
90Test Your Knowledge on Macrosاختبار
-
91Final Thoughts on Macrosدرس فيديو
-
92Your 8-Page Instruction Manual on Macrosدرس نصي
-
93A Quick Introduction to This Sectionدرس فيديو
-
94How to Work Out Monthly Payments with the PMT Functionدرس فيديو
-
95How to Work Out Monthly Payments with the IPMT Functionدرس فيديو
-
96How to Calculate Yearly Loan Payments Using PMT and IPMT Functionsدرس فيديو
-
97Exercise Instructions and Solutions: PMT, IPMT, and Moreدرس فيديو
-
98Working Out Variable Rate Payments with the PMT Functionدرس فيديو
-
99Interest-Only and Weekly Payment Example Spreadsheetsدرس فيديو
-
100Your 4-Page Instruction Manual on PMT and IPMT Functionsدرس نصي
-
108Must-Know Functions: Part 1درس فيديو
-
109Test Your knowledge on Functionsاختبار
-
110Must-Know Functions: Part 2درس فيديو
-
111Test Your knowledge on Functionsاختبار
-
112Must-Know Functions: Part 3درس فيديو
-
113Your 4-Page Instruction Manual on Must-Know Functionsدرس نصي
-
114Splitting Names with the 'FIND', 'LEFT', 'RIGHT', and 'LEN' Functions: Part 1درس فيديو
-
115Splitting Names with the 'FIND', 'LEFT', 'RIGHT', and 'LEN' Functions: Part 2درس فيديو
-
116How to Add the 'Draw' Tab (If It's Missing)درس فيديو
-
117Mastering Excel's Drawing Tools and Beyondدرس فيديو
-
118Introduction to AI in Excelدرس فيديو
-
119Install This Add-In for the Next Two Tutorialsدرس نصي
-
120The Data Analyze Feature in Excel: Part 1درس فيديو
-
121The Data Analyze Feature in Excel: Part 2درس فيديو
-
122ChatGPT in Excel (Add-in)درس فيديو
-
123ChatGPT for Excel (Add-in) Parametersدرس فيديو
-
124ChatGPT for Excel (Add-in): Final Partدرس فيديو
-
125How to Use Microsoft Copilot with Excelدرس فيديو
-
126Uploading Screenshots for Copilot to Analyzeدرس فيديو
-
127Asking ChatGPT to Act in a Specific Wayدرس فيديو
-
128New Lecture to be Added Soonدرس نصي
-
129Introduction to Charts in Excelدرس فيديو
-
130Introduction to Chart Formattingدرس فيديو
-
131Test Your Knowledge on Chartsاختبار
-
132Charts in Excel. The Chart Design Tabدرس فيديو
-
133Test Your Knowledge on Chartsاختبار
-
134Charts in Excel. Advanced Formatting Toolsدرس فيديو
-
135Inserting and Managing Sparklinesدرس فيديو
-
136Test Your Knowledge on Sparklinesاختبار
-
137Pictures in Charts and Exercise Instructionsدرس فيديو
-
138Test Your Knowledge on Pictures in Excelاختبار
-
139Chart and Table Exercise Solutionدرس فيديو
-
140Common Charts: Part 1درس فيديو
-
141Common Charts: Part 2درس فيديو
-
142Introduction to This Sectionدرس فيديو
-
143Where to Get Free High-Quality Datasets for Excelدرس نصي
-
144Collaborating/Sharing in Excelدرس فيديو
-
145Test Your Knowledge on Data Analysis and Managementاختبار
-
146Data Validation: Part 1درس فيديو
-
147Data Validation: Part 2درس فيديو
-
148Test Your Knowledge on Data Validationاختبار
-
149Data Validation Solution Videoدرس فيديو
-
150Locating and Deleting Duplicate Dataدرس فيديو
-
151Test Your Knowledge on Removing Duplicate Dataاختبار
-
152Advanced Filteringدرس فيديو
-
153Test Your Knowledge on Advanced Filteringاختبار
-
154Advanced Filtering Solution Videoدرس فيديو
-
165The 4-Point Source Data Checklistدرس فيديو
-
166Test Your Knowledge on Pivot Tables and Pivot Chartsاختبار
-
167Creating a Pivot Table: Part 1درس فيديو
-
168Test Your Knowledge on Pivot Tables and Pivot Chartsاختبار
-
169Creating a Pivot Table: Part 2درس فيديو
-
170Test Your Knowledge on Slicersاختبار
-
171Pivot Tables: A little Extra Informationدرس فيديو
-
172Pivot Table and Chart: Scenario 1درس فيديو
-
173Test Your Knowledge on Pivot Chartsاختبار
-
174Pivot Table and Chart: Scenario 2درس فيديو
-
175Pivot Table and Chart: Scenario 3درس فيديو
-
176Building a Pivot Dashboardدرس فيديو
-
177End of Course: A Farewell Messageدرس نصي
-
178Farewell Messageدرس فيديو
-
179Link to Udemy Student Supportدرس نصي