Spreadsheets For Dummies

[simpleaffiliate source="chitika" results="0"][/simpleaffiliate]

excel and yearly income report?

i have to make a spreadsheet for a business for my excel class and i chose to do a yearly income for best buy. my first assignment is just creating rows and columns and finding 3 different formulas that i will be using, and entering in dummy data for now.

but so far my mind is blank on this task that i know is very easy. can someone help me get started (not asking for someone to do my assignment for me) just need a few ideas to get my mind going,

you picked best buy.
thats a public company...so
- i would go to bestbuy.com and look for investor relations link.
best buy is in sales...so the investor link might be harder to find. (there should be a sitemap)
you might have to look at the very bottom or very top of the webpage for a small hard to find button.

- once you are there, you should be able to find annual reports with income statements included.

- then back in excel, make your income statements look like best buys...basically just start typing and formatting.
- i would guess along the top row would be years or months'
- along the 1st column would be sales and expenses and stuff
- maybe add some rows with easy to read titles
- some formulas would be sum() and average() annual sales. not much you can do with an income statement.

hope that helps.

maybe if you goto microsoft.com and look at some pre-made excel templates you will get more ideas.

Microsoft Excel Tutorial for Beginners #1 - Overview


[simpleaffiliate source="amazon" results="10"]spreadsheets for dummies[/simpleaffiliate]
[simpleaffiliate source="cj" results="10"]spreadsheets for dummies[/simpleaffiliate]
[simpleaffiliate source="clickbank" results="10"]spreadsheets for dummies[/simpleaffiliate]