Do you know any of these key time savers in Excel?
This week, we are bringing you another hint and tip on Excel! We have been running a lot of Excel courses recently and a reoccurring comment that we get from attendees is about how useful the shortcuts are! So, we thought it would be helpful to give you a reminder of some of the key time savers you can use in Excel. Most of these are applicable to all versions but some which are pertinent to a particular version are mentioned.
They range from the obvious to more obscure!
- Holding the Control key and then pressing the ‘strange button’ (the button with 3 strange characters under Esc key) will show all your formulas
- Fill Copy Button (little black square in bottom right of a cell) has three uses:
- Create a data series or 1,2,3,4 or a custom list series Jan, Feb, Mar
- Copy a formula relative to the place you are copying it into
- You can also double click on to square to fill down automatically
- Evaluate Formula in Formulas Tab allows for tracing through a complex set of arithmetic operations in Excel orders of precedence
- New Quick Analysis button (Excel 2013) allows you to chart, conditionally format and total close to the action
- Charts – select Data then F11 (Creates a chart Sheet) – everyone’s all-time favourite
- Using Slicers to filter in Pivot Tables (Excel 2010 onwards only)
- Freeze panes – will hold rows and columns in place whilst scrolling
- Group Sheet Selection (using shift key) selects all sheets to negate the need for multiple copy paste
- Whenever sorting, sub totalling or filtering always have row 1 as your headers (fields) and rows 2 onwards for detail data with no blank rows or columns. Before activating the command choose an active cell in your list
- Accounting number button in middle of the Home ribbon (quicker than right click Format Cells)
We cover all these features and many more in our Excel courses which range from Basic Excel to Master Class Excel.
For more details see here.
We wish you many time saving moments in Excel!
– the team at John P Legge Computer Services Limited