Copyright Notice read tutorial watch tutorial

The content in this file was created by Mynda Treacy from My Online Traini
Individual users are permitted to recreate the examples for personal practi
Recreating the examples for training or demonstration to others is not per

The workbook and any sheets within must be accompanied by the following

This sheet must remain in any file that uses this data and or these techniqu
Any uses of this workbook and/or data must include the above attribution.

Disclaimer: use this workbook at your own risk. My Online Training Hub offe
own due dilligence to ensure it meets your needs.
 watch tutorial

m My Online Training Hub.

for personal practice only.
o others is not permitted, unless written consent is granted by Mynda Treacy.

ied by the following copyright notice: My Online Training Hub ©.

d or these techniques.
above attribution.

ne Training Hub offers no guarantee that this file is free from errors. You should do your
Get started
y Mynda Treacy.

ors. You should do your

Get started
 Reporting Categories

Sub-category Category Category Type

Clothes 💳 Discretionary Expense Add/change Sub-categ
Coffee 🍴 Dining Out Expense and Categories as req
Dentist 🩺 Medical Expense
Dividends 📉 Variable Income Note: delete the whole
remove any you don't
Doctor 🩺 Medical Expense
and add new categorie
Donation 🫱 Charity Expense the next available row
Entertainment 💳 Discretionary Expense the table.
Furnishings 💳 Discretionary Expense
Gas/Electrics 🏠 Living Expenses Expense
Gifts 💳 Discretionary Expense
Groceries 🏠 Living Expenses Expense
Gym 💳 Discretionary Expense
Interest 📉 Variable Income
MV Fuel 🚙 Transport Expense
MV Loan 🚙 Transport Expense
Phone 🏠 Living Expenses Expense
Rent 🏠 Living Expenses Expense
Restaurant 🍴 Dining Out Expense
Salary 💰 Fixed Income
Taxi 🚙 Transport Expense
Next Step
Vacation 💳 Discretionary Expense
 Excel Tables Course

Add/change Sub-categories
and Categories as required.

Note: delete the whole row to

remove any you don't require
and add new categories on
the next available row under
the table.

Next Step
 Budgeted Income & Expenses

Year Sub-category Jan Feb Mar Apr

2024 Salary 4,000.00 4,000.00 4,000.00 4,000.00
2024 Dividends 1,500.00
2024 Interest 50.00 50.00 50.00 50.00
2024 Gas/Electrics -150.00 -150.00
2024 Rent -900.00 -900.00 -900.00 -900.00
2024 Groceries -650.00 -650.00 -650.00 -650.00
2024 Entertainment -125.00 -125.00 -125.00 -125.00
2024 Clothes -290.00 -290.00 -290.00 -290.00
2024 MV Loan -150.00 -150.00 -150.00 -150.00
2024 MV Fuel -170.00 -170.00 -170.00 -170.00
2024 Restaurant -150.00 -150.00 -150.00 -150.00
2024 Coffee -100.00 -100.00 -100.00 -100.00
2024 Gym -30.00 -30.00 -30.00 -30.00
2024 Phone -40.00 -40.00 -40.00 -40.00
2024 Gifts -60.00 -60.00 -60.00 -60.00
2024 Dentist -150.00
2024 Doctor -20.00 -20.00 -200.00 -20.00
2024 Taxi -50.00 -50.00 -50.00 -50.00
2024 Donation -60.00 -60.00 -60.00 -60.00
2024 Vacation -700.00

Add more rows for

future years or new
sub-categories.
& Expenses

May Jun Jul Aug Sep Oct Nov

4,000.00 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00
1,500.00
50.00 50.00 50.00 50.00 50.00 50.00 50.00
-150.00 -150.00
-900.00 -900.00 -900.00 -900.00 -900.00 -900.00 -900.00
-650.00 -650.00 -650.00 -650.00 -650.00 -650.00 -650.00
-125.00 -125.00 -125.00 -125.00 -125.00 -125.00 -125.00
-290.00 -290.00 -290.00 -290.00 -290.00 -290.00 -290.00
-150.00 -150.00 -150.00 -150.00 -150.00 -150.00 -150.00
-170.00 -170.00 -170.00 -170.00 -170.00 -170.00 -170.00
-150.00 -150.00 -150.00 -150.00 -150.00 -150.00 -150.00
-100.00 -100.00 -100.00 -100.00 -100.00 -100.00 -100.00
-30.00 -30.00 -30.00 -30.00 -30.00 -30.00 -30.00
-40.00 -40.00 -40.00 -40.00 -40.00 -40.00 -40.00
-60.00 -60.00 -60.00 -60.00 -60.00 -60.00 -60.00
-150.00
-20.00 -20.00 -20.00 -20.00 -200.00 -20.00 -20.00
-50.00 -50.00 -50.00 -50.00 -50.00 -50.00 -50.00
-60.00 -60.00 -60.00 -60.00 -60.00 -60.00 -60.00
-800.00
 Data Validation Tutorial

Dec
Replace budget data with
5,000.00
your own figures. Enter
income as positive values and
50.00 expenses as negative values.

-900.00
-650.00
-125.00
-290.00
-150.00
-170.00
-150.00
-100.00
-30.00
-40.00
-60.00

-20.00
-50.00
-60.00
Next Step
 Bank Transactions
This shape represents a This shape represents a table slicer. Table slicers are not supported in this version of
table slicer. Table Excel.
slicers are not
supported in this If the shape was modified in an earlier version of Excel, or if the workbook was saved in
version of Excel. Excel 2007 or earlier, the slicer can't be used.

If the shape was

modified in an earlier
version
Account of Excel, or ifDate Description Debit Credit
the workbook
Checking was 1/4/2024 ACME Pty Ltd 4000
saved in Excel 2007 or
Saving
earlier, the slicer can't 1/1/2024 Interest 35
Credit
be used. 1/4/2024 Ground 5
Checking 1/5/2024 Estate Mgt. 900
Checking 1/5/2024 Finance Co. 150
Credit 1/5/2024 Ground 5
Credit 1/6/2024 Ground 5
Credit 1/7/2024 Ground 5
Credit 1/8/2024 Ground 5
Credit 1/8/2024 Green's 155
Checking 1/11/2024 Elec. Co. 100
Credit 1/11/2024 Ground 5
Credit 1/12/2024 Ground 5
Credit 1/13/2024 Fuel. Co 77
Credit 1/13/2024 Ground 5
Credit 1/14/2024 Ground 5
Credit 1/15/2024 Green's 135
Credit 1/15/2024 Ground 5
Credit 1/16/2024 Ground 5
Credit 1/16/2024 Event Cinemas 40
Credit 1/16/2024 Fashionistas 98
Credit 1/16/2024 Joe's Grill 52
Credit 1/17/2024 Taxi Co. 28
Checking 1/18/2024 Muscle Beach 30
Credit 1/18/2024 Ground 5
Credit 1/19/2024 Ground 5
Checking 1/19/2024 Smile Dental 154
Checking 1/19/2024 Phone Co. 40
Credit 1/20/2024 Sam's Gifts 45
Credit 1/20/2024 Streaming Co. 32
Credit 1/20/2024 Ground 5
Credit 1/21/2024 Ground 5
Credit 1/22/2024 Ground 5
Credit 1/22/2024 Green's 170
Credit 1/23/2024 Pizza Pomodoro 37
Credit 1/24/2024 Golden Arches 12
Checking 1/25/2024 Worldvision 55
Credit 1/25/2024 Fuel. Co 63
Credit 1/25/2024 Ground 5
Credit 1/26/2024 Ground 5
Credit 1/27/2024 Ground 5
Credit 1/28/2024 Ground 5
Credit 1/29/2024 Ground 5
Credit 1/29/2024 Green's 162
Credit 1/30/2024 Ted's Trainers 125
Credit 1/30/2024 Ticketek 175
Credit 1/31/2024 Fashionistas 145
Credit 1/31/2024 Taxi Co. 23
Saving 2/1/2024 Interest 36
Checking 2/1/2024 ACME Pty Ltd 4000
Credit 2/1/2024 Ground 5
Checking 2/2/2024 Estate Mgt. 900
Checking 2/2/2024 Finance Co. 150
Credit 2/2/2024 Ground 5
Credit 2/3/2024 Ground 5
Credit 2/4/2024 Ground 5
Credit 2/5/2024 Ground 5
Credit 2/5/2024 Green's 205
Checking 2/8/2024 Elec. Co. 51.1
Credit 2/8/2024 Ground 5
Credit 2/9/2024 Ground 5
Credit 2/10/2024 Fuel. Co 78
Credit 2/10/2024 Ground 5
Credit 2/11/2024 Ground 5
Credit 2/12/2024 Green's 135.9
Credit 2/12/2024 Ground 5
Credit 2/13/2024 Ground 5
Credit 2/13/2024 Event Cinemas 40.9
Credit 2/13/2024 Fashionistas 99
Credit 2/13/2024 Joe's Grill 53
Credit 2/14/2024 Taxi Co. 28.9
Checking 2/15/2024 Muscle Beach 30
Credit 2/15/2024 Ground 5
Credit 2/16/2024 Ground 5
Checking 2/16/2024 Phone Co. 40
Credit 2/17/2024 Sam's Gifts 45.9
Credit 2/17/2024 Streaming Co. 35
Credit 2/17/2024 Ground 5
Credit 2/18/2024 Ground 5
Credit 2/19/2024 Ground 5
Credit 2/19/2024 Green's 171
Credit 2/20/2024 Pizza Pomodoro 37.9
Credit 2/21/2024 Golden Arches 12.9
Checking 2/22/2024 Worldvision 55
Credit 2/22/2024 Fuel. Co 64.1
Credit 2/22/2024 Ground 5
Credit 2/23/2024 Ground 5
Credit 2/24/2024 Ground 5
Credit 2/25/2024 Ground 5
Credit 2/26/2024 Ground 5
Credit 2/26/2024 Green's 162.9
Credit 2/27/2024 Ted's Trainers 125.9
Credit 2/27/2024 Global Fashion 137
Credit 2/28/2024 Fashionistas 146.1
Credit 2/28/2024 Taxi Co. 24.1
Checking 3/1/2024 ACME Pty Ltd 4000
Saving 3/1/2024 Interest 37
Credit 3/1/2024 Ground 5
Checking 3/2/2024 Estate Mgt. 900
Checking 3/2/2024 Finance Co. 150
Credit 3/2/2024 Ground 5
Credit 3/3/2024 Ground 5
Credit 3/4/2024 Ground 5
Credit 3/5/2024 Ground 5
Credit 3/5/2024 Green's 149
Checking 3/8/2024 Elec. Co. 52.1
Credit 3/8/2024 Ground 5
Credit 3/9/2024 Ground 5
Credit 3/10/2024 Fuel. Co 78.9
Credit 3/10/2024 Ground 5
Credit 3/11/2024 Ground 5
Credit 3/12/2024 Green's 137
Credit 3/12/2024 Ground 5
Credit 3/13/2024 Ground 5
Credit 3/13/2024 Event Cinemas 41.8
Credit 3/13/2024 Fashionistas 99.9
Credit 3/13/2024 Joe's Grill 54
Credit 3/14/2024 Taxi Co. 30
Checking 3/15/2024 Muscle Beach 30
Credit 3/15/2024 Ground 5
Credit 3/16/2024 Ground 5
Checking 3/16/2024 Village Medical 75
Checking 3/16/2024 Phone Co. 40
Credit 3/17/2024 Sam's Gifts 46.8
Credit 3/17/2024 Streaming Co. 35
Credit 3/17/2024 Ground 5
Credit 3/18/2024 Ground 5
Credit 3/19/2024 Ground 5
Credit 3/19/2024 Green's 171.9
Credit 3/20/2024 Pizza Pomodoro 39
Credit 3/21/2024 Golden Arches 14
Checking 3/22/2024 Worldvision 55
Credit 3/22/2024 Fuel. Co 65
Credit 3/22/2024 Ground 5
Credit 3/23/2024 Ground 5
Credit 3/24/2024 Ground 5
Credit 3/25/2024 Ground 5
Credit 3/26/2024 Ground 5
Credit 3/26/2024 Green's 209
Credit 3/27/2024 Ted's Trainers 127
Credit 3/27/2024 Sports Co. 177.2
Credit 3/28/2024 Fashionistas 147.1
Credit 3/28/2024 Taxi Co. 25
Credit 3/29/2024 Foodary 15
Credit 3/30/2024 Ground 5
Credit 3/31/2024 Ground 5
Checking 3/31/2024 Amoogle 1350
Checking 4/1/2024 ACME Pty Ltd 4000
Saving 4/1/2024 Interest 38
Credit 4/1/2024 Ground 5
Checking 4/2/2024 Estate Mgt. 900
Checking 4/2/2024 Finance Co. 150
Credit 4/2/2024 Ground 5
Credit 4/3/2024 Ground 5
Credit 4/4/2024 Ground 5
Credit 4/5/2024 Ground 5
Credit 4/5/2024 Green's 158.2
Checking 4/8/2024 Elec. Co. 53.2
Credit 4/8/2024 Ground 5
Credit 4/9/2024 Ground 5
Credit 4/10/2024 Fuel. Co 79.9
Credit 4/10/2024 Ground 5
Credit 4/11/2024 Ground 5
Credit 4/12/2024 Green's 98
Credit 4/12/2024 Ground 5
Credit 4/13/2024 Ground 5
Credit 4/13/2024 Event Cinemas 42.8
Credit 4/13/2024 Fashionistas 100.9
Credit 4/13/2024 Joe's Grill 54.9
Credit 4/14/2024 Taxi Co. 31
Checking 4/15/2024 Muscle Beach 30
Credit 4/15/2024 Ground 5
Credit 4/16/2024 Ground 5
Checking 4/16/2024 Phone Co. 40
Credit 4/17/2024 Sam's Gifts 47.9
Credit 4/17/2024 Streaming Co. 35
Credit 4/17/2024 Ground 5
Credit 4/18/2024 Ground 5
Credit 4/19/2024 Ground 5
Credit 4/19/2024 Green's 173
Credit 4/20/2024 Pizza Pomodoro 40.1
Credit 4/21/2024 Golden Arches 15.1
Checking 4/22/2024 Worldvision 55
Credit 4/22/2024 Fuel. Co 66
Credit 4/22/2024 Ground 5
Credit 4/23/2024 Ground 5
Credit 4/24/2024 Ground 5
Credit 4/25/2024 Ground 5
Credit 4/26/2024 Ground 5
Credit 4/26/2024 Green's 164.9
Credit 4/27/2024 Ted's Trainers 127.9
Credit 4/27/2024 BW Club 300
Credit 4/28/2024 Fashionistas 148.1
Credit 4/28/2024 Taxi Co. 26.1
Credit 4/29/2024 Foodary 15
Credit 4/29/2024 Ground 5
Credit 4/30/2024 Ground 5
Credit 5/2/2024 Ground 5
Checking 5/3/2024 ACME Pty Ltd 4000
Saving 5/3/2024 Interest 39
Checking 5/3/2024 Estate Mgt. 900
Checking 5/3/2024 Finance Co. 150
Credit 5/3/2024 Ground 5
Credit 5/4/2024 Ground 5
Credit 5/5/2024 Ground 5
Credit 5/6/2024 Ground 5
Credit 5/6/2024 Green's 170
Checking 5/9/2024 Elec. Co. 54.1
Credit 5/9/2024 Ground 5
Credit 5/10/2024 Ground 5
Credit 5/11/2024 Fuel. Co 81
Credit 5/11/2024 Ground 5
Credit 5/12/2024 Ground 5
Credit 5/13/2024 Green's 139.1
Credit 5/13/2024 Ground 5
Credit 5/14/2024 Ground 5
Credit 5/14/2024 Event Cinemas 43.9
Credit 5/14/2024 Fashionistas 101.8
Credit 5/14/2024 Joe's Grill 55.9
Credit 5/15/2024 Taxi Co. 32
Checking 5/16/2024 Muscle Beach 30
Credit 5/16/2024 Ground 5
Credit 5/17/2024 Ground 5
Checking 5/17/2024 Village Medical 75
Checking 5/17/2024 Phone Co. 40
Credit 5/18/2024 Sam's Gifts 49
Credit 5/18/2024 Streaming Co. 35
Credit 5/18/2024 Ground 5
Credit 5/19/2024 Ground 5
Credit 5/20/2024 Ground 5
Credit 5/20/2024 Green's 174
Credit 5/21/2024 Pizza Pomodoro 41.1
Credit 5/22/2024 Golden Arches 16.2
Checking 5/23/2024 Worldvision 55
Credit 5/23/2024 Fuel. Co 67
Credit 5/23/2024 Ground 5
Credit 5/24/2024 Ground 5
Credit 5/25/2024 Ground 5
Credit 5/26/2024 Ground 5
Credit 5/27/2024 Ground 5
Credit 5/27/2024 Green's 165.8
Credit 5/28/2024 Ted's Trainers 128.8
Credit 5/28/2024 Home Decorator 235
Credit 5/29/2024 Fashionistas 149.2
Credit 5/29/2024 Taxi Co. 27.2
Credit 5/31/2024 Foodary 15
Credit 5/30/2024 Ground 5
Credit 5/31/2024 Ground 5
Checking 6/1/2024 ACME Pty Ltd 4000
Saving 6/1/2024 Interest 40
Credit 6/3/2024 Ground 5
Checking 6/3/2024 Estate Mgt. 900
Checking 6/3/2024 Finance Co. 150
Credit 6/3/2024 Ground 5
Credit 6/4/2024 Ground 5
Credit 6/5/2024 Ground 5
Credit 6/6/2024 Ground 5
Credit 6/6/2024 Green's 119
Checking 6/9/2024 Elec. Co. 55
Credit 6/9/2024 Ground 5
Credit 6/10/2024 Ground 5
Credit 6/11/2024 Fuel. Co 82.1
Credit 6/11/2024 Ground 5
Credit 6/12/2024 Ground 5
Credit 6/13/2024 Green's 140.2
Credit 6/13/2024 Ground 5
Credit 6/14/2024 Ground 5
Credit 6/14/2024 Event Cinemas 44.9
Credit 6/14/2024 Fashionistas 102.9
Credit 6/14/2024 Joe's Grill 56.9
Credit 6/15/2024 Taxi Co. 33.1
Checking 6/16/2024 Muscle Beach 30
Credit 6/16/2024 Ground 5
Credit 6/17/2024 Ground 5
Checking 6/17/2024 Phone Co. 40
Credit 6/18/2024 Sam's Gifts 50.1
Credit 6/18/2024 Streaming Co. 35
Credit 6/18/2024 Ground 5
Credit 6/19/2024 Ground 5
Credit 6/20/2024 Ground 5
Credit 6/20/2024 Green's 234
Credit 6/21/2024 Pizza Pomodoro 42.1
Credit 6/22/2024 Golden Arches 17.1
Checking 6/23/2024 Worldvision 55
Credit 6/23/2024 Fuel. Co 67.9
Credit 6/23/2024 Ground 5
Credit 6/24/2024 Ground 5
Credit 6/25/2024 Ground 5
Credit 6/26/2024 Ground 5
Credit 6/27/2024 Ground 5
Credit 6/27/2024 Green's 166.9
Credit 6/28/2024 Ted's Trainers 129.9
Credit 6/28/2024 Ticketek 180.3
Credit 6/29/2024 Fashionistas 150.1
Credit 6/29/2024 Taxi Co. 28.2
Credit 6/29/2024 Foodary 15
Credit 6/30/2024 Ground 5
Credit 7/1/2024 Ground 5
Checking 7/2/2024 ACME Pty Ltd 4000
Saving 7/2/2024 Interest 41
Credit 7/3/2024 Ground 5
Checking 7/5/2024 Estate Mgt. 900
Checking 7/5/2024 Finance Co. 150
Credit 7/5/2024 Fodary 15
Credit 7/5/2024 Ground 5
Credit 7/6/2024 Ground 5
Credit 7/7/2024 Ground 5
Credit 7/7/2024 Green's 180
Checking 7/10/2024 Elec. Co. 56.1
Credit 7/10/2024 Ground 5
Credit 7/11/2024 Ground 5
Credit 7/12/2024 Fuel. Co 83.1
Credit 7/12/2024 Ground 5
Credit 7/13/2024 Ground 5
Credit 7/14/2024 Green's 141.1
Credit 7/14/2024 Ground 5
Credit 7/15/2024 Ground 5
Credit 7/15/2024 Event Cinemas 45.8
Credit 7/15/2024 Fashionistas 103.8
Credit 7/15/2024 Joe's Grill 58
Credit 7/16/2024 Taxi Co. 34.2
Checking 7/17/2024 Muscle Beach 30
Credit 7/17/2024 Ground 5
Credit 7/18/2024 Ground 5
Checking 7/18/2024 Phone Co. 40
Credit 7/19/2024 Sam's Gifts 51.1
Credit 7/19/2024 Streaming Co. 35
Credit 7/19/2024 Ground 5
Credit 7/20/2024 Ground 5
Credit 7/21/2024 Ground 5
Credit 7/21/2024 Green's 176
Credit 7/22/2024 Pizza Pomodoro 43.1
Credit 7/23/2024 Golden Arches 18.2
Checking 7/24/2024 Worldvision 55
Credit 7/24/2024 Fuel. Co 68.8
Credit 7/24/2024 Ground 5
Credit 7/25/2024 Ground 5
Credit 7/26/2024 Ground 5
Credit 7/27/2024 Ground 5
Credit 7/28/2024 Ground 5
Credit 7/28/2024 Green's 193
Credit 7/29/2024 Ted's Trainers 130.8
Credit 7/29/2024 Home Decorator 181.4
Credit 7/30/2024 Fashionistas 151.2
Credit 7/30/2024 Taxi Co. 29.3
Credit 7/30/2024 Foodary 15
Credit 7/31/2024 Ground 5
Credit 8/2/2024 Ground 5
Checking 8/2/2024 ACME Pty Ltd 4000
Saving 8/2/2024 Interest 42
Credit 8/3/2024 Ground 5
Checking 8/5/2024 Estate Mgt. 900
Checking 8/5/2024 Finance Co. 150
Credit 8/5/2024 Ground 5
Credit 8/5/2024 Ground 5
Credit 8/6/2024 Ground 5
Credit 8/7/2024 Ground 5
Credit 8/7/2024 Green's 137
Checking 8/10/2024 Elec. Co. 57
Credit 8/10/2024 Ground 5
Credit 8/11/2024 Ground 5
Credit 8/12/2024 Fuel. Co 84.2
Credit 8/12/2024 Ground 5
Credit 8/13/2024 Ground 5
Credit 8/14/2024 Green's 142.1
Credit 8/14/2024 Ground 5
Credit 8/15/2024 Ground 5
Credit 8/15/2024 Event Cinemas 46.8
Credit 8/15/2024 Fashionistas 104.7
Credit 8/15/2024 Joe's Grill 59.1
Credit 8/16/2024 Taxi Co. 35.1
Checking 8/17/2024 Muscle Beach 30
Credit 8/17/2024 Ground 5
Credit 8/18/2024 Ground 5
Checking 8/18/2024 Phone Co. 40
Credit 8/19/2024 Sam's Gifts 52.1
Credit 8/19/2024 Streaming Co. 35
Credit 8/19/2024 Ground 5
Credit 8/20/2024 Ground 5
Credit 8/21/2024 Ground 5
Credit 8/21/2024 Green's 177
Credit 8/22/2024 Pizza Pomodoro 44.2
Credit 8/23/2024 Golden Arches 19.2
Checking 8/24/2024 Worldvision 55
Credit 8/24/2024 Fuel. Co 69.7
Credit 8/24/2024 Ground 5
Credit 8/25/2024 Ground 5
Credit 8/26/2024 Ground 5
Credit 8/27/2024 Ground 5
Credit 8/28/2024 Ground 5
Credit 8/28/2024 Green's 117
Credit 8/29/2024 Ted's Trainers 131.9
Credit 8/29/2024 Ticketek 182.4
Credit 8/30/2024 Fashionistas 152.3
Credit 8/30/2024 Taxi Co. 30.3
Credit 8/30/2024 Foodary 15
Credit 8/31/2024 Ground 5
Credit 9/2/2024 Ground 5
Checking 9/2/2024 ACME Pty Ltd 4000
Saving 9/2/2024 Interest 43
Credit 9/3/2024 Ground 5
Checking 9/5/2024 Estate Mgt. 900
Checking 9/5/2024 Finance Co. 150
Credit 9/5/2024 Ground 5
Credit 9/5/2024 Ground 5
Credit 9/6/2024 Ground 5
Credit 9/7/2024 Ground 5
Credit 9/7/2024 Green's 163.4
Checking 9/10/2024 Elec. Co. 58.1
Credit 9/10/2024 Ground 5
Credit 9/11/2024 Ground 5
Credit 9/12/2024 Fuel. Co 85.3
Credit 9/12/2024 Ground 5
Credit 9/13/2024 Ground 5
Credit 9/14/2024 Green's 143
Credit 9/14/2024 Ground 5
Credit 9/15/2024 Ground 5
Credit 9/15/2024 Event Cinemas 47.8
Credit 9/15/2024 Fashionistas 105.8
Credit 9/15/2024 Joe's Grill 60.1
Credit 9/16/2024 Taxi Co. 36.2
Checking 9/17/2024 Muscle Beach 30
Credit 9/17/2024 Ground 5
Credit 9/18/2024 Ground 5
Checking 9/18/2024 Phone Co. 40
Credit 9/19/2024 Sam's Gifts 53
Credit 9/19/2024 Streaming Co. 35
Credit 9/19/2024 Ground 5
Credit 9/20/2024 Ground 5
Credit 9/21/2024 Ground 5
Credit 9/21/2024 Green's 177.9
Credit 9/22/2024 Pizza Pomodoro 45.3
Credit 9/23/2024 Golden Arches 20.1
Checking 9/24/2024 Worldvision 55
Credit 9/24/2024 Fuel. Co 70.6
Credit 9/24/2024 Ground 5
Credit 9/25/2024 Ground 5
Credit 9/26/2024 Ground 5
Credit 9/27/2024 Ground 5
Credit 9/28/2024 Ground 5
Credit 9/28/2024 Green's 223
Credit 9/29/2024 Ted's Trainers 132.9
Credit 9/29/2024 Global Fashion 175
Credit 9/30/2024 Fashionistas 153.4
Credit 9/30/2024 Taxi Co. 31.2
Credit 9/30/2024 Foodary 15
Checking 9/30/2024 Amoogle 1600
Credit 10/1/2024 Ground 5
Credit 10/3/2024 Ground 5
Checking 10/3/2024 ACME Pty Ltd 4000
Saving 10/3/2024 Interest 44
Credit 10/4/2024 Ground 5
Checking 10/6/2024 Estate Mgt. 900
Checking 10/6/2024 Finance Co. 150
Credit 10/6/2024 Ground 5
Credit 10/6/2024 Ground 5
Credit 10/7/2024 Ground 5
Credit 10/8/2024 Ground 5
Credit 10/8/2024 Green's 105
Checking 10/11/2024 Elec. Co. 59
Credit 10/11/2024 Ground 5
Credit 10/12/2024 Ground 5
Credit 10/13/2024 Fuel. Co 86.4
Credit 10/13/2024 Ground 5
Credit 10/14/2024 Ground 5
Credit 10/15/2024 Green's 143.9
Credit 10/15/2024 Ground 5
Credit 10/16/2024 Ground 5
Credit 10/16/2024 Event Cinemas 48.8
Credit 10/16/2024 Fashionistas 106.7
Credit 10/16/2024 Joe's Grill 61.1
Credit 10/17/2024 Taxi Co. 37.2
Checking 10/18/2024 Muscle Beach 30
Credit 10/18/2024 Ground 5
Credit 10/19/2024 Ground 5
Checking 10/19/2024 Village Medical 75
Checking 10/19/2024 Phone Co. 40
Credit 10/20/2024 Sam's Gifts 54.1
Credit 10/20/2024 Streaming Co. 35
Credit 10/20/2024 Ground 5
Credit 10/21/2024 Ground 5
Credit 10/22/2024 Ground 5
Credit 10/22/2024 Green's 178.9
Credit 10/23/2024 Pizza Pomodoro 46.2
Credit 10/24/2024 Golden Arches 21.1
Checking 10/25/2024 Worldvision 55
Credit 10/25/2024 Fuel. Co 71.5
Credit 10/25/2024 Ground 5
Credit 10/26/2024 Ground 5
Credit 10/27/2024 Ground 5
Credit 10/28/2024 Ground 5
Credit 10/29/2024 Ground 5
Credit 10/29/2024 Green's 189
Credit 10/30/2024 Ted's Trainers 133.8
Credit 10/30/2024 Ticketek 184.4
Credit 10/31/2024 Fashionistas 154.5
Credit 10/31/2024 Taxi Co. 32.1
Credit 10/31/2024 Foodary 15
 Slicers for Tables Tutorial

supported in this version of Use the Slicers to

filter the table and
find transactions
or if the workbook was saved in more easily.

Sub-category
Salary Next Step
Interest
Coffee
Rent
MV Loan
Coffee
Coffee
Coffee
Coffee
Groceries
Gas/Electrics
Coffee
Coffee
MV Fuel
Coffee
Coffee
Groceries
Coffee
Coffee
Entertainment
Clothes
Restaurant
Taxi
Gym
Coffee
Coffee
Dentist
Phone
Gifts
Entertainment
Coffee
Coffee
Coffee
Groceries
Restaurant
Restaurant
Donation
MV Fuel
Coffee
Coffee
Coffee
Coffee
Coffee
Groceries
Clothes
Entertainment
Clothes
Taxi
Interest
Salary
Coffee
Rent
MV Loan
Coffee
Coffee
Coffee
Coffee
Groceries
Gas/Electrics
Coffee
Coffee
MV Fuel
Coffee
Coffee
Groceries
Coffee
Coffee
Entertainment
Clothes
Restaurant
Taxi
Gym
Coffee
Coffee
Phone
Gifts
Entertainment
Coffee
Coffee
Coffee
Groceries
Restaurant
Restaurant
Donation
MV Fuel
Coffee
Coffee
Coffee
Coffee
Coffee
Groceries
Clothes
Clothes
Clothes
Taxi
Salary
Interest
Coffee
Rent
MV Loan
Coffee
Coffee
Coffee
Coffee
Groceries
Gas/Electrics
Coffee
Coffee
MV Fuel
Coffee
Coffee
Groceries
Coffee
Coffee
Entertainment
Clothes
Restaurant
Taxi
Gym
Coffee
Coffee
Doctor
Phone
Gifts
Entertainment
Coffee
Coffee
Coffee
Groceries
Restaurant
Restaurant
Donation
MV Fuel
Coffee
Coffee
Coffee
Coffee
Coffee
Groceries
Clothes
Clothes
Clothes
Taxi
Restaurant
Coffee
Coffee
Dividends
Salary
Interest
Coffee
Rent
MV Loan
Coffee
Coffee
Coffee
Coffee
Groceries
Gas/Electrics
Coffee
Coffee
MV Fuel
Coffee
Coffee
Groceries
Coffee
Coffee
Entertainment
Clothes
Restaurant
Taxi
Gym
Coffee
Coffee
Phone
Gifts
Entertainment
Coffee
Coffee
Coffee
Groceries
Restaurant
Restaurant
Donation
MV Fuel
Coffee
Coffee
Coffee
Coffee
Coffee
Groceries
Clothes
Entertainment
Clothes
Taxi
Restaurant
Coffee
Coffee
Coffee
Salary
Interest
Rent
MV Loan
Coffee
Coffee
Coffee
Coffee
Groceries
Gas/Electrics
Coffee
Coffee
MV Fuel
Coffee
Coffee
Groceries
Coffee
Coffee
Entertainment
Clothes
Restaurant
Taxi
Gym
Coffee
Coffee
Doctor
Phone
Gifts
Entertainment
Coffee
Coffee
Coffee
Groceries
Restaurant
Restaurant
Donation
MV Fuel
Coffee
Coffee
Coffee
Coffee
Coffee
Groceries
Clothes
Furnishings
Clothes
Taxi
Restaurant
Coffee
Coffee
Salary
Interest
Coffee
Rent
MV Loan
Coffee
Coffee
Coffee
Coffee
Groceries
Gas/Electrics
Coffee
Coffee
MV Fuel
Coffee
Coffee
Groceries
Coffee
Coffee
Entertainment
Clothes
Restaurant
Taxi
Gym
Coffee
Coffee
Phone
Gifts
Entertainment
Coffee
Coffee
Coffee
Groceries
Restaurant
Restaurant
Donation
MV Fuel
Coffee
Coffee
Coffee
Coffee
Coffee
Groceries
Clothes
Entertainment
Clothes
Taxi
Restaurant
Coffee
Coffee
Salary
Interest
Coffee
Rent
MV Loan
Restaurant
Coffee
Coffee
Coffee
Groceries
Gas/Electrics
Coffee
Coffee
MV Fuel
Coffee
Coffee
Groceries
Coffee
Coffee
Entertainment
Clothes
Restaurant
Taxi
Gym
Coffee
Coffee
Phone
Gifts
Entertainment
Coffee
Coffee
Coffee
Groceries
Restaurant
Restaurant
Donation
MV Fuel
Coffee
Coffee
Coffee
Coffee
Coffee
Groceries
Clothes
Furnishings
Clothes
Taxi
Restaurant
Coffee
Coffee
Salary
Interest
Coffee
Rent
MV Loan
Coffee
Coffee
Coffee
Coffee
Groceries
Gas/Electrics
Coffee
Coffee
MV Fuel
Coffee
Coffee
Groceries
Coffee
Coffee
Entertainment
Clothes
Restaurant
Taxi
Gym
Coffee
Coffee
Phone
Gifts
Entertainment
Coffee
Coffee
Coffee
Groceries
Restaurant
Restaurant
Donation
MV Fuel
Coffee
Coffee
Coffee
Coffee
Coffee
Groceries
Clothes
Entertainment
Clothes
Taxi
Restaurant
Coffee
Coffee
Salary
Interest
Coffee
Rent
MV Loan
Coffee
Coffee
Coffee
Coffee
Groceries
Gas/Electrics
Coffee
Coffee
MV Fuel
Coffee
Coffee
Groceries
Coffee
Coffee
Entertainment
Clothes
Restaurant
Taxi
Gym
Coffee
Coffee
Phone
Gifts
Entertainment
Coffee
Coffee
Coffee
Groceries
Restaurant
Restaurant
Donation
MV Fuel
Coffee
Coffee
Coffee
Coffee
Coffee
Groceries
Clothes
Clothes
Clothes
Taxi
Restaurant
Dividends
Coffee
Coffee
Salary
Interest
Coffee
Rent
MV Loan
Coffee
Coffee
Coffee
Coffee
Groceries
Gas/Electrics
Coffee
Coffee
MV Fuel
Coffee
Coffee
Groceries
Coffee
Coffee
Entertainment
Clothes
Restaurant
Taxi
Gym
Coffee
Coffee
Doctor
Phone
Gifts
Entertainment
Coffee
Coffee
Coffee
Groceries
Restaurant
Restaurant
Donation
MV Fuel
Coffee
Coffee
Coffee
Coffee
Coffee
Groceries
Clothes
Entertainment
Clothes
Taxi
Restaurant
 Budget vs Actuals $12,850
INCOME SURPLUS

Timeline: Works in Excel 2013 or higher. Do not move or resize.

Income
$60,000

$50,000

$40,000

$30,000

Budget Actual $20,000

Expenses by Category
$10,000

Grand Total
$0
2024 1 2

🏠 Living Expenses

💳 Discretionary Expenses
($40,000)
($35,000)
🚙 Transport
($30,000)
($25,000)
🍴 Dining Out
($20,000)
($15,000)
🫱 Charity ($10,000)
($5,000)
🩺 Medical $0
2024 1 2

$0 ($10,000) ($20,000) ($30,000) ($40,000)

 $12,850 $60 ($16,250) ($2,397) ($7,328)
NCOME SURPLUS ABOVE BUDGET LIVING EXPENSES DINING OUT DISCRETIONARY

Income Actual Budget

$60,000

$50,000

$40,000

$30,000

$20,000

$10,000

$0
2024 1 2 3 4 5 6 7 8 9 10 11 12 2024
Total

Expenses Actual Budget

($40,000)
($35,000)
($30,000)
($25,000)
($20,000)
($15,000)
($10,000)
($5,000)
$0
2024 1 2 3 4 5 6 7 8 9 10 11 12 2024
Total
,397) ($7,328) ($3,592) ($379) ($550)
NG OUT DISCRETIONARY TRANSPORT MEDICAL CHARITY

