Excel Tutorial Beginner to Advanced - 12-Hour Excel Course

preview_player
Показать описание

This Microsoft Excel 2021 Beginner to Advanced training course covers everything from the basics of Excel to intermediate and advanced skills.

Topics covered include logical IF functions, Excel lookup functions, formatting, statistical functions, and more. Downloadable exercise files from the paid-for course are included, helping users master Excel.

The course covers how to launch Excel, explore the interface, use ribbons, tabs, and menus, utilize the Quick Access Toolbar, and more.

Additionally, the course covers intermediate topics such as cell styles, data input, navigation buttons, and more.

Finally, the course covers advanced topics such as dynamic arrays, two-way lookups, median and mode, rounding values, and more.

📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!

0:00:00 - Introduction
0:00:22 - Course Intro
0:02:42 - Excel 2021 vs Excel 365
0:08:21 - Launching Excel
0:12:00 - The Start Screen
0:22:12 - Exploring the Interface
0:33:51 - Ribbons, Tabs and Menus
0:42:20 - Backstage Area
0:47:00 - Quick Access Toolbar
0:56:45 - Useful Keyboard Shortcuts
01:06:27 - Getting Help
01:13:04 - Exercise 01
01:15:27 - Working with Templates
01:24:30 - Workbooks and Worksheets
01:32:04 - Saving Workbooks
01:40:50 - Entering and Editing Data
01:50:43 - Navigating and Selecting Cells, Rows and Columns
01:58:02 - Exercise 02
02:03:22 - Formulas and Functions Explained
02:15:06 - SUM Function
02:22:44 - COUNT Function
02:30:10 - AVERAGE Function
02:34:27 - MIN and MAX Function
02:36:52 - Handling Errors in Calculations
02:45:34 - Absolute vs Relative Referencing
02:52:29 - Autosum and Autofill Options
03:02:12 - Flash Fill
03:07:15 - Exercise 03
03:12:26 - What are Named Ranges
03:21:33 - Managing Named Ranges
03:25:22 - Using Named Ranges
03:30:42 - Exercise 04
03:35:00 - Applying Number Formats
03:45:03 - Applying Date and Time Formats
03:50:41 - Formatting Cells, Rows and Columns
03:59:20 - Format Painter
04:04:00 - Exercise 05
04:08:21 - Intermediate Course Introduction
04:14:39 - Improve Readability with Cell Styles
04:19:36 - Controlling Data Input
04:27:55 - Adding Navigation Buttons
04:36:42 - Logical Functions
04:50:01 - The IF Function
04:55:27 - Nested IFs
05:03:29 - The IFs Function
05:09:34 - Conditional IFs
05:16:19 - Multiple Criteria
05:23:30 - Error Handling
05:29:33 - Exercise 01
05:37:02 - VLookup (Exact Match)
05:47:43 - VLookup (Approximate Match)
05:52:09 - HLookup
05:57:46 - INDEX and MATCH
06:08:18 - XLookup and XMatch
06:18:26 - OFFSET Function
06:29:16 - INDIRECT Function
06:38:22 - Exercise 02
06:47:27 - Sorting on Multiple Columns
06:50:31 - Soring Using a Custom List
06:54:05 - SORT and SORTBY Functions
07:04:04 - Advanced Filter
07:10:58 - UNIQUE Function
07:16:16 - FILTER Function
07:25:45 - Exercise 03
07:31:26 - How Date and Times are Stored
07:35:38 - Custom Data and Time Formats
07:42:47 - Time and Date Functions
07:51:33 - WORKDAY and WORKDAY.INTL Functions
07:55:22 - NETWORKDAYS and NETWORKDAYS.INTL Functions
07:58:19 - DATEDIF
08:04:32 - EDATE and EOMONTH
08:12:15 - Advanced Course Introduction
08:15:04 - Exercise 01
08:17:08 - Dynamic Arrays
08:19:23 - Spill and Arrays
08:30:18 - Extract and Count Unique Entries
08:36:33 - Unique vs. Distinct
08:39:54 - Unique with Multiple Criteria
08:43:07 - Unique Values by Column
08:47:30 - SORT Function
08:56:25 - Horizontal Sort
09:02:30 - SORTBY Function
09:08:40 - Horizontal SORTBY
09:11:47 - Sequence and Unstacking Records
09:21:54 - Filter Function
09:28:54 - Using Filter with Logic Plus Operator
09:33:41 - Using Filter with Logic Asterisk Operator
09:39:19 - Using Filter with Logic Equals Operator
09:43:32 - Using Filter with Logic Minus Operator
09:48:21 - RANDARRAY and RANDBETWEEN
09:58:06 - XLookUp
10:10:26 - XMatch
10:16:50 - Exercise 02
10:29:57 - Two-way Lookups
10:38:23 - CHOOSE Function
10:48:25 - SWITCH Function
10:52:58 - Exercise 03
11:00:03 - Median and Mode
11:06:20 - Using LARGE and SMALL
11:13:51 - Ranking Data
11:21:33 - COUNTBLANK Function
11:26:19 - Exercise 04
11:33:24 - Rounding Values
11:40:23 - Specialized Rounding
11:44:52 - Aggregate Function
11:49:26 - Exercise 05

