More Excel Speed Tips (Completed)

Date: Wednesday, June 20, 2018
Instructor: David H. Ringstrom
Begin Time:  9:00am Pacific Time
10:00am Mountain Time
11:00am Central Time
12:00pm Eastern Time
CPE Credit:  2 hours for CPAs

Excel expert and CPA David H. Ringstrom developed this follow-up session to Excel Speed Tips that’s 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, embed lists you use frequently, transform filtering tasks, and more. In addition, David explains the benefits associated with Excel’s Text Box feature, the Personal Macro Workbook, and the Quick Analysis feature.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Who Should Attend
Practitioners who can benefit by learning a variety of techniques and shortcuts that will speed up their work in Excel.

Topics Covered

  • How the Table feature allows you to transform filtering tasks
  • Avoid repetitive work by creating a keyboard shortcut for Excel's Freeze Panes feature
  • Embed frequently used lists, such as employees, departments, or key customers, into Excel's interface for use with any spreadsheet
  • Add the hidden Form Command back to Excel 2007 and later
  • Double-checking manual inputs easily by having Excel read numbers aloud to you
  • Dispatch the Compatibility Checker to avoid wasting time when saving workbooks as .XLS files by dispatching the Compatibility Checker
  • Jump-start data visualization with the Quick Analysis feature
  • Strike through list items with a custom shortcut
  • Discover how to use Excel's Personal Macro Workbook.
  • Use the Text Box feature for paragraphs of text to avoid merging cells
  • Keepan eye on how much your text is being reduced as you try to squeeze more on a page

Learning Objectives

  • Identify the feature that helps you transform filtering tasks
  • Implement Excel's Personal Macro Workbook
  • Define how to avoid merging cells
  • Recall how to embed frequently used lists

Level
Intermediate

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

">
 Chat — Books Support