Dividends; Interest; $395

Actual Budget $2,950

Salary;
11 12 2024 $40,000
Total
Personal Profit & Loss Actual Budget Variance
Income
💰 Fixed $40,000 $40,000 $0
Actual Budget
📉 Variable $3,345 $3,500 ($155)
Income Total $43,345 $43,500 ($155)

Expense
🍴 Dining Out ($2,397) ($2,500) $103
🏠 Living Expenses ($16,250) ($16,500) $250
💳 Discretionary ($7,328) ($6,550) ($778)
🚙 Transport ($3,592) ($3,700) $108
🩺 Medical ($379) ($860) $481
🫱 Charity ($550) ($600) $50
Expense Total ($30,495) ($30,710) $215
11 12 2024
Total
Income Surplus/(Deficit) $12,850 $12,790 $60
 Excel Dashboard Course

Next Step
 Analysis Workings
Income Surplus/(Deficit) $12,850 INCOME SURPLUS
Actual vs Budget variance $60 ABOVE BUDGET

Expense by Category Bar Chart

This shape represents a Row Labels Actual
slicer. Slicers are supported 🩺 Medical ($379)
in Excel 2010 or later. 🫱 Charity ($550)
If the shape was modified in 🍴 Dining Out ($2,397)
an earlier version of Excel, 🚙 Transport ($3,592)
or if the workbook was 💳 Discretionary ($7,328)
saved in Excel 2003 or 🏠 Living Expenses ($16,250)
earlier, the slicer cannot be
Grand Total ($30,495)
used.
 PivotTable Course

E SURPLUS
E BUDGET

Expense by Period Column Chart

Budget Row Labels Actual Budget This shape represents a slic
($860) 2024 supported in Excel 2010 or
($600) 1 ($2,908) ($2,945)
If the shape was modified i
($2,500) 2 ($2,935) ($2,795) version of Excel, or if the w
($3,700) 3 ($3,080) ($3,675) saved in Excel 2003 or earl
($6,550) 4 ($3,068) ($3,095) cannot be used.
($16,500) 5 ($3,146) ($2,795)
($30,710) 6 ($3,036) ($2,795)
7 ($3,095) ($2,945)
8 ($2,982) ($3,595)
9 ($3,117) ($2,975)
10 ($3,129) ($3,095)
11 ($2,795)
12 ($2,795)
2024 Total ($30,495) ($36,300)
 Power Query Course

Income by Period Column Chart Income by Type Doughnut Char

s shape represents a slicer. Slicers are Row Labels Actual Budget Row Labels
ported in Excel 2010 or later. 2024 Salary
1 $4,035 $4,050 Dividends
he shape was modified in an earlier
sion of Excel, or if the workbook was 2 $4,036 $4,050 Interest
ed in Excel 2003 or earlier, the slicer 3 $5,387 $5,550
not be used. 4 $4,038 $4,050
5 $4,039 $4,050
6 $4,040 $4,050
7 $4,041 $4,050
8 $4,042 $4,050
9 $5,643 $5,550
10 $4,044 $4,050
11 $4,050
12 $5,050
2024 Total $43,345 $52,600
Type Doughnut Chart
Actual
$40,000
$2,950
$395
 Savings - Actual v Goal
