The Excel Master Class
Focused View
9:45:28
263 View
1. The Excel Start Up Screen.mp4
04:36
2.1 Practice Files - Sales Report.xlsx
2. Practice Files - Level 1.html
3. The Excel Interface.mp4
04:45
4. Understanding The Excel Workbook.mp4
06:26
5. Save, Save As, etc.mp4
04:16
6. Entering Data into Excel.mp4
03:23
7. Alignment in Excel.mp4
03:36
8. Summation in Excel.mp4
13:34
9. Summation in Excel Cont..mp4
07:51
10. Relative and Absolute Referencing.mp4
15:52
11. Minimum and Maximum Function.mp4
07:18
12. Average Function.mp4
03:22
13. The Count Function.mp4
02:14
14. Copying and Moving.mp4
07:13
15. Inserting and Deleting Cells.mp4
06:26
16. Deleting Cells, Rows and Columns.mp4
03:52
17. Changing the sizes or Rows and Columns.mp4
04:45
18. Hiding and Unhiding Rows and Columns.mp4
02:39
19. Renaming and moving Sheets.mp4
07:03
20. Formatting in Excel Introduction.mp4
03:38
21. Formatting Changing Background.mp4
05:57
22. Formatting Changing Background 2.mp4
10:47
23. Formatting Numbers, Currency etc.mp4
10:27
24. Formatting Adding Borders.mp4
04:31
25. Formatting Creating Styles.mp4
06:54
26. Formatting Conditional Formatting.mp4
05:49
27. Formatting More Borderlines.mp4
04:12
28. Inserting Images and Objects.mp4
12:32
29. Modifying Charts.mp4
13:39
30. Pie Charts.mp4
04:29
31. Formatting Charts.mp4
04:45
32. End of Section Quiz.html
33. Yippee Level 1 Complete .html
1.1 1st Practice Test for Lesson 2.xlsx
1.2 2nd Practice Test for Lesson 2.xlsx
1.3 3rd Practice Test for Lesson 2.xlsx
1. Practice Test for Lesson 2.html
2. Introduction to Working with Large Data.mp4
05:36
3. Customizing The Ribbon.mp4
03:35
4. Single Level Sorting(Quick Sorting).mp4
03:45
5. Multi-Level Sorting (Custom Sorting).mp4
03:11
6. Special Sorting.mp4
04:24
7. Filtering in Excel.mp4
04:13
8. Subtotal.mp4
07:05
9. Format as Table.mp4
06:27
10. Identifying Duplicates.mp4
04:47
11. Removing Duplicates.mp4
04:40
12. DSUM ( Database Sum).mp4
07:10
13. DAVERAGE And DCOUNT.mp4
04:20
14. SUB TOTAL.mp4
06:35
15. Data Validation Introduction.mp4
08:22
16. Data Validation Error Messages and Notices.mp4
04:04
17. Dynamic Data Validation.mp4
04:02
18. Data Validation in Action .mp4
02:03
19. Pivot Table Introduction.mp4
02:30
20. Creating Pivot Tables.mp4
08:12
21. Modifying Pivot Tables.mp4
06:02
22. Grouping Pivot Data.mp4
04:02
23. Formatting Pivot Table.mp4
05:15
24. Drilling Down Pivot Tables.mp4
04:17
25. Pivot Charts.mp4
04:27
26. Filtering Pivot Table.mp4
03:56
27. Pivot Table Slicers.mp4
04:12
28. Power Pivot Introduction.mp4
04:04
29. Activating Power Pivot.mp4
02:49
30. Creating Data Models.mp4
04:49
31. Creating Relationships in Power Pivot.mp4
04:21
32. Creating Pivot Tables from Data Models.mp4
06:43
33. Creating KPIs in Power Pivot.mp4
10:40
34. Level 2 done!!! Go you! Go You!! .html
35. End of Section Quiz.html
1.1 1st Practice Test for Lesson 3.xlsx
1.2 2nd Practice Test for Lesson 3.xlsx
1. Practice Test for Lesson 3.html
2. The IF function.mp4
11:20
3. The AND Function.mp4
05:28
4. NESTED Functions.mp4
05:15
5. COUNT IT and COUNT IFs.mp4
05:40
6. SUM IF and SUM IFs.mp4
08:41
7. IF ERROR Function.mp4
06:18
8. V-LOOK UP Introduction.mp4
08:59
9. VLOOKUP Main.mp4
14:31
10. HLOOKUP.mp4
04:49
11. INDEX and MATCH Introduction.mp4
09:08
12. Index and Match in Action.mp4
08:52
13. Index And Match + Data Validation.mp4
02:15
14. Index and Match Advance.mp4
10:03
15. INDEX and MATCH vs VLOOK-UP.mp4
10:10
16. XLOOKUP.mp4
15:26
17. XLOOKUP Cont..mp4
16:25
18. Text Based Functions.mp4
10:18
19. What If Analysis.mp4
11:00
20. Data Tables.mp4
07:40
21. Protecting Worksheets in Excel.mp4
14:06
22. You did it .html
23. End of Section Quiz.html
1. Non-Traditional use of Excel Importing list of file names from a Folder.mp4
10:38
2. Chat GPT in Excel - Basic.mp4
10:59
3.1 Chat GPT Script.txt
3.2 Script to Split Sheets in A Workbook.txt
3. Buidling your own Chat GPT into Excel using Chat GPT APIs..mp4
19:58
More details
User Reviews
Rating
average 0
Focused display
Udemy
View courses UdemyStudents take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
- language english
- Training sessions 85
- duration 9:45:28
- Release Date 2023/06/16
![[3-in-1] Data Viz Bundle: Tableau, Excel & Looker Studio](https://traininghub.ir/image/course_pic/14000-x225.webp)
