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




About this tutorial:

Video duration: 00:18:49
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…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

1 thought on “Excel tips and tricks | Efficiency using Quick Access Toolbar inc. VBA | Microsoft Excel Tutorial

Leave a Reply

Your email address will not be published. Required fields are marked *