A Beginner's Course on Spreadsheets for Personal Finance

Itemize your expenses and create simple forecasts.
0.0 (0 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
580 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 12
  • Length 29 mins
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2015 English

Course Description

This is a step-by-step educational video on how to create your own private, personalized budget. You can use any software you like. The included template is 100% compatible with any platform.

This course involves basic accounting and spreadsheets. 

Download the one-year template at the beginning of the course. Watch the videos and fill it out, step-by-step.

There are about 12 videos with an average length of 5 minutes each. It should take between 1-3 hours to complete.

At the end, you will see your monthly totals, balances and future forecasts.

  • The more you use it, the more accurate you become
  • Stay on track with daily spending
  • Plan savings and/or for retirement
  • Track and include the value of assets/investments
  • Predict cash shortages
  • Know when and where your money is going
  • Make the best choices for YOU



What are the requirements?

  • Basic understanding of any spreadsheet software will be helpful but not completely necessary.
  • Any spreadsheet software capable of opening an Open Office Calc or Excel spreadsheet document.
  • Ability to access Google Documents on any computer will also do in a pinch.

What am I going to get from this course?

  • Learn a simple but powerful toolset for practicing the day-to-day skills necessary to become an expert at personal finance.
  • Become familiar with the basics of accounting as it relates to personal finance.
  • Practice the basics of spreadsheeting editing and formula creation in a real-world application.
  • Plot, organize and analyze an entire year's expenses and expected monthly balance in any contemporary spreadsheet software.
  • Make future predictions based on potential earnings expectations.
  • Make future predictions based on potential unforseen expenses.
  • Schedule and execute all monthly payments on time every time.
  • Proactively plan and execute long-term savings goals.
  • Aggressively isolate and eliminate unnecessary debts.
  • Draw upon accurate and timely information to make the best decisions possible before spending.

What is the target audience?

  • Anyone who wants to learn a simple, but effective technique for budgeting in a proven, 100% confidential, 100% compatible software environment.
  • Anyone who wants to gain more experience working in Excel, Google Documents, or Open Office Calc but never had a real-life application to work with.
  • Anyone who wishes they had greater control of their spending and ability to pay back debts.
  • Anyone who wants to gain a foundation in money management for future investment ability.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Start Here
01:40

Voice-over screen-cap description of the course and the instructor.

03:50

Voice-over screen-cap overview of the Cash Dash.

Article

A text note on compatible software. This lecture also contains the Cash Dash template file for you to download.


03:25

A voice-over screen-capture walk-through of setting up your monthly expenses.

01:52

A voice-over screen-capture walk-through of setting up your Liquid Assets and Accounts Sections.

03:39

A voice-over screen-capture walk-through on how to derive monthly balance predictions based on expected incomes and expenses.

Article

A slide on recovering from a fatal file error or just starting from scratch.

Section 1 Quiz
5 questions
Section 2: Information Items and Payment Schedules
03:14

A voice-over screen-cap walk-through on how to set up and organize the monthly payments section, hard assets and information items.

Section 2 Quiz
5 questions
Section 3: Using the Cash Dash
03:12

A voice-over screen-cap walk-through of the day-to-day procedures for keeping the Cash Dash updated.

04:23

A voice-over screen-cap walk-through of the month end procedure, making new predictions and simple editing.

Article

A quick slide on Taxes.

Section 3 Quiz
10 questions
Section 4: Wrapping Up - Final Thoughts and Future Courses
Article

Final thoughts for students completing the course.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Cimarron Benjamin, Media Producer

I live at the intersection of art and tech. 

I'm a Canadian citizen, born and raised.

I have a lifelong passion for knowledge. 

I like to spend my free time creatively. I believe that health and passion are more important than wealth and productivity.

Which is why I believe it is so important to get the most out of time.







Ready to start learning?
Take This Course