Udemy - Google Sheets Masterclass for Data and Personal Finance

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction
• 1 -Introduction.mp4 (70.9 MB)
2 - Project 1 - Savings and Sinking Funds Template
• 1 -Google Sheets MasterClass Resources.pdf (928.3 KB)
• 1 -Introduction.mp4 (6.6 MB)
• 2 -Template Setup and Basic Data.mp4 (56.7 MB)
• 3 -Calculate Monthly Targets with datedif().mp4 (35.1 MB)
• 4 -Contribution Tracker with Data Validation & Sumifs().mp4 (64.3 MB)
• 5 -Cell Referencing and Progress Goal.mp4 (52.3 MB)
• 6 -Goals Dashboard with Donut Charts.mp4 (41.6 MB)
• 7 -Main Dashboard and Preparation for Final Stacked Chart to Reflect the Progress.mp4 (37.5 MB)
• 8 -Horizontal Stacked Chart and Project Completed.mp4 (16.7 MB)
3 - Project 2 - Subscription Tracker
• 1 -Data Setup and Data Validation Rules.mp4 (22.6 MB)
• 1 -Google Sheets MasterClass Resources.pdf (928.3 KB)
• 2 -Dynamic Deadline Calculation with IFs() and Datadif().mp4 (35.1 MB)
• 3 -IFs() and SumIFs for Monthly, Quarterly and Annual Subscriptions.mp4 (44.6 MB)
4 - Project 3 - Net Worth Tracker
• 1 -Data Setup with Date() and Edate().mp4 (26.0 MB)
• 1 -Google Sheets MasterClass Resources.pdf (928.3 KB)
• 2 -Calculate Dynamic Growth and Growth % using Index()+Count() and Index()+Month().mp4 (65.0 MB)
• 3 -Backend Preparation for further Data Analysis.mp4 (40.8 MB)
• 4 -Dashboard Creation from Backend, with Column Stacked, Donut and Area Charts.mp4 (125.1 MB)
5 - Project 4 - Stock Investment Portfolio Tracker
• 1 -GOOGLE SHEETS MASTER CLASS (2).png (387.0 KB)
• 1 -Portfolio Setup and Intro to Goooglefinance().mp4 (32.2 MB)
• 2 -Calculate PNL, PNL% and Asset Allocation with Number Formatting.mp4 (46.4 MB)
• 3 -Dashboard to Reflect Asset Allocation and Cost vs Actual Value.mp4 (47.8 MB)
• 4 -Calculate best performing assets by ROI using Query Sort(), Filter(), Hstack().mp4 (87.0 MB)
• 5 -Become Googlefinance() Master - Build Your Stocks Watchlist.mp4 (75.3 MB)
• 6 -Calculate Year To Date Return with Index() and Googlefinance().mp4 (29.4 MB)
• 7 -Create a 52 Week Chart Performance Using Sparkline().mp4 (39.2 MB)
6 - Project 5 - Crypto Investment Tracker
• 1 -Build Crypto Portfolio and Fetch Live Prices directly to Google Sheet.mp4 (45.3 MB)
• 1 -Google Sheets MasterClass Resources.pdf (928.3 KB)
• 2 -Top performing cryptos by ROI using Query Sort(), Filter(), Hstack()Sortn().mp4 (43.5 MB)
7 - Project 6 - Personal Budget Template
• 1 -Accounts and Date Setup.mp4 (42.3 MB)
• 1 -Google Sheets MasterClass Resources.pdf (928.3 KB)
• 10 -Monthly Dashboard Part 2 - Dynamic Budget vs Actuals with Index() and Sumifs().mp4 (72.6 MB)
• 11 -Monthly Dashboard Part 3 - Dynamic Budget vs Actuals with Index() and Sumifs().mp4 (57.4 MB)
• 12 -Monthly Dashboard Part 4 - Connect Front and Backend.mp4 (71.2 MB)
• 13 -Monthly Dashboard Part 5 - Start adding Category Charts.mp4 (48.3 MB)
• 14 -Monthly Dashboard Part 6 - Calculate Monthly Subscriptions and Financial Summary.mp4 (113.3 MB)
• 15 -Monthly Dashboard Part 7 - Calculate Top Expenses wUnique(), Filter(), Sort().mp4 (75.3 MB)
• 16 -Monthly Dashboard Part 8 - Income vs Expense Area Chart (Logical Solution).mp4 (113.0 MB)
• 17 -Monthly Dashboard Part 9 - Progress Bar with Sparkline().mp4 (62.5 MB)
• 18 -Monthly Comparison Dashboard Part 1 - Backend Setup.mp4 (40.7 MB)
• 19 -Monthly Comparison Dashboard Part 2 - Data Analysis(Unique(), Filter(),Sumifs()).mp4 (48.3 MB)
• 2 -Annual Budget Setup Sum() and EOMONTH().mp4 (49.0 MB)
• 20 -Monthly Comparison Dashboard Part 3 - Adding Charts.mp4 (24.6 MB)
• 21 -Budget Planner Template Completed - Well Done!.mp4 (15.0 MB)
• 3 -Calculate Money Outgoings as a % of Income.mp4 (39.8 MB)
• 4 -Transaction Tracker with Data Validation.mp4 (61.0 MB)
• 5 -Multi-Level Dropdown Menu with Index ().mp4 (41.3 MB)
• 6 -Accounts Management Part 1 - Money In, Money Out, Balance with Sumifs().mp4 (26.9 MB)
• 7 -Accounts Management Part 2 - Money In, Money Out, Balance with Sumifs().mp4 (35.5 MB)
• 8 -Accounts Management Part 3 - Dashboard with Donut, Column and Stacked Charts.mp4 (35.0 MB)
• 9 -Monthly Dashboard Part 1 - Building Backend with Filter() and EOMONTH().mp4 (45.5 MB)
8 - Thank you
• 1 -Thank you.mp4 (33.7 MB)
• Bonus Resources.txt (0.1 KB)