To Access This Course:
This course demonstrates how to access and leverage a treasure trove of hidden features in the Excel Quick Access toolbar that will help you avoid frustration and fly through repetitive tasks.
Taught by how-to Excel expert David H. Ringstrom, CPA, this course focuses on an often overlooked corner of Excel--the Quick Access Toolbar. Located just above the Office button in Excel 2007 and the File tab in Excel 2010, this default set of three little icons has the potential to transform how you use Excel.
You learn to:
- Simplify repetitive tasks by creating your own keyboard shortcuts via the Quick Access toolbar
- Restore "classic" Print Preview functionality to Excel 2007 and later
- Keep an eye on how much your text is being reduced as you try to squeeze more onto a page
- Double-check manual inputs with ease by having Excel read numbers aloud to you
- Wrangle long lists of data by filtering instead of sorting
- Add the hidden Form Command back to Excel 2007 and later
- Simplify the Alt-E-S-V keyboard shortcut many users rely on to Paste as Values
- Strike through list items with a custom shortcut
- Toggle the Locked status of a worksheet cell on or off by way of a custom shortcut
Learning Objectives
- Create a keyboard shortcut that enables you to filter lists based on the currently selected cell.
- Restore the "classic" print preview from Excel 2007 and earlier in Excel 2010 and later.
- Freeze or unfreeze worksheet panes by way of an icon and/or custom keyboard shortcut.
Last updated/reviewed: September 08, 2017
19 Reviews (67 ratings)Reviews
Anonymous
(unemployed)
It has been awhile since I have actively worked in Excel, for anyone except myself. The shortcuts are great! There is so much information and it lends to efficiency in other programs as well, it is a real eye opener!
Anonymous
(Sr. Accountant)
I have not been using the Quick Access Toolbar to it's fullest potential. I will definitely be customizing my toolbar to bring most frequently used Excel features front and center.
Ted Feher
(CFO at Turbo Drill Industires Inc)
Now that I see how easy it is to create shortcuts you better believe I will take more advantage of the feature.
Anonymous
(Manager)
The lesson included many shortcuts I'll be able to incorporate daily and the examples were very helpful.
Paul Deputy
(None at None)
the varying commands, some i didnt knnow about. Too many refernces to how to attach to toolbar
Rebecca Grimmer
(CFO at ASES)
As a long time.excel user, I was supposed surprised at the number of good tips in this course.
Anonymous
(Bookkeeper)
Good course with lots of great tips. The slides were a little tricky to follow however.
Anonymous
(Independent Financial Consultant)
This course provided many tips to help make me work more efficiently in Excel. Thanks!
Anonymous
(General Ledger Accountant)
The videos have too much screenshots that make my eyes confused where to look at to.
Anonymous
(Controller)
I already use the QAT but I still learned lots of new things. Excellent course.
Eric Cox
(Senior Accountant at Mondo)
Very useful excel information. Some tips to really help improve efficiency.
Karin Williams
(None at self)
Great information on quick access toolbars. I would recommend this course.
Chris Grimes
(Rules Master at Cisco)
Good tips for hidden and useful features in Excel.
Matt Osmundsen
(Director of Financial Planning at Baldwin Technology Company, Inc.)
Great course! Very informative and helpful.
Robert Workman
(Other at Other)
Good course, nice tips to learn & practice
Hossam Ali Elsherief
(General Accountant & senior Auditor at Authorized Policy Insurance Brokers)
Good Course
Anonymous
(-)
Time-saver!
Terri Salazar-Rodriguez
(None at None)
Good tips.
Richard Dandan
(Senior Accounting Specialist at National Food Authority)
Great!
Prerequisites
Course Complexity: Advanced
Prerequisite: Proficiency with Excel
Advanced Preparation: None
Education Provider Information
Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .