Close

Excel and Budgeting

Bud_1314Well, Visitor, I thought we'd take a peak at Excel and what it can do for you. As always, whatever we do in Excel can easily be copied and done in Google Spreadsheets (the formulas and charts functions are available there as well).

So, let's begin with a simple task... Calculating a loan amount and repayment.

Open up Microsoft Excel and download this document.

Please watch and follow the lesson.

When you finished watching the lesson, please input your own possible loan and timeline data into the formula.

Have Ms. Kermode verify that your formulas are working properly - and then take a screenshot to post to your blog.

 

 

This quest will keep growing but before we deep dive into this... Please be sure that your blog is up-to-date with your posted work.

BE SURE TO REVIEW YOUR BLOG, YOUR GOOGLE DRIVE, AND OTHER PROJECTS THAT MAY BE LINGERING IN YOUR HARD DRIVE/HOME DRIVE, prior to continuing on.

Let's review formulas by completing this task. Please go ahead and open up the Excel document that we are working on in this quest. Watch the video and post the results to your blog.

The final parts of this quest involve formulas and making charts.
Please download this word document and open it in Microsoft Word before proceeding.

Now that you have both the Word and Excel documents open, watch this video to find out how to make and use dynamic charts.

When you have posted the correct screenshot to your blog, you may hit mastery.

One more step and you're done!

This final video shows how to use conditionally formatting so you may visually see your data while working with it.

Make sure to post your final outcome to your blog.

Skip to toolbar