Productive Quick Access Toolbar in Excel - What's on my Excel QAT? You'll Probably be Surprised

Share
Leila Gharani
Published at : 01 Jan 2022
43615 views
1483

In this video I'll share the items I have on my Quick Access Toolbar (or QAT) in Microsoft Excel. The purpose of the QAT is to help you to be more productive and to find stuff easier. It's to boost your productivity in Excel and Office apps by adding shortcuts to Excel features you use most. You can add almost any Excel command to the QAT toolbar that is always visible - no matter which ribbon tab is selected. There are also some hidden and useful buttons to add to your QAT that you don't find in the Excel Ribbon. I'll share what I have on my QAT in this video. I'll also show you the new look of the quick access toolbar in Excel for Windows 11 and how you can customize it to match your needs.

๐ŸŒ My Online Excel Courses โ–บ https://www.xelplus.com/courses/

00:00 How to Customize the Quick Access Toolbar in Excel
00:54 The New Office Quick Access Toolbar
01:47 How to Customize the Quick Access Toolbar in Excel
03:07 Leila's QAT: Print Preview Full Screen
04:13: Leila's QAT: Spelling
04:51 Leila's QAT: Power Query & Data Model
05:48 Leila's QAT: Paste Values
06:20 Leila's QAT: $ Sign
07:30 Leila's QAT: Collapse/Show Ribbon
07:47 Leila's QAT: Camera
08:29 Leila's QAT: Calculator
09:18 How to Add Leila's Items to QAT
12:06 Wrap Up

๐ŸŽฌ LINK to Excel Basics Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0

๐ŸŽ’ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

๐ŸŽ“ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

๐Ÿ“š Excel RESOURCES I Recommend: https://www.xelplus.com/resources/

๐ŸŽฅ GEAR I use: https://www.xelplus.com/resources/#gear

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Letโ€™s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel
XelplusVisLeila GharaniAdvanced Excel tricks

MOTIVATION Interview Questions & Answers! (How to ANSWER these DIFFICULT Interview Questions!)

MOTIVATION Interview Questions & Answers! (How to ANSWER these DIFFICULT Interview Questions!)

LILIโ€™s FILM -  โ€˜MONEYโ€™ Dance Performance (Christmas Ver.) FOR BLINKS

LILIโ€™s FILM - โ€˜MONEYโ€™ Dance Performance (Christmas Ver.) FOR BLINKS

Repeatedly (๋˜ํ’€์ด)

Repeatedly (๋˜ํ’€์ด)

Dozen ACC staff suspended after being caught mocking injured New Zealanders

Dozen ACC staff suspended after being caught mocking injured New Zealanders

639Hz | SEED of LIFE | Attract Love, Abundance, Miracles

639Hz | SEED of LIFE | Attract Love, Abundance, Miracles

"They Come"

"They Come"

cette affaire non rรฉsolue mโ€™a rendu fou

cette affaire non rรฉsolue mโ€™a rendu fou

3 Ways I Manage Depression (not therapy or meds)

3 Ways I Manage Depression (not therapy or meds)

Lance Stephenson Erupts For 30 Points | NBA Fantasy Basketball Game Recaps | Wednesday Jaunary 5

Lance Stephenson Erupts For 30 Points | NBA Fantasy Basketball Game Recaps | Wednesday Jaunary 5

How To Be More Organized in 2022 | 13 Habits Of Organized People

How To Be More Organized in 2022 | 13 Habits Of Organized People

ROBBING Logan's SML STORE!! (And EXCLUSIVE TOUR)

ROBBING Logan's SML STORE!! (And EXCLUSIVE TOUR)

She Has Time Limits For Escalating?

She Has Time Limits For Escalating?

How to Shoot AMAZING Video for Beginners! 10 Easy Tips (Canon EOS R Tutorial)

How to Shoot AMAZING Video for Beginners! 10 Easy Tips (Canon EOS R Tutorial)

10 Scariest Crocodile Attacks Caught On Camera

10 Scariest Crocodile Attacks Caught On Camera

EXTREME DINING ROOM MAKEOVER | DIY Built Ins + Desk

EXTREME DINING ROOM MAKEOVER | DIY Built Ins + Desk

Wiskunde lessen

Wiskunde lessen

Dio Sings Stand Proud for 1 Hour

Dio Sings Stand Proud for 1 Hour

MAKING A CONTRACT WITH MYSELF by RC Blakes

MAKING A CONTRACT WITH MYSELF by RC Blakes

GRAND DADDY ECOBOOST PT 4 IT LIVES!

GRAND DADDY ECOBOOST PT 4 IT LIVES!

She is not aware about that I m doing her video she is waiting for someone to go out home

She is not aware about that I m doing her video she is waiting for someone to go out home

Breaking News: You Should Still be Very Afraid #shorts

Breaking News: You Should Still be Very Afraid #shorts

A Crucial Events Is About To Occur

A Crucial Events Is About To Occur

Going for the WIN WORLD RECORD! Winning in Solos! (Fortnite Chapter 3)

Going for the WIN WORLD RECORD! Winning in Solos! (Fortnite Chapter 3)

More regulation will benefit Big Tech players in the long-term: Stifel's Brian Gardner

More regulation will benefit Big Tech players in the long-term: Stifel's Brian Gardner

Payment in due course

Payment in due course

Traffic Explosion Method: Get 300K Visitors To Your Website

Traffic Explosion Method: Get 300K Visitors To Your Website

The AMERICAN BISON and What You Need To KNOW

The AMERICAN BISON and What You Need To KNOW

The Different Types of Overcoats

The Different Types of Overcoats

T&C Garments Factory Egypt (Levi's)

T&C Garments Factory Egypt (Levi's)

Whitechurch Carol Service 2021

Whitechurch Carol Service 2021

Best Printer For Infrequent Use in 2021 [Top 5 Picks Reviewed]

Best Printer For Infrequent Use in 2021 [Top 5 Picks Reviewed]

Testing Tornado Hacks To See If They Work in Minecraft

Testing Tornado Hacks To See If They Work in Minecraft

The Perfect Wood Recycling Project // How To Use Old Wood To Create The Most Perfect Art Furniture

The Perfect Wood Recycling Project // How To Use Old Wood To Create The Most Perfect Art Furniture

Torpid POV Apo 1v1 gameplay (Dawn of war 2 Retribution Elite Mod 2.9.4)

Torpid POV Apo 1v1 gameplay (Dawn of war 2 Retribution Elite Mod 2.9.4)

Regimes Do Fall - Part Of The Problem #808

Regimes Do Fall - Part Of The Problem #808

Are they curious about you? - Pick a Card Reading

Are they curious about you? - Pick a Card Reading

INCONSEQUENCE #24 / ETZER, JUNIE, DOROTIE, MICHEL, MARJORIE, GAETAN

INCONSEQUENCE #24 / ETZER, JUNIE, DOROTIE, MICHEL, MARJORIE, GAETAN

Iran's Swarm Fleet & Russia/China Pact

Iran's Swarm Fleet & Russia/China Pact

Usher - Good Kisser (Official Audio)

Usher - Good Kisser (Official Audio)

๐‚๐ข๐œ๐š ๐š ๐ฆ๐ข๐ซ๐š๐œ๐ฎ๐ฅ๐จ๐ฎ๐ฌ ๐Š๐จ๐ซ๐ž๐š๐ง ๐ˆ๐ง๐ ๐ซ๐ž๐๐ข๐ž๐ง๐ญ ๐ญ๐ก๐š๐ญ ๐๐ซ๐ž๐ฏ๐ž๐ง๐ญ๐ฌ

๐‚๐ข๐œ๐š ๐š ๐ฆ๐ข๐ซ๐š๐œ๐ฎ๐ฅ๐จ๐ฎ๐ฌ ๐Š๐จ๐ซ๐ž๐š๐ง ๐ˆ๐ง๐ ๐ซ๐ž๐๐ข๐ž๐ง๐ญ ๐ญ๐ก๐š๐ญ ๐๐ซ๐ž๐ฏ๐ž๐ง๐ญ๐ฌ

Holy Rosary - Joyful Mysteries - Monday & Saturday

Holy Rosary - Joyful Mysteries - Monday & Saturday

Ye Meri Zindagi ๐Ÿ˜ญHeart Touching Love Story ๐Ÿ˜ฐ Children Sad Love Story ๐Ÿ’“New Hindi Song 2021๐ŸŽถLovevBook

Ye Meri Zindagi ๐Ÿ˜ญHeart Touching Love Story ๐Ÿ˜ฐ Children Sad Love Story ๐Ÿ’“New Hindi Song 2021๐ŸŽถLovevBook

How to Locate and Search for a Medication Using the Formulary Look-Up Tool

How to Locate and Search for a Medication Using the Formulary Look-Up Tool

In A Few

In A Few

Surah Rahman 5 times for cure illness

Surah Rahman 5 times for cure illness

SISSELยฎ Spinefit - The innovative fitness tool with an intensive feel-good effect!

SISSELยฎ Spinefit - The innovative fitness tool with an intensive feel-good effect!

The Annoying Orange - Dead END!! #SHOCKTOBER

The Annoying Orange - Dead END!! #SHOCKTOBER

Let Us Adore You - Reprise (Steven Universe) ใ€covered by Annaใ€‘

Let Us Adore You - Reprise (Steven Universe) ใ€covered by Annaใ€‘

Following a John Beckley tutorial with a few changes!! (SAtSfyIng)

Following a John Beckley tutorial with a few changes!! (SAtSfyIng)