"I need that report by..." 5 words that create panic in the work place when you have a list that's a thousand lines long, you need to summarise it and just don't know where to start. 

Chances are if you are doing lots of filtering, sorting and subtotalling on your Excel data lists, you're wasting a lot of time repeating tasks. If  you want to save yourself a stack of time, the tool to use is a Pivot Table.  This feature can be found under the Insert tab on the ribbon.

Select a populated cell in the list you want to analyse and click the Pivot Table icon. This will highlight the entire list including headers, and the Pivot Table analyses the data on a new sheet where you can manipulate that data in a variety of ways (see below).

Here's an example (you can download the file to practise yourself! or play the video tutorial at the end of this post).

Watch a short video tutorial here...

Look forward to seeing you soon,

Anita Lund
Owner and Founder of Trainers Direct Pty Ltd (Sydney)  
On Site MS Office, Excel, Word, PowerPoint, Outlook and computer training
www.trainers-direct.com.au
​& Storm Training & Solutions (UK) www.stormtraining.com  

1. Use F4 to make a cell absolute instead of typing $ when creating a formula (press F4 multiple times to make only part of the reference absolute)
2. Use Name Ranges in formulas? Press F3 to paste a name into a formula
3. To wrap text in a cell press Alt Enter e.g First Alt Enter Name would wrap First Name to display on 2 lines
4. To edit the current cell press F2
5. To jump to the top or bottom of a sheet press Ctrl Home or End
6. To select to the end of a list, position the active cell where you want to select from and press Ctrl  Shift  End
7. To view formulas on a worksheet press Ctrl and the key immediately underneath the Esc key on the keyboard
8. To insert the current date press Ctrl ;
9. To create a chart, highlight the data and corresponding column/row labels and press F11
10. To quickly copy a sheet, hold down Ctrl and drag the sheet and drop it immediately to the right

Look forward to seeing you soon,

Anita Lund
Owner and Founder of Trainers Direct Pty Ltd (Sydney)  
www.trainers-direct.com.au
​
& Storm Training & Solutions (UK) www.stormtraining.com 

Look forward to seeing you soon,

Anita Lund
Owner and Founder of Trainers Direct Pty Ltd (Sydney)  
www.trainers-direct.com.au
​
& Storm Training & Solutions (UK) www.stormtraining.com 

Look forward to seeing you soon,

Anita Lund
Owner and Founder of Trainers Direct Pty Ltd (Sydney)  
www.trainers-direct.com.au
​
& Storm Training & Solutions (UK) www.stormtraining.com 

In the first of our 2 minute tutorials we show you how to create a chart in Excel 2013 with 2 data series, and plot the second data series on a secondary axis. This is useful if you have a large variation in values. Yes, all in 2 minutes, it's that easy!

Look forward to seeing you soon,

Anita Lund
Owner and Founder of Trainers Direct Pty Ltd (Sydney)  
www.trainers-direct.com.au
​
& Storm Training & Solutions (UK) www.stormtraining.com 

Sometimes in Excel it can be hard to see what's going on, particularly if you inherit a spreadsheet from someone. How on earth did they do those calculations? Clicking on each individual cell and looking at the formula bar can be tiresome but luckily there's an easy way to unlock the formulas using a simple short cut key or a button. Watch this short video to find out how. Tell me what you think.

​We offer training courses in Sydney and the UK for all computer training apps.

Look forward to seeing you soon,

Anita Lund
Owner and Founder of Trainers Direct Pty Ltd (Sydney)  
www.trainers-direct.com.au
​
& Storm Training & Solutions (UK) www.stormtraining.com