[ WebToolTip.com ] Udemy - Google Sheets Masterclass for Data and Personal Finance

File Name

Size

Get Bonus Downloads Here.url

180 B

~Get Your Files Here !/1 - Introduction/1 -Introduction.mp4

71 MB

~Get Your Files Here !/2 - Project 1 - Savings and Sinking Funds Template/1 -Google Sheets MasterClass Resources.pdf

928 kB

~Get Your Files Here !/2 - Project 1 - Savings and Sinking Funds Template/1 -Introduction.mp4

6.6 MB

~Get Your Files Here !/2 - Project 1 - Savings and Sinking Funds Template/2 -Template Setup and Basic Data.mp4

57 MB

~Get Your Files Here !/2 - Project 1 - Savings and Sinking Funds Template/3 -Calculate Monthly Targets with datedif().mp4

35 MB

~Get Your Files Here !/2 - Project 1 - Savings and Sinking Funds Template/4 -Contribution Tracker with Data Validation & Sumifs().mp4

64 MB

~Get Your Files Here !/2 - Project 1 - Savings and Sinking Funds Template/5 -Cell Referencing and Progress Goal.mp4

52 MB

~Get Your Files Here !/2 - Project 1 - Savings and Sinking Funds Template/6 -Goals Dashboard with Donut Charts.mp4

42 MB

~Get Your Files Here !/2 - Project 1 - Savings and Sinking Funds Template/7 -Main Dashboard and Preparation for Final Stacked Chart to Reflect the Progress.mp4

38 MB

~Get Your Files Here !/2 - Project 1 - Savings and Sinking Funds Template/8 -Horizontal Stacked Chart and Project Completed.mp4

17 MB

~Get Your Files Here !/3 - Project 2 - Subscription Tracker/1 -Data Setup and Data Validation Rules.mp4

23 MB

~Get Your Files Here !/3 - Project 2 - Subscription Tracker/1 -Google Sheets MasterClass Resources.pdf

928 kB

~Get Your Files Here !/3 - Project 2 - Subscription Tracker/2 -Dynamic Deadline Calculation with IFs() and Datadif().mp4

35 MB

~Get Your Files Here !/3 - Project 2 - Subscription Tracker/3 -IFs() and SumIFs for Monthly, Quarterly and Annual Subscriptions.mp4

45 MB

~Get Your Files Here !/4 - Project 3 - Net Worth Tracker/1 -Data Setup with Date() and Edate().mp4

26 MB

~Get Your Files Here !/4 - Project 3 - Net Worth Tracker/1 -Google Sheets MasterClass Resources.pdf

928 kB

~Get Your Files Here !/4 - Project 3 - Net Worth Tracker/2 -Calculate Dynamic Growth and Growth % using Index()+Count() and Index()+Month().mp4

65 MB

~Get Your Files Here !/4 - Project 3 - Net Worth Tracker/3 -Backend Preparation for further Data Analysis.mp4

41 MB

~Get Your Files Here !/4 - Project 3 - Net Worth Tracker/4 -Dashboard Creation from Backend, with Column Stacked, Donut and Area Charts.mp4

125 MB

~Get Your Files Here !/5 - Project 4 - Stock Investment Portfolio Tracker/1 -GOOGLE SHEETS MASTER CLASS (2).png

387 kB

~Get Your Files Here !/5 - Project 4 - Stock Investment Portfolio Tracker/1 -Portfolio Setup and Intro to Goooglefinance().mp4

32 MB

~Get Your Files Here !/5 - Project 4 - Stock Investment Portfolio Tracker/2 -Calculate PNL, PNL% and Asset Allocation with Number Formatting.mp4

46 MB

~Get Your Files Here !/5 - Project 4 - Stock Investment Portfolio Tracker/3 -Dashboard to Reflect Asset Allocation and Cost vs Actual Value.mp4

48 MB

~Get Your Files Here !/5 - Project 4 - Stock Investment Portfolio Tracker/4 -Calculate best performing assets by ROI using Query Sort(), Filter(), Hstack().mp4

87 MB

~Get Your Files Here !/5 - Project 4 - Stock Investment Portfolio Tracker/5 -Become Googlefinance() Master - Build Your Stocks Watchlist.mp4

75 MB

~Get Your Files Here !/5 - Project 4 - Stock Investment Portfolio Tracker/6 -Calculate Year To Date Return with Index() and Googlefinance().mp4

29 MB

~Get Your Files Here !/5 - Project 4 - Stock Investment Portfolio Tracker/7 -Create a 52 Week Chart Performance Using Sparkline().mp4

