Build Excel Models using Advanced Formulas, VBA, Power Query
Focused View
5:53:14
38 View
01 1. Introduction to the Course Build Advanced Excel Models.mp4
04:14
02 2. Minimum Requirements for the Course.mp4
01:05
03 3. Prepayments In a Business - An Introduction.mp4
01:15
04 4. Prepaid Expenses (Prepayments) Accounting Definition.mp4
02:47
05 5. Prepaid Expense Example (How Accounting works for Prepayments).mp4
02:38
06 6. Advantages and Disadvantages of Prepaid Expenses.mp4
02:32
07 7. An Intro to PRO Excel Models and Formulas.mp4
05:56
08 8. Basics of Date Function.mp4
04:31
09 9. Basics of EOMONTH Function.mp4
04:10
10 10. Basics of DATEVALUE function.mp4
03:27
11 11. Basics of IF Function.mp4
07:34
12 12. Basics of IFS Function (Excel 2019 and Office 365 Only).mp4
07:04
13 13. Basics of VLOOKUP Function.mp4
06:46
14 14. Basics of MATCH Function.mp4
04:33
15 15. Basics of INDIRECT Function.mp4
01:34
16 16. Basics of NAMED Ranges (Name Manager).mp4
03:07
17 17. Advanced Version of VLOOKUP Function (All other formulas combined).mp4
07:27
18 18. Introduction to Model and Control Panel Tab (Important Sheet Tab).mp4
08:24
19 19. Formula Based Prepaid Expenses Model Deep Dive (Part 1).mp4
04:49
20 20. Formula Based Prepaid Expenses Model Deep Dive (Part 2).mp4
06:21
21 21. Formula Based Prepaid Expenses Model Deep Dive (Part 3).mp4
06:13
22 22. IFS Function Month End date Prepayment calculation.mp4
04:08
23 23. Prepaid Expenses Closing Balance Summary Tab (Formula Based Summary).mp4
08:52
24 24. Protecting Formulas Cells and Fields in the Model.mp4
03:59
25 25. Exact Date Prepaid Amorisation calculation Intro.mp4
03:08
26 26. Formulas update for Exact Prepaid Exps Calculation.mp4
02:57
27 27. Formulas Update for Exact Date Amortisation 1.mp4
03:55
28 28. Formulas Update for Exact Date Amortisation 2.mp4
03:21
29 29. Formulas Update for Exact Date Amortisation 3.mp4
02:19
30 30. Formulas Update for Exact Date Amortisation 4.mp4
06:34
31 31. IFS Function Exact Date Prepayments Amortisation.mp4
03:33
32 32. Data Validation Controls.mp4
10:21
33 33. Bonus Prepayment Model Opening Balances1.mp4
07:42
34 34. Bonus Prepayment Model Opening Balances2.mp4
09:24
35 35. Power Query and Pivot Table Prepayment Summary Table Intro.mp4
05:49
36 36. Power Query and Pivot Table Summary Deep Dive (Part 1).mp4
04:48
37 37. Power Query and Pivot Table Summary Deep Dive (Part 2).mp4
03:46
38 38. Power Query and Pivot Table Summary Deep Dive (Part 3).mp4
05:17
39 39. Power Query and Pivot Table Summary Deep Dive (Part 4).mp4
09:16
40 40. Using Array Formulas to Add Formula Protection.mp4
04:23
41 41. Bonus Allocation Intro 1.mp4
02:00
42 42. Bonus Allocation Walk 2.mp4
07:30
43 43. New Version Power Query and PT Model.mp4
12:33
44 44. Complete Walkthrough Advanced VBA Prepaid Expenses Amortisation Model.mp4
05:43
45 45. Bonus New Version Excel VBA Model.mp4
08:19
46 46. Dynamic Dashboard Overview.mp4
06:31
47 47. Importing Profit and Loss Statements.mp4
08:11
48 48. Creating Dynamic Data Validation.mp4
02:09
49 49. Creating Named Ranges for Dynamic Table.mp4
03:27
50 50. Dynamic Date Column Headings.mp4
02:28
51 51. Dynamic Month and YTD Dashboard tables headings (PRO TIP).mp4
02:51
52 52. Dynamic VLOOKUP Formula First section of the Dashboard.mp4
04:02
53 53. Creating Rolling Dashboard with Dynamic VLOOKUP Function.mp4
08:00
54 54. IMPORTANT Error Checking (PRO TIP).mp4
02:35
55 55. Data Prep for AREA Charts (#NA Function).mp4
04:47
56 56. Visualization AREA Charts for Month.mp4
04:31
57 57. Visualization DONUT Charts Revenue, GP, NP 1.mp4
03:00
58 58. Visualization DONUT Charts Revenue, GP, NP 2.mp4
06:13
59 59. Introduction Formulaless Dashboard.mp4
05:12
60 60. Understanding the data files.mp4
01:59
61 61. Consolidation with Power Query.mp4
07:35
62 62. Dynamic File Path Trick in Power Query.mp4
05:57
63 63. Conditional Cumulative totals.mp4
04:06
64 64. Conditional Cumulative totals with M Code.mp4
06:16
65 65. Dashboard Creation Pivot Table.mp4
06:02
66 66. Dashboard Creation Donuts Charts.mp4
08:21
67 67. Dashboard Creation Line Charts.mp4
07:55
68 68. Update Dashboard with New Data.mp4
03:24
69 69. Thank you for going through this Journey.mp4
01:38
More details
User Reviews
Rating
average 0
Focused display
Category
SkillShare
View courses SkillShareSkillshare is an online learning community based in the United States for people who want to learn from educational videos. The courses, which are not accredited, are only available through paid subscription.
- language english
- Training sessions 69
- duration 5:53:14
- English subtitles has
- Release Date 2024/01/28