Check out our Microsoft Excel Long Tutorials playlist here

💬Stay in touch!
Рекомендации по теме
Комментарии
Автор


🔥Check out our FREE 300+ hour training course playlist here 👉

SimonSezIT
Автор

This is the best Excel course on YouTube so far, thanks for making it possible for us to learn.

Husnain
Автор

Hello Deborah and the whole simon sez family, thank u guys very much for this wonderful course. It was learner's centered rather than teacher centered. I just finished it. What a lovely style of teaching.

tangwanephraim
Автор

Awesome lesson! I finished the all recordings. I learned a lot. Thank you Deb for the clear instruction and exercise.

qzstutb
Автор

At 5.5 Hours. Best tutorial ever taken. To the point, no fluff. Thank you.

crushmedia
Автор

Thank you for the best Excel course, Debs you taught me so much! Excellent tutor, great that you can download files and complete all the exercises, I've learnt more from this 12 hour course than throughout all my years of using Excel. Thank you!

WilmienBos
Автор

BEST TEACHER AND CHANNEL ON YOUTUBE! SUBSCRIBED!! THANK YOU!! 😊
4:10:59 Intermediate starts
7:30:30 Filter and sort
7:36:40 date n time
7:58:30 dateif
8:04:43 loan amortization schedule
8:20:07 dynamic array
8:50:00 sort function
10:41:17 choose function

bellamarley
Автор

