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'
No comments:
Post a Comment