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!

  1. 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
  2. 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
  3. Hold Control then press Strange button (the button with 3 strange characters under Esc key) will show all your formulas in your worksheet
  4. Select all of your Data then press the F11 key (Create a chart Sheet) – everyone’s all-time favourite
  5. Using Slicers to filter in Pivot Tables (Excel 2010, 2013 only)
  6. Group Sheet Selection (using shift key) selects all sheets to negate the need for multiple copy paste
  7. Accounting number button in middle oh Home ribbon (quicker than right click Format Cells)
  8. Freeze panes – will hold rows and columns in place whilst scrolling
  9. New Quick Analysis button (Excel 2013) allows you to chart, conditionally format, total close to the action.
  10. 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!

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We have placed cookies on your device to help make this website better.

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy