Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Google Sheets Beginner to Pro: Project 1: Simple Budget
1 | Create a Simple Budget
001 | Creating your first file (6:53)
002 | Google Sheets User Interface basics (6:48)
003 | Copy the budget data into your Google Sheet (6:36)
004 | Identifying income and expense values (6:46)
005 | Making the expense data negative (8:54)
006 | Create a rolling total of profit and loss (6:02)
007 | Adding a month and year column (7:43)
008 | Formatting your budget to make it look sharp (16:17)
009 | Validating the data in your cells with Data Validation (11:49)
010 | Creating a chart to display your profits and losses over time (7:19)
011 | Creating different views of your data with filters (6:21)
Wrapping Up!
Project Stages Link
Ready for the next project?
001 | Creating your first file
NOTE!
You can open the links in the Summary PDFs in new tabs by either:
Right-click > Open link in new tab.
Ctrl + Left-click
1 _ Budget - 001 _ Creating your First Google Sheet.pdf
Complete and Continue
Discussion
0
comments
Load more
0 comments