Excel tips and tricks | Efficiency using Quick Access Toolbar inc. VBA | Microsoft Excel Tutorial

Learn how to set up your Quick Access Toolbar (QAT) effectively to become more efficient when financial modelling in Microsoft Excel. In this tips and tricks video I will show you
1) How to set it up
2) What I use and how I use them; and
3) Some personal macros that I use on my QAT

Timestamps

0:00 Intro
0:49 How to set up your QAT
3:20 Paste values
6:10 Paste formulas
6:34 Fast border formatting
8:30 Quickly increase and decrease font sizes
9:23 Easy format painting
10:18 Other shortcuts
11:10 Using VBA on your QAT
11:24 Automated graph formatting
14:12 Timestamp for recording information
15:53 VBA scripts
18:32 Learn more

[everydayexcel]

Want to put these tips and tricks to use? Watch my Dashboard series to see how you can level up your Excel outputs!

[MrNoBSgiven]

This video may be "old" in the internet terms, but it is one of the most useful one for Excel and other office products. It indeed eliminates a lot of frustrations of Excel users. Thanks.