1 CPE 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: January 23, 2023
33 Reviews (110 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!
Vickie Cockrum
(Mgr, Accounting/Reporting, Internal Repo.. at Charter Communications)
I learned a couple new items, but towards the end the instructor just kept saying the same thing over & over about the alt key. Then you get to the exam & the questions don't really follow the material.
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.
Anonymous
(Accounting Professional)
A little repetitious if you listen straight through, but I learned a couple of new things and I thought I was pretty good with the quick access toolbar.
Anonymous
(Card Program Administrator)
Presented in a very learn friendly manner. Very beneficial to know how to save time working on a spredsheet. Quick Access Tool bar saves time.
Anonymous
()
I knew about the quick access bar, but not so much the alt keys. I'll be adding more to the quick access bar as I use excel at work.
Vickie Jackson
(Accounting Manager at NewStar Sourcing and Service)
Excellent course. I learned several things I didn't know and look forward to adding the shortcuts to the Quick Access Toolbar.
Anonymous
(Accounting Manager)
I liked learning how to customize the quick access tool bar. It will definitely save time when working on a spreadsheet.
Anonymous
(Senior Accountant)
David Ringstrom does a great job, as always. The course is well laid out and packed with lots of good information.
Ted Feher
(Owner at Feher, PC (CPA))
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
()
Good and quick course regarding a little used feature. I plan to implement on my spreadsheet.
Anonymous
(Bookkeeper)
Good course with lots of great tips. The slides were a little tricky to follow however.
Richard Thompson
(Senior Accountant at Charter Communications)
Good information for creating shortcuts. Information on Print Preview especially helpful
Anonymous
(Independent Financial Consultant)
This course provided many tips to help make me work more efficiently in Excel. Thanks!
Anonymous
()
Lots of valuable tips and tricks - will save me a bunch of time doing repetitive tasks.
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.
Anonymous
(Staff Auditor 1)
its was ok, some of it was tedious and hard to follow along with
Rahman Ullah
(Senior Accountant at Cardtronics)
Pretty nice overview. Can be useful to anyone using excel.
JOSH Aharonoff
( at Graphite Financial)
Useful tips for accessing the toolbar - thanks for the help!
Anonymous
(Senior Financial Analyst)
The test was not as straight forward as you would assume.
Chris Grimes
(Rules Master at Cisco)
Good tips for hidden and useful features in Excel.
Matt Osmundsen
(Category Finance Director at Energizer Holdings, Inc.)
Great course! Very informative and helpful.
Robert Workman
(Senior Lean Development Officer at Confidential)
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
.
David RingstromCPA, author, Microsoft Excel trainer and consultant
About Illumeo
Platform
Resources
Contact Us
- Email: info@illumeo.com
- Phone: 408-400-3993
- Adress: 75 East Santa Clara St.
- Suite 1215, San Jose, CA 95113
© 2023 Illumeo, Inc.