FORMULAS
1. basic alzebra
2.count, countA(for albhatic also), countBlank(for no of blank blocks)
3. Average
3. min(to find min value in selected range)....MAX
4. CTRL+D to apply full formula to other tables
5. FLASH FILL (fills similar kinda data) can be found under data
6. CNTRL+SHIFT+DOWN ARROW to select full column
7. FORMAT PAINTER (to copy full design) below copy and past
8. DATA VALIDATION (4:22:00) to show list
9. To lock go to review and protect cell
10. CNTRL+K to insert link to any pic or text
11. using gates (IF, AND, OR) 4:45:00
to consider both use AND & t take consider any one use OR
12. NESTED IF [=IF(logic, IF(....))] 4:57:00
13. IFS [=IFS(logic1, logic2, logic3)]
14. SUMIF, COUNTIF, AVERAGEIF (critiria, formula) 5:14:00
SUMIFs, COUNTIFS, AVERAGEIFS(2 or more critiria, formula) 4:17:00
15. IFERROR (is udes to write desiered senetence in error block)
16. VLOOKUP (used to look value in coloums) 5:40:00 2types- approx and exact analysis
HLOOKUP (for horizental lookup) 5:55:00
17. INDEX (same like lookup but also from R to left) 6:01:00
MATCH ( to find position of a value like row no ) 6:03:00
18. XLOOKUP ( same as lookup but very simple) 6:09:00
19. CNTRL+T to create a table and we can design table using options in top
20. OFFSET (gets value from rows and coloums from enterent value) 6:19:00
sum of last 6 months values ex - 6:25:00
21. INDIRECT (to entr another cell value) 6:30:00
22. under Data go to SORT to sort based on coloum and text
23. =SORT and SORTBY to sort by any coloum and asendening or desending order 7:02:40
24. UNIQUE to find unique items in repeated items
25. FILTER (to filter list by a value in that list) 7:20:00
26. =TOADY() or CNTRL+; present days date and change by time
=NOW() or CNTRL+SHIFT+; to get time which changes
27. DATE and TIME functions
28. WORKDAY and WORKDAY.INTL (to calculate the work to be done by providing strt and end dates)
29. NETWORKDAYS (to find no of days b/w dates)
30. to find birthdays use DATEDIF()
31. EOMONTH to end end of the month dates
32. EDATE to add or sub the no. of months from given date
33. we can sort tables but just assigning some values and sort them asending or descending
34. INDEX can be used to enter data according to row or coloum no 9:20:00
35. RANDARRAY is used to enter random data in blocks
36. XLOOKUP can be used to look at 2 diff scenes 10:37:00
37. =CHOOSE(1, "A", "B", "C") 10:42:00
1 is A 2 is 3 is C
38. =SWITCH(expression, 1, "hi", 2, "kk") 10:51:00
1 is hi
39. MEDIAN (middle value)
40. MODE (most occering value)
41. =LARGE (to find 2nd or nth largest value in an arry)
same =SMALL 11:11:00
42. RANK (to rank any num values in list) 11:19:00
43. ROUND ( for rounding values ) 11:37:00
44. AGGREGATE (to do arthametic calculations without considering errors or other) 11:46:00

cfdkwgf
Автор

I watched this entire video and practiced all the exercises! Learnt a lot! Thank you Deborah and Simon!

tuongonglon
Автор

I just finished my journey with Excel 2021. I am so proud of myself and I can't stop thanking Simon Sez and Deb or this very interesting course. I've learned so many things during the 12 hours course and higher is my satisfaction. Thank you so much for your help!

levybarakabama
Автор

Thanks for helping me perfect my skills in Excel, your teaching style is apt and great instructors.

ikpethaInnocent
Автор

Thanks Deborah for walking in your purpose, we are grateful for all these. Greetings from Germany

MissRach
Автор

This is the best Excel course on YouTube so far, thanks for making it possible for us to learn.
I am happy to have found this video.

aghanistanisthebest
Автор

I've returned back to this course after some months, it's just too good.

ojeagadaniel
Автор

Its great to be able to do courses like this one, thank you so much for letting me learn for free.

johnsullivan
Автор

This is the best Excel course on you tube so far. thanks a lot Deb and Simon sez !!!

MrDananjaya
Автор

Wonderful and helpfully thorough presentation. I learned alot. The British accent was a bonus, as any serious topic spoken with a British accent makes the topic suddenly sound more intellectually sophisticated lol

kevinpark
Автор

I've just completed this 12-hour video, super useful and comprehensible (I played 1.5x speed bc it's a little slow to me). Literally recommend it for anyone who wanna gain a solid grounding in Excel. Thank you so much for providing us such free precious lessons. I'm really grateful for it❤❤❤

camomile
Автор

Great skills to teach.. I really enjoy learning from your videos

majidramzan
Автор

I thought I knew Excel until I started came across this video. It's the most comprehensive Excel tutorial I have ever seen in my 10 using excel. Thank you so much for sharing such a great work.

DarkKnight-fdms