Spreadsheet for Finances

#3
Basic Challenges

Learning Outcomes

  1. Personal finance management

  2. Understanding Spreadsheets

  3. Google's online Spreadsheet software

  4. Organize a real-world requirement 

  5. Learn about formulas 

Challenge Description

In this challenge, we focus on getting back control of our wallet. To achieve this, we have to make sure we track our income, expenses, and savings. This requires discipline. However, you will take an important step today to measure and analyze your financial activities from month to month.

 

We are going to create a personal finance management spreadsheet. This sheet will track your financial activity and provide customized reports based on the data available. 

We will learn about Spreadsheets by doing this activity. There are many spreadsheet applications such as Microsoft Excel and Google Sheets. We are going to use Google sheets for this challenge.

 

Please refer to the video lessons and written articles attached below in the resources section to learn more about Spreadsheets. Please note that we want you to create your own personal finance management spreadsheet. Do not use a template from the internet. 

Kindly login to your google drive and create a brand new sheet. Use the knowledge you got from the learning resources and create a spreadsheet that can track your daily expenses. Put in some real-world data. At least maintain the sheet for some days before submitting it to our review form the given upload link below. Before submitting make sure you use the link sharing option to ensure anyone can access the Spreadsheet you created by visiting the link. 

Watch this intro video to get a better understanding:

Learning Resources

Managing money and personal finances are very important for any person. You can learn on this subject through following links

Below links can be used to learn how to effectively use Google Sheets. Spreadsheet knowledge is very important for your career.

To Complete, follow these steps :

Go through the learning resources given above

Step 1 :

Submit the link to your presentation

Click Here

Step 2 :

Answer the questions 

Click Here

Step 3 :

© 2019 An initiative by SLASSCOM