Microsoft Excel - Managing Personal Finances with Excel

Download Now


Files Included :

1 Checking out the Completed Excel Personal Finance Workbook.mp4 (146.02 MB)
MP4
2 Course Exercise Files (DOWNLOAD HERE).mp4 (21.49 MB)
MP4
3 Post to the Course QA.mp4 (32.13 MB)
MP4
1 Initial Course Exercise File.mp4 (61.51 MB)
MP4
10 Naming the Bills Table.mp4 (37.93 MB)
MP4
11 EXERCISE - Creating the Expenses and Subscriptions Tables.mp4 (39.99 MB)
MP4
12 Creating the Excel Expense Tracking Table.mp4 (96.47 MB)
MP4
13 Excel Data Validation Drop Down Menu for Data Entry - Part 01.mp4 (179.72 MB)
MP4
14 Excel Data Validation Drop Down Menu for Data Entry - Part 02.mp4 (95.41 MB)
MP4
15 Creating a Dynamic Data Validation Menu with Excels OFFSET() Function.mp4 (182.31 MB)
MP4
16 Data Validation List Alternative (PivotTable).mp4 (143.9 MB)
MP4
17 Adding Expense Records to the Expense Tracker Table.mp4 (50.18 MB)
MP4
2 Monthly Budget Excel Table Setup - (Bills, Expenses, Subs, etc ).mp4 (68.13 MB)
MP4
3 Formatting Excel Tables.mp4 (61.08 MB)
MP4
4 Creating Table Headers with Merged Cells.mp4 (51.4 MB)
MP4
5 Adding Borders to the Table Headers.mp4 (52.79 MB)
MP4
6 Inputting Monthly Expense Records.mp4 (56.81 MB)
MP4
7 Apply Table Data Formatting.mp4 (62.11 MB)
MP4
8 Removing Table Filters.mp4 (41.99 MB)
MP4
9 Microsoft Excel Table Total Row Feature.mp4 (45.3 MB)
MP4
1 Creating an Actual Spent Formula with Excels SUMIF() Function.mp4 (110.43 MB)
MP4
2 Budget vs Actual Amount Formula.mp4 (33.23 MB)
MP4
3 Summarize Personal Expense with Microsoft Excel PivotTables.mp4 (70.07 MB)
MP4
4 Creating an Overall Percentage of Expenses.mp4 (46.39 MB)
MP4
5 Moving an Excel PivotTable.mp4 (29.87 MB)
MP4
6 Formatting Excel PivotTables.mp4 (97.84 MB)
MP4
1 Visually Display Summary Data with Excel Pie Chart.mp4 (41.77 MB)
MP4
2 Display Budget vs Actual Data with a Custom Column Chart.mp4 (130.38 MB)
MP4
3 Spending Overview by Category.mp4 (76.35 MB)
MP4
4 Formatting Excel Charts.mp4 (125.47 MB)
MP4
1 Introduction to Creating Calculated Callouts.mp4 (73.77 MB)
MP4
2 Creating an Income Table.mp4 (62.4 MB)
MP4
3 Total Income Callout.mp4 (89.19 MB)
MP4
4 Wrap Text in the Callout with the CHAR Function.mp4 (37.74 MB)
MP4
5 Format the Callout with TEXT() Function.mp4 (89.09 MB)
MP4
6 Total Expenses Callout.mp4 (69.51 MB)
MP4
7 Income Left to Spend Callout.mp4 (78.22 MB)
MP4
1 Highlight Expense Records based on a Condition with Excel Conditional Formatting.mp4 (79.28 MB)
MP4
2 Modifying the Theme of the Expense Tracker.mp4 (54.69 MB)
MP4
3 Hide Unwanted Excel Worksheet Columns.mp4 (29.57 MB)
MP4
4 Saving the File as a Template.mp4 (208.71 MB)
MP4
1 Calculating Monthly Loan Payments with Excels PMT() Function.mp4 (136.97 MB)
MP4
2 Calculating Future Investment Values with Excels FV() Function.mp4 (196.82 MB)
MP4
3 Creating Payment and Investment Scenarios with Data Tables.mp4 (228.49 MB)
MP4
1 Completed Course Excel File (DOWNLOAD).mp4 (14.94 MB)
MP4