08 6210 8500
Do not pass Go To F5 Function key By Neale Blackwood Pressing F5 or Ctrl + g opens the Go To dialog. Using the Go To feature has a number of advantages. The first is you can press F5 followed by Enter to return after following a hyperlink. This also works if you have [...]
Rounding via formats Custom formats By Jeff Robson When you're doing your budgets or annual reports, you often need to switch easily between dollars and cents, whole dollars, and thousands. Switching between dollars and cents, and whole dollars is easy: just use Excel's built in formats (either the "$" or "," buttons) and increase [...]
Copying visible cells only Visible cells only By Neale Blackwood If you copy a range that has hidden rows or hidden columns and then paste it, you will find that Excel pastes even the hidden values. To paste only the visible cells you need to select the visible cells before you copy. Select the [...]
Full Screen See more of the sheet grid By Neale Blackwood Sometimes you want the Excel sheet grid to fill as much of the screen as possible. To do that you can use Excel’s full screen option. Excel 2007 – in the View Ribbon click Full Screen button in the Workbook View section. Press [...]
SUM shortcut Alt key shortcut By Neale Blackwood Keyboard shortcut for the SUM function. If you prefer to use keyboard shortcuts to the mouse, then you can use a keyboard shortcut to mimic clicking the AutoSum toolbar icon. This can be helpful if you are on a laptop with an external mouse. To insert [...]
Auto Outline Automated grouping By Neale Blackwood If you use the Group feature frequently in your sheets, then consider using the Auto Outline feature. This automatically adds the Grouping buttons based on the SUM and SUBTOTAL formulas in your sheet. Its effectiveness depends on the structure of your report. The better structured the report [...]
Grouping shortcut Keyboard shortcut to group and ungroup By Neale Blackwood If you frequently hide and unhide certain columns or rows then its time to consider using Excel's Group feature. The Group option is on the Data Menu or Ribbon depending on your version, but there is a keyboard shortcut that makes it easy [...]
Going Backwards One Really Simple way to Trace Formulas Backwards By Jeff Robson Sometimes it's the simple things in life that are often the best. Well, here's a really simple thing that can make your life as a formula tracker a LOT easier. If you want to trace a formula back and go to [...]
Free Download: Festival Event Planner By Jeff Robson This handy planner lets you create your wishlist of events in one sheet, organise based on priority and date, labels events as MAYBE or BOOKED and block out days of unavailability. Share with friends and family so they can see what you plan to [...]
The Top 10 ways CFOs can do more with less – Part 1 By Jeff Robson Travelling around to different businesses, it seems that everyone is under pressure to reduce costs and improve productivity. But how do you do this when everyone is already working really hard? They’re already too busy just getting all [...]
How to Make your Excel Models Faster Improving Calculation Performance By Jeff Robson Do you have a large model that you'd like to speed up? Here are some things you can do to improve performance. 1. Replace, Remove or Minimise Volatile Functions Volatile functions must be re-calculated every single time anything changes if your [...]
The Top 10 ways CFOs can do more with less – Part 2 By Jeff Robson This article continues on from Part 1 Travelling around to different businesses, it seems that everyone is under pressure to reduce costs and improve productivity. But how do you do this when everyone is already working really [...]
Pay my invoice