Instructor for this course
more

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.

18 Reviews (64 ratings)Reviews

5
Anonymous Author
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!
4
Anonymous Author
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.
5
Anonymous Author
The lesson included many shortcuts I'll be able to incorporate daily and the examples were very helpful.
5
Member's Profile
the varying commands, some i didnt knnow about. Too many refernces to how to attach to toolbar
5
Member's Profile
As a long time.excel user, I was supposed surprised at the number of good tips in this course.
Anonymous Author
Good course with lots of great tips. The slides were a little tricky to follow however.
5
Anonymous Author
This course provided many tips to help make me work more efficiently in Excel. Thanks!
4
Anonymous Author
The videos have too much screenshots that make my eyes confused where to look at to.
5
Anonymous Author
I already use the QAT but I still learned lots of new things. Excellent course.
5
Member's Profile
Very useful excel information. Some tips to really help improve efficiency.
5
Member's Profile
Great information on quick access toolbars. I would recommend this course.
5
Member's Profile
Good tips for hidden and useful features in Excel.
5
Member's Profile
Great course! Very informative and helpful.
4
Member's Profile
Good course, nice tips to learn & practice
5
Member's Profile
Good Course
5
Anonymous Author
Time-saver!
4
Member's Profile
Good tips.
5
Member's Profile
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 .
Course Syllabus
INTRODUCTION AND OVERVIEW
Quick Access Toolbar
  7:46Undo; Email Shortcut; Center Text
  6:28Classic Print Preview; Print Scale; Text to Speech
  10:03Filtering; Form Command
  5:55Freeze Panes; Paste Values
  8:16Strikethrough; Lock Cells
CONCLUSION
  1:00Closing Remarks
Continuous Play
  43:06Excel Efficiency: Quick Access Toolbar
SUPPORTING MATERIALS
  xlsxExcel Efficiency Quick Access Toolbar-Excel 2007-2013
  PDFSlides: Excel Efficiency: Quick Access Toolbar
  PDFExcel Efficiency: Quick Access Toolbar Glossary/Index
REVIEW & TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM