Personal and family budget management
4.2 (24 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.
197 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Personal and family budget management to your Wishlist.

Add to Wishlist

Personal and family budget management

A guide to manage your personal and family budget effectively while eliminating debt and starting a savings.
4.2 (24 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.
197 students enrolled
Created by Daniel Moran
Last updated 11/2015
Current price: $10 Original price: $30 Discount: 67% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Develop a basic personal/family finance framework and apply it to your day-to-day life.
  • Identify different types of income and expenses and organize this information in a structured and effective way.
  • Analyze your incomes and expenses to identify potential financial difficulties in advance.
  • Set attainable financial goals and break them down to measurable milestones.
  • Learn advanced google spreadsheets usage.
View Curriculum
  • Willingness to learn and change your financial habits.
  • Internet connection to watch the lectures and use google spreadsheets

In this course you will learn how to track and control your personal/family spendings to be able to enjoy life and save money. Together we will create a transparent month-by-month personal/family financial plan for you to follow. By the end of the course you will set your financial goals (e.g., buy a house 5 years from now, save $1m for retirement) broken down into measurable and achievable milestones.

Section #1 to #3 will introduce the basic concepts regarding personal and family finance, how to use google spreadsheets to manage your finances and how to discuss your financial situation with the family and identify your financial habits.

Sections #4 and #5 will show you how to set realistic goals, plan your budget accordingly and balance your income and expenses.

Section #6 will offer you ways to travel and have fun while saving.

Section #7 will advise how to bring up financial matters to your family members and close friends and find out about potential next steps.

This is a "living" course, I instructed it as a workshop several times and elaborated according to what participants requested. If you find I went through a subject to fast, please say and I will record an explanation.

During the course and a year after I will revise your progress and comment on your financial plan and goals.

To introduce myself, my name is Daniel Moran, I am a business and personal finance consultant. I have been working in this field for 5 years. Along the way I have consulted dozens of families managing their budget, paying back debts, taking a mortgage and other financial issues. Every Monday I start the week with reviewing my family's finances.

Who is the target audience?
  • Everyone who earns and spends money. This course is designed to be universal.
  • Everyone who wants to have more control over their finances.
  • Everyone who dreams big (buying a house, opening a business, travelling), but do not know how to achieve it.
  • Everyone who does not know how much money they have at their bank accounts and how much they owe.
  • Everyone who just started a family life and wants to avoid future financial issues as much as possible.
  • Anyone who wants to plan the terms in which he wants to take a loan
  • Anyone who looks for specific guidelines such as how to submit a tax refund in a particular country SHOULD NOT take the course
  • Anyone who seeks how to make money quickly on stock-markets, selling products on internet, etc. SHOULD NOT take the course
Students Who Viewed This Course Also Viewed
Curriculum For This Course
26 Lectures
2 Lectures 04:21

This is a short introduction to your instructor and to the structure of the course

Preview 03:03

Understand the basic value you must have in order to control your finance

Google spreadsheets
5 Lectures 23:48

In this lecture I am going to show you how our spreadsheet where we will put all our financial data will look like.

If you want to skip the google spreadsheets section, you can use the link to the sample, copy it to your own google drive or download it as Microsoft Excel spreadsheet, erase the sample data and use it as your own.

Preview 02:13

Here I will show you how to start creating the spreadsheet step by step, by creating the file, writing the titles, wrapping text, adding fixed rows, filters, etc.

Preview 07:03

In this lecture I will show you the basics of using pivot tables. A very powerful reporting tool.

Preview 07:23

This lecture will teach you how to have data validation on your transactions sheet so you will be warned if you entered invalid data

Preview 04:18

In this lecture we will learn how to make the table prettier and format the cells based on the values in them.

Preview 02:51
Visiting the past
6 Lectures 27:25

Time to face the numbers...

In this lecture, we will start writing down past expenses and discuss how to write a facts based list of all transactions.

Facts about expense are usually in the form of: “On D date, X amount was spent from Y account”, three factors: amount, where from and date.

Write down past expenses

When it comes to the question of “what the amount was spent on”, it is hard to keep opinions out. For example, if I bought earrings for my fiance for her birthday - what should be written in the 'what the amount was spent on?' - gift for birthday?

You want to keep this spreadsheet as factual as possible, don't try to answer “why the money was spent?” or “what for?” which is yet another version of why? on the what column. Whether the expense was necessary or optional, big or small, repetitive or happened only once does not matter.
Spent on what?

Here we'll learn how to categorise transactions in a mutually exclusive way to avoid confusions when analyzing.

Categorising transactions

In order to make our lives easier when making reports, we can generate some additional information automatically.

  • Week of the year
  • Month of the year
  • Day of the week
Generated data

Usually people earn money to their bank account and spend from their credit card or withdraw cash from ATM. Since a transfer involves two accounts, it will be written as two rows in our spreadsheet.

In this lecture I will show how to do it

Transfers between accounts

Finding a mismatch between our reports and the real data (e.g., from the bank website) should not be frustrating. You can easily filter the transactions of a specific account and track which transaction you missed writing down.

Keeping accounts balanced
Setting goals
4 Lectures 18:29

A short introduction to goal setting

Why only now?

First step of setting goals is to have a vision. Here we will work together to articulate it and translate it to financial requirements

Vision the future

In this lecture we will learn the SMART framework to set up goals.

Use the worksheet attached to write your own goals and share them on the discussions.


Identify good/bad examples of goals and fix them.

3 questions

This lecture will discuss about why you set your specific goals, and why you don't already have them.

Trade offs
Derive and plan budgets
3 Lectures 36:48

In this lecture we will discuss how to work on a budget based on your goals and your current expenses

Stabilize income and expenses

In this video I will explain about when you should take a loan, and more importantly, when you should not.

I will show you how to plan a loan payment schedule and how it will affect your monthly budget.

Planning a loan part I

In part I I explained when it is right to take a loan and how to build possible payment schedules.

In this part I am explaining how to decide which payment schedule to choose based on your future income.

Planning a loan part II
Tips and tricks
3 Lectures 16:52

This section is all about tips & tricks I picked up along the way.

This lecture is about how to travel cheaper.

Add some of your own tips.

Travelling cheap

This lecture is about how to enjoy cooking what you love to eat at home can benefit your financial state and your social life

Cook and eat at home

This lecture is about hobbies. I added examples on how to study, read, play chess, and learn programming for free.

Add your own examples in the discussion board.

Entertain yourself cheaply

Tips and tricks
3 questions
Wrap up
3 Lectures 14:43

In this lecture I will share my ideas on how to discuss with family members about money.

It can be frustrating to raise the issue and the purpose is to make the discussion more natural and hopefully productive.

How to talk to family members about finance?

In this lecture I will share my ideas about how to discuss money matters with your friends (close and less close).

Friends can (and should) help you achieve your financial goals and not discourage you. If you communicate it right - they will help you.

How to talk to friends about finance?

Thank you for participating in this course.

I hope you enjoyed and benefited from the material.

Feel free to write me any question you have to the email.

If you have a suggestion related to the course I would appreciate you writing me in an email.

Thanks and good luck!


Next steps
About the Instructor
Daniel Moran
4.2 Average rating
24 Reviews
197 Students
1 Course
Dev Manager, Entrepreneur & Finance management professional

Daniel has extensive experience mentoring families & individuals in all stages of life how to manage their finances. While working as a management consultant at Boston Consulting Group, he has volunteered in Paamonim, an Israeli organization teaching financial management basics to families in need.

Daniel got engaged in 2014 and while planning their marriage in the Caribbeans, they managed to purchase a house and a car. Nowadays, Daniel works at EMC Israel as a development manager, consulting start-ups with technology issues and continues to mentor families with financial planning, mortgage planning, etc.