★ GET THE EXAMPLE FILE ★
Sign up for our free Insiders program and get the example file:
https://exceloffthegrid.com/insiders-signup/
File Reference for this video: 0338 Top 10 Tips & Tricks

★ JOIN THE FREE COURSE ★
Want to get the free Modern Excel Reporting course? Click here:
https://exceloffthegrid.com/modern-excel-reporting/

★ ABOUT THE VIDEO ★
As part of our 10th Anniversary celebrations at Excel Off The Grid, I thought it would be the perfect time to share 10 of my favourite Excel tips and tricks.

Some are hidden features I’ve used for years.

Some are simple techniques that can save a surprising amount of time.

But all of them are tricks I only wish I’d discovered much earlier in my Excel journey!

0:00 Introduction
0:18 Tip 1 – Copy/paste chart format
0:59 Tip 2 – Chart properties follow data point
2:08 Tip 3 – Drag tool tip
2:45 Tip 4 – Dynamic array moving total
5:53 Tip 5 – Very hidden sheets
7:03 Tip 6 – Linked pictures
7:53 Tip 7 – White space between headings
8:29 Tip 8 – Copy sheets quickly
9:02 Tip 9 – Unpivoting in Power Query
11:47 Tip 10 – Dynamic file paths in Power Query
14:50 Wrap up

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy

★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: https://twitter.com/exceloffthegrid

#MsExcel