Udemy

Microsoft Excel - Managing Personal Finances with Excel

Enroll Now
  • 2,988 Students
  • Updated 3/2024
  • Certificate Available
4.7
(636 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 1 Minute(s)
Language
English
Taught by
Kyle Pew • 2,000,000+ Students, Office Newb
Certificate
  • Available
  • *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
4.7
(636 Ratings)

Course Overview

Microsoft Excel - Managing Personal Finances with Excel

Start a Plan to Gain Financial Awareness and Confidence by Creating a Personal Finance Template with Microsoft Excel

Where Did It All Go?

When I was younger my mom would say, I must have a hole in my pocket, referring to me. The problem was, I would get my paycheck, from my after-school job, and in the blink of an eye the money would be gone. I had spent my entire paycheck without realizing where it all had gone. My mom was convinced I must have a hole in my pocket and the money was falling out.

Have you ever felt that way? All the hard work you've put in the previous week has finally paid off and your back account is in the positive. But, before you can ask where it all has gone, the money is spent, and your account is starting to dwindle in size.

It's been many years since I've heard my mom ask me if I have a hole in pocket. Today, the money still gets spent, but I now know where it goes.


It Starts with a Plan

In this course on using Microsoft Excel to Manage Your Personal Finances, I will guide you on how Excel can help you create and stick with a plan for managing your own personal finances.

We'll start by creating a customizable Excel Template that will help you track your daily and monthly spending habits. By tracking your spending, we can gain control over our spending habits and gain confidence in our finances. If we first have a plan for our money, we can follow that plan and come out on top within our budget.

One of the main characters from a favorite TV show I watched when I was younger, use to say, "I love it when a plan comes together!"

As we harness the power of Microsoft Excel to help track our budget, you'll begin to see the plan come together.


Putting the Plan Together

Ultimately the plan is effectively budget our spending. But, in order to get there, I will walk you step by step using Microsoft Excel to create a template for your budget. The template will include:

  • Effective Use of Excel Tables to Manage our Expenses. (Bills, Expenses, Subscriptions, etc.)

  • Simple Excel Formulas Calculating and Summarizing our Spending Habits.

  • Key Chart Visuals Identifying where our Money has Gone.

  • Apply Conditions on the Budget to Help Drive Smart Decisions on our Spending.


Stich up the holes in your pockets by enrolling in this course on using Microsoft Excel to Manage your Personal Finances and start your plan to become more financially aware with your own finances. 

See you in the course.




Course Content

  • 8 section(s)
  • 45 lecture(s)
  • Section 1 Course Introduction - Microsoft Excel - Managing Personal Finances with Excel
  • Section 2 Initial Table Setup - Microsoft Excel - Managing Personal Finances with Excel
  • Section 3 Expense Table Formulas - Microsoft Excel - Managing Personal Finances with Excel
  • Section 4 Personal Finance Chart - Microsoft Excel - Managing Personal Finances with Excel
  • Section 5 Calculated Callouts - Microsoft Excel - Managing Personal Finances with Excel
  • Section 6 Finishing Touches - Microsoft Excel - Managing Personal Finances with Excel
  • Section 7 Performing Excel Calculations for Loans and Investments
  • Section 8 Congratulations on Completing the Course

What You’ll Learn

  • Learn to Manage your Daily Personal Finances with Microsoft Excel
  • Create a Customizable, Personal Monthly Budget Excel Template from Scratch
  • Track and Identify where your Money is being Spent with Key Excel Visuals based on your Personal Budget
  • Use Microsoft Excels Dynamic Tools to Identify your Savings Goals within your Budget

Skills covered in this course


Reviews

  • C
    Chris Howard
    5.0

    Great course so far , just what I needed to help me with my monthly finances :)

  • R
    Robert L Oglesby
    5.0

    This is awesome! Love the way the instructor teaches. He teaches in a way that make working in Excel easy and I appreciates it.

  • L
    Laurie-Yolita Louissaint
    5.0

    Amazing course! Amazing course! I have not only sharpened my Excel skills but also deepened my knowledge of personal finance. Thank you very much, Kyle!

  • N
    Nisa.faridz
    5.0

    Yes, I am a beginner in using Excel and creating a personal budget tracker. The instructor is very engaging and helpful. The only problem I have is that I am using Mac, so some interfaces are different, but the Q&A section helps a lot.

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed