Building a flexible spreadsheet template and formatting numbers as currency

Описание: http://courses.robobunnyattack.com/co...

Before you add any numbers to your spreadsheet, take a moment to think about how you might want to use this information in the future. This will help you build a better, more flexible spreadsheet.

In our case, we might want to have the freedom to adjust quantities and item costs, and have the spreadsheet do the calculations for us. So we'll create separate columns to contain all of this information, rather than just enter final totals.

So let's go ahead and enter the quantities and item costs for all of our expenses and income items. (Don't worry too much about accuracy — remember, this is a spreadsheet course, not a budgeting course! Go ahead and have some fun with your numbers.)

Watch the video to learn how to format individual numbers and columns of numbers to display as currency.

*****

This is a sample lesson from the online course "Step-by-step Spreadsheets for Absolute Beginners". Learn to use Microsoft Excel, LibreOffice or any other spreadsheet software program. Manage your data with confidence! Enroll today at: http://courses.robobunnyattack.com/co...

Looking for friendly, practical, jargon-free technology training? Visit my website at: http://learn.robobunnyattack.com

Thanks for watching!
Kathleen, [email protected]