Timeline: Works in Excel 2013 or higher. Do not move or resize. This shape represents a slic
Slicers are supported in Exc
2010 or later.

If the shape was modified i

earlier version of Excel, or
workbook was saved in Exc
2003 or earlier, the slicer ca
be used.
Cumulative Savings vs Goal

12

10

0
Saved #VALUE!

Input Analysis

Enter Monthly Savings Amount by Account in Table below Total Savings PivotTable
Date Account Saved Goal Data
12/1/2023 Acme Super Saver 175 200 Saved
12/1/2023 Retirement Fund 320 300 6,705
12/1/2023 Holiday Fund 200 150
1/1/2024 Acme Super Saver 300 200
1/1/2024 Retirement Fund 300 300
1/1/2024 Holiday Fund 300 150
2/1/2024 Acme Super Saver 0 200
2/1/2024 Retirement Fund 300 300
2/1/2024 Holiday Fund 100 150
3/1/2024 Acme Super Saver 400 200
3/1/2024 Retirement Fund 350 300
3/1/2024 Holiday Fund 100 150
 4/1/2024 Acme Super Saver -200 200
4/1/2024 Retirement Fund 300 300
4/1/2024 Holiday Fund 200 150
5/1/2024 Acme Super Saver 150 200
5/1/2024 Retirement Fund 300 300
5/1/2024 Holiday Fund 100 150
6/1/2024 Acme Super Saver 220 200
6/1/2024 Retirement Fund 300 300
6/1/2024 Holiday Fund 110 150
7/1/2024 Acme Super Saver 200 200
7/1/2024 Retirement Fund 300 300
7/1/2024 Holiday Fund 100 150
8/1/2024 Acme Super Saver 90 200
8/1/2024 Retirement Fund 300 300
8/1/2024 Holiday Fund 50 150
9/1/2024 Acme Super Saver 250 200
9/1/2024 Retirement Fund 300 300
9/1/2024 Holiday Fund 150 150
10/1/2024 Acme Super Saver 190 200
10/1/2024 Retirement Fund 350 300
10/1/2024 Holiday Fund 100 150
11/1/2024 Acme Super Saver 200
11/1/2024 Retirement Fund 300
11/1/2024 Holiday Fund 150
12/1/2024 Acme Super Saver 200
12/1/2024 Retirement Fund 300
12/1/2024 Holiday Fund 150
 This shape represents a slicer. Total Savings to Date
