Excel Time Saving Tips – Ten for you to look at from JPL
We always receive great feedback on short cuts we cover in all of our Microsoft Office courses.
So we thought it would be helpful to remind you of some of the key “time savers” 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!
- Fill Copy Button (little black square in bottom right of a cell) has two main purposes.
- 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
- Whenever sorting, subtotaling 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
- Hold Control then press Strange button (the button with 3 strange characters under Esc key) will show all your formulas in your worksheet
- Select all of your Data then press the F11 key (Create a chart Sheet) – everyone’s all-time favourite
- Using Slicers to filter in Pivot Tables (Excel 2010, 2013 only)
- Group Sheet Selection (using shift key) selects all sheets to negate the need for multiple copy paste
- Accounting number button in middle oh Home ribbon (quicker than right click Format Cells)
- Freeze panes – will hold rows and columns in place whilst scrolling
- New Quick Analysis button (Excel 2013) allows you to chart, conditionally format, total close to the action.
- Evaluate Formula in Formulas Tab allows for tracing through a complex set of arithmetic operations in Excel orders of precedence.
We cover all these features and many more in our Excel courses which range from Basic Excel to Master Class Excel.
Full details are on https://www.jplcomputer.co.uk/microsoft-excel-training.html
Want to learn more Excel time saving tips? Get in touch!