Showing posts with label excel spreadsheet. Show all posts
Showing posts with label excel spreadsheet. Show all posts

May 7, 2010

I'm Loving my new Excel Spreadsheet!

For months I've been talking about home office organization and how important it is stay on top of things, so I'm happy to say the daunting task of organizing my own office space is finally complete!

Why do I love my newest spreadsheet? Well, despite the fact it took me hours to wrap my head around the task of creating it, it was actually fun and fulfilling (how sad is that ;) Designing functional, usable spreadsheets that are immediately utilized is a trend I hope to continue. It was time well spent which as we all know when you're running your own business is key; every minute counts and every minute wasted just gets added somewhere else.

I've now got everything contained, organized and color coded in a fashion that enables me to find info on all of my blogs and my new website which is 'coming soon', social media sites, emails, usernames etc.

Here's a list of my Twitter accounts, see how they're in such a neat row ;) ...just so you know, if you follow all of them you will get some duplicate information.

Cheers to being organized and in time for the weekend!

(p.s. it's Mother's Day on Sunday)
  






craft_stamps 
crazy4costumes
tmcmarketing
central_ontario
whatwrinkles
urbabblicious

April 7, 2010

Basic MS Excel Spreadsheets Tips

At one point I was actually intimidated with the thought of having to create an Excel spreadsheet... I didn't even know what a spreadsheet was let alone how to design one! I'd been so used to the pen and paper approach using accounting ledgers and booklets for record keeping, not rows and columns that grow, shrink, move, vanish or tabulate with just one click.

Overtime however, I've managed to incorporate technology and allow spreadsheets into my world. Creating simple things like grocery lists and honey-do lists to start then branching out to incorporate business contacts, inventory and website/blogging information.

Basic Tips for Excel Spreadsheets...

- Columns run vertically; up/down
- Rows run horizontally; left/right
- Each box is called a Cell
- Wrap text to remove large white blanks across your spreadsheet
- Shade rows or columns to aide in visual organization
- Become familiar with Copy/Paste & Click/Drag
- Use the undo feature whenever necessary
- Titles and dates are important for sorting, charts and analysis
- When printing you can choose whether or not to print the grid guidelines
- Hide information when printing and when creating a file that's viewable to all
Ctrl + S to save a document; Ctrl + P to print the document...
- To add a row or column right click on the area and go to 'insert'