Join Aaron Quigley for an in-depth discussion in this video Tracking expenses, part of Office for Students.
When it comes to managing your finances in Microsoft Excel,…organization is an important key that'll help make you successful.…For example, here I have a very basic Excel spreadsheet.…I have on the left-hand side various categories in which I spend money.…Books, coffee, food, and rent.…That pretty much sums up my college experience.…And then along the top, I have weeks that I've spent money.…Now I could just go ahead and use one workbook sheet and…put weeks all the way out to the end of the school year.…What would happen in this situation…is I would have to scroll left every time I wanted to take a look at various weeks.…Another way to do this is to utilize different sheets for this Excel workbook.…
Here at the very bottom, I have a…sheet for November, December and January already created.…Inside of each sheet, I only have four weeks now that I'm managing.…This way I can quickly take a look at…what I spent in December versus November, versus October.…But every now and then, what if I want to see…the summation of everything that I spent in a single category…
Are you a teacher? Try our companion course, Office for Educators.
- Creating assignment templates
- Tracking changes and adding notes
- Creating bibliographies and citations
- Presenting in PowerPoint with SlideShare
- Using Excel to manage data
- Keeping school and personal email organized in Outlook
- Setting up a calendar
- Using SkyDrive to back up papers and assignments