Smart keys in MS-Excel
Here are a couple of short cuts that you may not have used in Excel before:
<F5> – Goto
<F12> – Save as
<Ctrl + Shift + $> – this will apply Currency Formatting
<Ctrl + Shift + %> – this will apply Percentage Formatting
<Ctrl + 0> – Hide a column
<Ctrl + 9> – Hide a row
How do you file?
Does your data filing system = your email filing system which should = your paper-based filing system?
Why would you have 3 different filing systems that you need to organise and remember how you filed things? Spend sometimes considering the SPACE formula to get your filing systems synchronised.
• Sorting: It is critical that you handle everything. Pick it up and ask yourself: Do I use this? Does this make or cost me money? What category does this belong in? The idea here is to group similar items together
• Purging: Here is where you decide what stuff to get rid of, and how (toss it, give it away, sell it, or put it somewhere else).
• Assigning each item a home: It is important not to be vague and indecisive about where to put items. Consider accessibility, safety, and the zone and sequence it is to be used in.
• Containerise: Container make it easy to keep your categories of items grouped and separated within their assigned zones so that retrieval, cleanup and maintenance is a breeze.
• Equalise: After 2 weeks Julie recommends making an appointment with yourself to evaluate how well your system has been working. “Is everything as easy as you’d like it to be? Are you following your system?”
From “Organizing from the Inside Out” by Julie Morgenstern (isbn: O-7336-1350-O)