Slicers are supported in Excel
2010 or later.

If the shape was modified in an

earlier version of Excel, or if the
workbook was saved in Excel 0 2 4 6 8 10 12
2003 or earlier, the slicer cannot
be used.
Savings by Account

2,600

1,950

1,775 1,510
Account Acme Super Saver Holiday Fund

Savings PivotTable Monthly Savings PivotTable Savings by Account PivotTable

Data
Goal Saved Goal Account
8,450 #VALUE! #VALUE! Acme Super Saver
Holiday Fund
Retirement Fund
 Saved

Goal

1,950

1,510
aver Holiday Fund

Account PivotTable
Data
Saved Goal
1,775 2,600
1,510 1,950
3,420 3,900
Account Date Description Debit Credit Sub-category
Credit 11/1/2024 Ground 5 Coffee
Credit 11/3/2024 Ground 5 Coffee
Checking 11/3/2024 ACME Pty Ltd 4000 Salary
Credit 11/4/2024 Ground 5 Coffee
Checking 11/6/2024 Estate Mgt. 927 Rent
Checking 11/6/2024 Finance Co. 150 MV Loan
Credit 11/6/2024 Ground 5 Coffee
Credit 11/6/2024 Ground 5 Coffee
Credit 11/7/2024 Ground 5 Coffee
Credit 11/8/2024 Ground 5 Coffee
Credit 11/8/2024 Green's 160 Groceries
Checking 11/11/2024 Elec. Co. 49 Gas/Electrics
Credit 11/11/2024 Ground 5 Coffee
Credit 11/12/2024 Ground 5 Coffee
Credit 11/13/2024 Fuel. Co 94 MV Fuel
Credit 11/13/2024 Ground 5 Coffee
Credit 11/14/2024 Ground 5 Coffee
Credit 11/15/2024 Green's 133 Groceries
Credit 11/15/2024 Ground 5 Coffee
Credit 11/16/2024 Ground 5 Coffee
Credit 11/16/2024 Event Cinemas 36 Entertainment
Credit 11/16/2024 Fashionistas 74 Clothes
Credit 11/16/2024 Joe's Grill 72 Restaurant
Credit 11/17/2024 Taxi Co. 28 Taxi
Checking 11/18/2024 Muscle Beach 30 Gym
Credit 11/18/2024 Ground 5 Coffee
Credit 11/19/2024 Ground 5 Coffee
Checking 11/19/2024 Phone Co. 40 Phone
Credit 11/20/2024 Streaming Co. 35 Entertainment
Credit 11/20/2024 Ground 5 Coffee
Credit 11/21/2024 Ground 5 Coffee
Credit 11/22/2024 Ground 5 Coffee
Credit 11/22/2024 Green's 214 Groceries
Credit 11/23/2024 Pizza Pomodoro 59 Restaurant
Credit 11/24/2024 Golden Arches 13 Restaurant
Checking 11/25/2024 Worldvision 55 Donation
Credit 11/25/2024 Fuel. Co 69 MV Fuel
Credit 11/25/2024 Ground 5 Coffee
Credit 11/26/2024 Ground 5 Coffee
Credit 11/27/2024 Ground 5 Coffee
Credit 11/28/2024 Ground 5 Coffee
Credit 11/29/2024 Ground 5 Coffee
Credit 11/29/2024 Green's 210 Groceries
Credit 11/30/2024 Fashionistas 239
Credit 11/30/2024 Taxi Co. 40
Credit 11/30/2024 Foodary 30
This data is used to
demonstrate how the report
can be updated with the
click of one button.
More Resources
Tutorials
Excel Functions................................................................
Charting Blog Posts..........................................................
Excel Dashboard Blog Posts.............................................

Webinar Replays
Excel Dashboards & Power BI..........................................

Courses
Advanced Excel................................................................
Advanced Excel Formulas................................................
Power Query.....................................................................
PivotTable Quick Start......................................................
Xtreme PivotTables..........................................................
Power Pivot......................................................................
Excel Dashboards.............................................................
Power BI...........................................................................
Excel for Decision Making Under Uncertainty..................
Excel for Finance Professionals........................................
Excel Analysis ToolPak.....................................................
Excel for Customer Service Professionals........................
Excel for Operations Management...................................
Financial Modelling...........................................................

Support
Excel Forum.....................................................................

Follow Us or more Tips & Tutorials

https://www.myonlinetraininghub.com/excel-functions
https://www.myonlinetraininghub.com/category/excel-charts
https://www.myonlinetraininghub.com/category/excel-dashboard

https://www.myonlinetraininghub.com/excel-webinars

https://www.myonlinetraininghub.com/excel-expert-upgrade
https://www.myonlinetraininghub.com/advanced-excel-formulas-course
https://www.myonlinetraininghub.com/excel-power-query-course
https://www.myonlinetraininghub.com/excel-pivottable-course-quick-start
https://www.myonlinetraininghub.com/excel-pivottable-course
https://www.myonlinetraininghub.com/power-pivot-course
https://www.myonlinetraininghub.com/excel-dashboard-course
https://www.myonlinetraininghub.com/power-bi-course
https://www.myonlinetraininghub.com/excel-for-decision-making-course
https://www.myonlinetraininghub.com/excel-for-finance-course
https://www.myonlinetraininghub.com/excel-analysis-toolpak-course
https://www.myonlinetraininghub.com/excel-for-customer-service-professionals
https://www.myonlinetraininghub.com/excel-operations-management-course
https://www.myonlinetraininghub.com/financial-modelling-course

https://www.myonlinetraininghub.com/excel-forum