Google Sheets Masterclass for Data and Personal Finance

Descripción

Take control of your money using the power of Google Sheets — one project at a time. Welcome to the most hands-on Google Sheets course built specifically for personal finance! Whether you're a beginner to spreadsheets or simply want to organize your finances, this course will walk you through building 6 practical tools step-by-step — no prior experience needed. By the end, you’ll have a complete, personalized finance system, all made in Google Sheets — fully customizable, scalable, and yours to keep forever. What You’ll Learn (by Building Real Projects) Project 1: Savings & Sinking Funds Tracker Set financial goals Track progress toward big purchases, vacations, or emergencies Visual dashboards to stay motivated Project 2: Subscription Tracker Never forget a renewal again Monthly & annual summaries Automated renewal countdowns Project 3: Net Worth Tracker Log all your assets and debts Dynamic net worth chart Monthly snapshot comparisons Project 4: Investment Portfolio + Stock Watchlist Track individual investments Monitor gains/losses Create a stock watchlist using live data Project 5: Crypto Portfolio Tracker Add coins, exchanges, and transaction history Calculate real-time portfolio value View ROI, profit/loss, and allocations Project 6: All-in-One Budget Planner Monthly income vs. expenses Budget categories & spending insights Visual analytics to help you save more Project 7: Business Expense Dashboard Analyse Business Expenses Budget categories & spending insights Build beautiful and meaningful dashboard Why This Course? • Beginner-friendly: You’ll learn spreadsheet skills by doing. No jargon. No fluff. • Project-based learning: Build 6 real-life finance tools step by step. • Reusable templates: Walk away with a complete personal finance system. • Google Sheets focused: Learn tools and formulas that apply instantly. • Practical skills: Learn functions like SUMIFS, FILTER, ARRAYFORMULA, conditional formatting, charts, dropdowns, and more — all through real use cases. Who is this course for? • Beginners wanting to master Google Sheets while managing their finances • Anyone tired of confusing finance apps and wanting more control • Creators, freelancers, students, or families looking to budget smarter • Self-learners who prefer hands-on, project-based teaching Let’s get started! Join now and build your own personalized personal finance system in Google Sheets — one powerful project at a time.

Lo que aprenderás

• Master essential and advanced Google Sheets formulas for personal finance
• Confidence in data analytics and various scenarios which may be applied in personal finance
• Create personal Finance Budget Planner and other financial templates including Savings Goals, Net Worth, Stocks and Crypto Templates
• Apply the skills in development of personal finance products and more
• Learn how to create great and aesthetically looking dashboard with multiple chart options, including donut, area, stacked as well as sparkline
• Get a grip of Data Validation (Including Multi-Level Drop Down Menu), Date functions, Ifs(), Sumifs(), Index(), Sort(), Filter(), Unique() and much more
• Become expert in Google Finance by creating your own Stock Watchlist, including YTD% and Sparkline Performance Chart
• Create Crypto Investment Tracker with Live Prices
• Get to build 6 projects with all templates available for further use
• More exciting lectures and projects will be consistently added

Requisitos

• Access to Google Sheets (free, in browser)