Tutorialsplanet NET Udemy - Microsoft Excel 2023 - From Beginner to Expert in 6 Hours

1. 01 - Course information/001 Welcome.mp4118.66MB
2. 01 - Course information/003 Getting your certificate.mp442.58MB
3. 02 - Quick start with MS Excel/001 Introduction.mp485.66MB
4. 02 - Quick start with MS Excel/002 Microsoft Excel.mp471.14MB
5. 02 - Quick start with MS Excel/003 Relative references.mp470.23MB
6. 02 - Quick start with MS Excel/004 Absolute references.mp463.13MB
7. 02 - Quick start with MS Excel/005 Calculating a grade.mp442.58MB
8. 02 - Quick start with MS Excel/006 Creating charts.mp4118.86MB
9. 02 - Quick start with MS Excel/007 Functions.mp466.97MB
10. 02 - Quick start with MS Excel/008 FCDB.mp439.87MB
11. 03 - Hands-on exercises #1/001 Hands-on exercises.mp457.9MB
12. 04 - MS Excel fundamentals/001 Introduction.mp411.48MB
13. 04 - MS Excel fundamentals/002 A tour of Excel.mp4147.03MB
14. 04 - MS Excel fundamentals/003 Mouse pointer awareness.mp431.5MB
15. 04 - MS Excel fundamentals/004 The power of right clicking.mp448.75MB
16. 04 - MS Excel fundamentals/005 Autosave & autorecover.mp437.3MB
17. 04 - MS Excel fundamentals/006 MS Excel files.mp418.45MB
18. 05 - Hands-on exercises #2/001 Hands-on exercises.mp430.68MB
19. 06 - MS Excel functions/001 Max, min, & documentation.mp4118.24MB
20. 06 - MS Excel functions/002 Rand & randbetween.mp427.39MB
21. 06 - MS Excel functions/003 Concat & textjoin.mp459.59MB
22. 06 - MS Excel functions/004 Documentation.mp472.89MB
23. 07 - Hands-on exercises #3/001 Hands-on exercises.mp438.8MB
24. 08 - Popular Excel functions/001 Introduction.mp433.98MB
25. 08 - Popular Excel functions/002 Top 10 functions.mp427.93MB
26. 08 - Popular Excel functions/003 Xlookup, vlookup, & hlookup.mp490.04MB
27. 08 - Popular Excel functions/004 PMT payment function.mp487.41MB
28. 08 - Popular Excel functions/005 PMT IPMT loan amortization.mp495.46MB
29. 08 - Popular Excel functions/006 FV future value function.mp438.13MB
30. 08 - Popular Excel functions/007 FV retirement amortization.mp425.26MB
31. 08 - Popular Excel functions/008 IF IFERROR dynamic amortization.mp448.06MB
32. 08 - Popular Excel functions/009 Conditional formatting.mp455.23MB
33. 09 - Hands-on exercises #4/001 Hands-on exercises.mp431.96MB
34. 10 - Formatting for impact/001 Fundamentals of formatting.mp434.89MB
35. 10 - Formatting for impact/002 Formatting tables of data quickly.mp442.91MB
36. 10 - Formatting for impact/003 Font is feeling - font formatting.mp450.36MB
37. 10 - Formatting for impact/004 Exploring the home ribbon.mp497.78MB
38. 10 - Formatting for impact/005 Zebra stripe rows.mp441.11MB
39. 11 - Hands-on exercises #5/001 Hands-on exercises.mp415.22MB
40. 12 - Creating charts & graphs/001 Content & form.mp4113MB
41. 12 - Creating charts & graphs/002 Creating charts.mp4120.07MB
42. 12 - Creating charts & graphs/003 Formatting charts.mp456.91MB
43. 12 - Creating charts & graphs/004 Chart trendlines.mp458.09MB
44. 12 - Creating charts & graphs/005 Combo charts.mp469.23MB
45. 12 - Creating charts & graphs/006 Sparklines.mp431.09MB
46. 13 - Hands-on exercises #6/001 Hands-on exercises.mp438.42MB
47. 14 - Working with data/001 Gapminder data.mp446.27MB
48. 14 - Working with data/002 Scraping web data.mp442.73MB
49. 14 - Working with data/003 Outdoor gear coop.mp495.75MB
50. 14 - Working with data/004 Name generator.mp484.35MB
51. 15 - Massaging data/001 Sorting data.mp447.69MB
52. 15 - Massaging data/002 Freeze panes.mp432.86MB
53. 15 - Massaging data/003 Removing duplicates.mp420.48MB
54. 15 - Massaging data/004 Filtering data.mp416.3MB
55. 16 - Hands-on exercises #7/001 Hands-on exercises.mp432.28MB
56. 17 - Pivot tables in Excel/001 Introduction.mp491.09MB
57. 17 - Pivot tables in Excel/002 Creating pivot tables.mp473.36MB
58. 17 - Pivot tables in Excel/003 Slicers - filtering pivot tables.mp431.28MB
59. 17 - Pivot tables in Excel/004 Pivot charts.mp443.74MB
60. 18 - Hands-on exercises #8/001 Hands-on exercises.mp49.46MB
61. 19 - Odds & ends/001 Printing your worksheet.mp495.49MB
62. 19 - Odds & ends/002 Protecting (locking) workbooks, sheets, and cells.mp443.42MB
63. 19 - Odds & ends/003 Object linking & embedding (OLE).mp415.03MB
64. 20 - Creating macros/001 Introduction to macros.mp484.91MB
65. 21 - Hands-on exercises #9/001 Hands-on exercises.mp416.43MB
66. 22 - Congratulations/001 Great work!.mp418.02MB
67. 22 - Congratulations/002 Bonus lecture.mp422.4MB