39 MB

~Get Your Files Here !/6 - Project 5 - Crypto Investment Tracker/1 -Build Crypto Portfolio and Fetch Live Prices directly to Google Sheet.mp4

45 MB

~Get Your Files Here !/6 - Project 5 - Crypto Investment Tracker/1 -Google Sheets MasterClass Resources.pdf

928 kB

~Get Your Files Here !/6 - Project 5 - Crypto Investment Tracker/2 -Top performing cryptos by ROI using Query Sort(), Filter(), Hstack()Sortn().mp4

44 MB

~Get Your Files Here !/7 - Project 6 - Personal Budget Template/1 -Accounts and Date Setup.mp4

42 MB

~Get Your Files Here !/7 - Project 6 - Personal Budget Template/1 -Google Sheets MasterClass Resources.pdf

928 kB

~Get Your Files Here !/7 - Project 6 - Personal Budget Template/10 -Monthly Dashboard Part 2 - Dynamic Budget vs Actuals with Index() and Sumifs().mp4

73 MB

~Get Your Files Here !/7 - Project 6 - Personal Budget Template/11 -Monthly Dashboard Part 3 - Dynamic Budget vs Actuals with Index() and Sumifs().mp4

57 MB

~Get Your Files Here !/7 - Project 6 - Personal Budget Template/12 -Monthly Dashboard Part 4 - Connect Front and Backend.mp4

71 MB

~Get Your Files Here !/7 - Project 6 - Personal Budget Template/13 -Monthly Dashboard Part 5 - Start adding Category Charts.mp4

48 MB

~Get Your Files Here !/7 - Project 6 - Personal Budget Template/14 -Monthly Dashboard Part 6 - Calculate Monthly Subscriptions and Financial Summary.mp4

113 MB

~Get Your Files Here !/7 - Project 6 - Personal Budget Template/15 -Monthly Dashboard Part 7 - Calculate Top Expenses wUnique(), Filter(), Sort().mp4

75 MB

~Get Your Files Here !/7 - Project 6 - Personal Budget Template/16 -Monthly Dashboard Part 8 - Income vs Expense Area Chart (Logical Solution).mp4

113 MB

~Get Your Files Here !/7 - Project 6 - Personal Budget Template/17 -Monthly Dashboard Part 9 - Progress Bar with Sparkline().mp4

62 MB

~Get Your Files Here !/7 - Project 6 - Personal Budget Template/18 -Monthly Comparison Dashboard Part 1 - Backend Setup.mp4

41 MB

~Get Your Files Here !/7 - Project 6 - Personal Budget Template/19 -Monthly Comparison Dashboard Part 2 - Data Analysis(Unique(), Filter(),Sumifs()).mp4

48 MB

~Get Your Files Here !/7 - Project 6 - Personal Budget Template/2 -Annual Budget Setup Sum() and EOMONTH().mp4

49 MB

~Get Your Files Here !/7 - Project 6 - Personal Budget Template/20 -Monthly Comparison Dashboard Part 3 - Adding Charts.mp4

25 MB

~Get Your Files Here !/7 - Project 6 - Personal Budget Template/21 -Budget Planner Template Completed - Well Done!.mp4

15 MB

~Get Your Files Here !/7 - Project 6 - Personal Budget Template/3 -Calculate Money Outgoings as a % of Income.mp4

40 MB

~Get Your Files Here !/7 - Project 6 - Personal Budget Template/4 -Transaction Tracker with Data Validation.mp4

61 MB

~Get Your Files Here !/7 - Project 6 - Personal Budget Template/5 -Multi-Level Dropdown Menu with Index ().mp4

41 MB

~Get Your Files Here !/7 - Project 6 - Personal Budget Template/6 -Accounts Management Part 1 - Money In, Money Out, Balance with Sumifs().mp4

27 MB

~Get Your Files Here !/7 - Project 6 - Personal Budget Template/7 -Accounts Management Part 2 - Money In, Money Out, Balance with Sumifs().mp4

36 MB

~Get Your Files Here !/7 - Project 6 - Personal Budget Template/8 -Accounts Management Part 3 - Dashboard with Donut, Column and Stacked Charts.mp4

35 MB

~Get Your Files Here !/7 - Project 6 - Personal Budget Template/9 -Monthly Dashboard Part 1 - Building Backend with Filter() and EOMONTH().mp4

46 MB

~Get Your Files Here !/8 - Thank you/1 -Thank you.mp4

34 MB

~Get Your Files Here !/Bonus Resources.txt

70 B