personal budget template in excel personal finance dashboar

personal budget template in excel personal finance dashboard template free download

In this video I demonstrate how to create a personal budget in Excel. You can follow the instructions to create your own template or download the template for free here: https://www.bluepecantraining.com/wp-content/uploads/2021/12/Personal-Budget-Template.xlsx

The template includes a two personal finance dashboards: the first displays a breakdown of monthly expenditure and the second displays a breakdown of annual expenditure.

If you want to follow the video tutorial the files you need are:
https://www.bluepecantraining.com/wp-content/uploads/2021/12/Personal-Budget-Template-Use-to-Follow-Video.xlsx
https://www.bluepecantraining.com/wp-content/uploads/2021/12/Data.xlsx


Table of Contents:

00:00 - Introduction
01:52 - Create the Record of Outgoings and Income Table
04:06 - Use the YEAR Function to Extract Year
04:50 - Use the TEXT Function to Extract Month Name
05:32 - Create Dependent Drop-Downs
10:37 - Budget Calculations Using SUMIFS
15:21 - Fixing Column References in a Table
20:18 - Income Calculations Using SUMIFS
24:31 - Date Drop-downs on the Month Dashboard
25:35 - Creating a Colour Palette for Your Dashboards
26:58 - Add Expenditure Category Icons
28:40 - Expenditure Conditional Formatting - Data Bars and Icons
33:49 - Create a Doughnut Chart (Month Dashboard)
37:05 - Create a Budget Chart (Month Dashboard)
40:51 - Create an Income Chart (Month Dashboard)
43:33 - Actual vs Target (Month Dashboard)
48:20 - Year Dashboard Introduction
48:55 - Expenditure Conditional Formatting - Data Bars and Icons
51:42 - Create a Doughnut Chart (Year Dashboard)
52:36 - Create a Budget Chart (Year Dashboard)
55:13 - Create an Income Chart (Year Dashboard)
57:24 - Create an Expenditure Chart (Year Dashboard)
58:49 - Add Budget Line (Error Bar) to Expenditure Chart (Year Dashboard)
1:01:45 - Actual vs Target (Year Dasboard)

In this video I demonstrate how to create a personal budget in Excel. You can follow the instructions to create your own template or download the template for free here: https://www.bluepecantraining.com/wp-content/uploads/2021/12/Personal-Budget-Template.xlsxThe template includes a two personal finance dashboards: the first displays a breakdown of monthly expenditure and the second displays a breakdown of annual expenditure.If you want to follow the video tutorial the files you need are:https://www.bluepecantraining.com/wp-content/uploads/2021/12/Personal-Budget-Template-Use-to-Follow-Video.xlsxhttps://www.bluepecantraining.com/wp-content/uploads/2021/12/Data.xlsxTable of Contents: 00:00 - Introduction01:52 - Create the Record of Outgoings and Income Table04:06 - Use the YEAR Function to Extract Year04:50 - Use the TEXT Function to Extract Month Name05:32 - Create Dependent Drop-Downs10:37 - Budget Calculations Using SUMIFS15:21 - Fixing Column References in a Table20:18 - Income Calculations Using SUMIFS24:31 - Date Drop-downs on the Month Dashboard25:35 - Creating a Colour Palette for Your Dashboards26:58 - Add Expenditure Category Icons28:40 - Expenditure Conditional Formatting - Data Bars and Icons33:49 - Create a Doughnut Chart (Month Dashboard)37:05 - Create a Budget Chart (Month Dashboard)40:51 - Create an Income Chart (Month Dashboard)43:33 - Actual vs Target (Month Dashboard)48:20 - Year Dashboard Introduction48:55 - Expenditure Conditional Formatting - Data Bars and Icons51:42 - Create a Doughnut Chart (Year Dashboard)52:36 - Create a Budget Chart (Year Dashboard)55:13 - Create an Income Chart (Year Dashboard)57:24 - Create an Expenditure Chart (Year Dashboard)58:49 - Add Budget Line (Error Bar) to Expenditure Chart (Year Dashboard)1:01:45 - Actual vs Target (Year Dasboard)

