More Excel Speed Tips (Completed)

Date: Tuesday, April 25, 2017
Instructor: David H. Ringstrom
Begin Time:  12:00pm Pacific Time
1:00pm Mountain Time
2:00pm Central Time
3:00pm Eastern Time
CPE Credit:  2 hours for CPAs

Thanks to the success of our popular Excel Speed Tips presentation, Excel expert and CPA David H. Ringstrom developed this follow-up session packed with even more ways to save time and effort in Excel.

You’ll learn shortcuts that allow you to streamline repetitive tasks and redundant data entry, close all open documents at once by clearing the decks in Excel, paste data and column widths simultaneously, and strike through list items with a custom shortcut. In addition, David explains the benefits associated with Excel’s Text Box feature, the nuances between Enter and Edit modes, and much more.

David demonstrates techniques by using the version of Excel in use by the majority of attendees for this presentation. Typically, this means he teaches from Excel 2010 or 2013, but his handouts identify differences in Excel 2007, 2010, 2013, and 2016 when needed. His webcasts are fast-paced, and attendees often are surprised at the amount of ground he covers in a session. He welcomes participants’ questions, so come ready to pick his brain. David’s detailed handouts, with numbered steps, serve as reference material you can utilize going forward. He also provides an Excel workbook that includes a majority of the examples he uses to demonstrate techniques during the presentation.

Who Should Attend
Practitioners who may benefit from using Excel more effectively.

Topics Covered

  • Avoid frustration by understanding the nuances between Enter and Edit modes
  • Avoid merging cells—use the Text Box feature for paragraphs of text instead
  • Create a keyboard shortcut for simultaneously pasting data and column widths
  • Create a shortcut to allow you to clear the decks in Excel by closing all open documents at once
  • Discover how to quickly access folders and workbooks, regardless of whether they're stored on your computer or on a network
  • Learn the right and wrong ways to make Excel appear on two or more monitors
  • Learn what steps to take if you can't open a damaged workbook
  • Master the nuances—and the power—of Excel's Transpose feature
  • Overcome user interface annoyances by making simple adjustments to Excel's options.
  • Simplify repetitive tasks by creating your own keyboard shortcuts
  • Streamline redundant data entry with a handy keyboard shortcut
  • Strike through list items with a custom shortcut

Learning Objectives

  • Apply the mouse action that reveals a hidden menu for moving columns/rows
  • Describe what steps to take if you can't open a damaged workbook
  • Recognize and apply how to avoid merging cells

Level
Intermediate

Format
Live webcast

Instructional Method
Group: Internet-based

NASBA Field of Study
Computer Software & Applications (2 hours)

Program Prerequisites
A basic of understanding of Excel.

Advance Preparation
None

View More Live Webcasts