Instructor for this course
more

In this course Excel instructor David H. Ringstrom, CPA, shines a light on some forgotten, but not lost, features of Excel. David helps you resurrect features that you may have thought were gone from Excel, or in other cases confirms your suspicions.

You'll also see how many users inadvertently transform even the latest version of Excel into a zombie state with disabled features by using an obsolete worksheet format. You'll also see how to avoid incorporating features that will work in Office 365 but that will turn into zombies in any other version of Excel.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2019. He draws your attention to any differences in Excel 2016, 2013, or 2010 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 will benefit from using Excel more effectively and efficiently.

Learning Objectives

  • Explore by learning the benefits and risks of sharing workbooks via OneDrive in Office 365.
  • Explore converting .XLS files compatible with Excel 2003 into the modern Excel workbook format.
  • Identify restoring Full Screen View in Excel 2013 and later as well as enabling a keyboard shortcut for this feature.
  • Identify overcoming user interface annoyances by making simple adjustments to Excel’s options.
  • Recognize utilizing the Split Worksheet feature properly to lock certain rows at the bottom of the Excel window.
  • Identify Excel 2003 charting features that are no longer available in Excel 2007 and later.
  • Discover by learning how to deal with annoying changes to Print Preview in Word 2010 and later.
  • Explore recovering the From Text command in Excel 2019 and Office 365.
  • Explore visualizing data with a Funnel chart in Excel 2019 and Office 365.
  • Discover new worksheet functions available in Excel 2016 and later.
  • Identify restoring the Workbook Sharing and Track Changes commands that have vanished in certain builds of Office 365.
  • Discover restoring “classic” Print Preview functionality in Excel 2010 and later.
Last updated/reviewed: November 10, 2019

1 Review (7 ratings)Reviews

5
Anonymous Author
Very helpful, I had forgotten a few of the features.

Prerequisites

Course Complexity: Intermediate

No Advanced Preparation or Prerequisites are needed for this course.

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
  10:09Reclaim Forgotten Features in Excel
  7:48Restoring Classic Print Preview
  8:22Toggle Full Screen Shortcut
  7:48Rotating 3D Charts
  8:39Office 365 Shared Workbooks
  7:38Enabling From Text In Office 365
  6:09Funnel Charts (Excel 2019+)
Continuous Play
  56:44Zombie Excel:Reclaim Forgotten Features
Supporting Materials
  PDFSlides: Zombie Excel-Reclaim Forgotten Features.
  XLXSExcel: Zombie Excel-Reclaim Forgotten Features
  CSVExcel: Zombie Excel-Reclaim Forgotten Features
  PDFZombie Excel-Reclaim Forgotten Features Glossary/Index
Review And Test
  quizREVIEW QUESTIONS
 examFINAL EXAM