Work along on this spreadsheet: »» FREE Shortcuts Cheat Sheet »» 5 Step Pivot Table Overview Part 1: The Basics »» 5 Step Pivot Table Overview Part 2 - Layouts and Styles »» No one wants to mess about

Work along on this spreadsheet: »» 5 Step Pivot Table Overview Part 1: The Basics »» FREE Shortcuts Cheat Sheet »» If you're not currently using pivot tables this video is going to transform your Excel

Work along on this spreadsheet: »» FREE Shortcuts Cheat Sheet »» If you're not currently using pivot tables this video is going to transform your Excel experience. I'm going to give you a complete overview

FREE Shortcuts Cheat Sheet »» I'm going to show you how you can produce a forecast using just Excel trend lines and charts. We'll go through all the various different types of trend lines and how you can

FREE Shortcuts Cheat Sheet »» I will talk you through all the different elements of formatting charts, with some tips and tricks along the way. We'll go from a basic default chart and end up with something

FREE Shortcuts Cheat Sheet »» I’ll show you a work around to get number formats in pivot tables to default to whatever number of decimal places you want using the ROUND formula. If you've ever had to mess

FREE Shortcuts Cheat Sheet »» The closest you'll get to an unbreakable Excel VLOOKUP formula. I'm going to give you five things you can do to a VLOOKUP formula that is going to make it completely bulletproof.

We'll be going through all aspects of dual axis charts in this video. How to add a secondary axis on an Excel chart so the numbers become more comparable, and it's easier to see how to series compared

Isn't it annoying when you're interrupted by someone pointed out your numbers don't add up, when you know it's only a rounding difference. It won't happen again if you apply the technique in this video.

I'm going to show you how you can create an excel chart in under one second……and that’s a promise. I'll show you all the elements of Excel chart design; how to add legends, titles, styles, colours, new