7 financial goals to achieve in your 20 s life changingwhy we should learn about money financial literacy guide to personal financespersonal finance 101 understanding personal finance basics and best practices3rd grade math personal financial literacy human capital and laborpersonal finance tracker in excelfinancial planning a guide to personal financehow to save money and become rich personal financial planning course p2 ca rachana phadke ranadewhat is personal financial planning and its importance hindi3rd grade math personal financial literacy spending and savingpersonal budget template in excel personal finance dashboard template free downloadbusiness loan personal financial statement for sba commercial lenders episode 90personal financial management the core four of personal financepersonal financial plan assignment videothe personal financial ladderpersonal financial planning webinar daniel mainye cytonn investmentsempowered planning your personal financial strategy5th grade math personal financial literacy taxespersonal financial literacy part 1personal financial planningpersonal finance 101 understanding personal finance basics and best practicespersonal financial management basics bankingpersonal financial goalslecture 6 personal financial planning chapter 1what is personal financial planning how can it help in achieving goals10 personal financial planning tipscreating personal financial statements your net worth and projecting financial future template7 assets that will make you rich personal finance for beginners ankur warikoo hindiwhat is personal finance student edition learn in your 20 spersonal financial planning 5 steps a guide to personal finance for your familypersonal finance financial literacy pt 1 budgeting random research centrepersonal finance for dummies 2021 achieve financial freedom4th grade math personal financial literacy financial institutionspersonal financial management basics managing expenseshow i manage 28 financial accounts in one free apppersonal financial management pfm demognucash for personal finance getting started and basicssavings challenges cash envelope stuffing march 2022 kerensa amanda5 tips on personal financial managementpersonal finance 101 in 50 minutesbasics of personal financial planningempower your personal finance unblocking major obstacles to achieve personal financial freedompersonal financial planning fin533personal financial management and financial literacy by nik safirapersonal financial management and financial literacypersonal financial plan for everyone easy steps to your financial freedom abhimanyu goal fy 22fin533 personal financial statements syed tariqpersonal financial planning 6 steps in your family s financial futurepersonal financial planning 3 key steps in protecting your family wealthwhy the need for islamic personal financial planningwhat is financial management role of financial literacy in managing personal finance urdu hindipersonal financial statement template in excel an accion texas videowhy personal financial management is so important personalfinance101

In this video I demonstrate how to create a personal budget in Excel. You can follow the instructions to create your own template or download the template for free here: https://www.bluepecantraining.com/wp-content/uploads/2021/12/Personal-Budget-Template.xlsx

The template includes a two personal finance dashboards: the first displays a breakdown of monthly expenditure and the second displays a breakdown of annual expenditure.

If you want to follow the video tutorial the files you need are:
https://www.bluepecantraining.com/wp-content/uploads/2021/12/Personal-Budget-Template-Use-to-Follow-Video.xlsx
https://www.bluepecantraining.com/wp-content/uploads/2021/12/Data.xlsx


Table of Contents:

00:00 - Introduction
01:52 - Create the Record of Outgoings and Income Table
04:06 - Use the YEAR Function to Extract Year
04:50 - Use the TEXT Function to Extract Month Name
05:32 - Create Dependent Drop-Downs
10:37 - Budget Calculations Using SUMIFS
15:21 - Fixing Column References in a Table
20:18 - Income Calculations Using SUMIFS
24:31 - Date Drop-downs on the Month Dashboard
25:35 - Creating a Colour Palette for Your Dashboards
26:58 - Add Expenditure Category Icons
28:40 - Expenditure Conditional Formatting - Data Bars and Icons
33:49 - Create a Doughnut Chart (Month Dashboard)
37:05 - Create a Budget Chart (Month Dashboard)
40:51 - Create an Income Chart (Month Dashboard)
43:33 - Actual vs Target (Month Dashboard)
48:20 - Year Dashboard Introduction
48:55 - Expenditure Conditional Formatting - Data Bars and Icons
51:42 - Create a Doughnut Chart (Year Dashboard)
52:36 - Create a Budget Chart (Year Dashboard)
55:13 - Create an Income Chart (Year Dashboard)
57:24 - Create an Expenditure Chart (Year Dashboard)
58:49 - Add Budget Line (Error Bar) to Expenditure Chart (Year Dashboard)
1:01:45 - Actual vs Target (Year Dasboard)