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: March 5, 2024
6 Reviews (48 ratings)

Reviews

5
Anonymous Author
As someone with real experience only as of 2017, the course was a great preview into some of the differences across the platform over time. Going through each topic twice and providing full explanation prior to real time examples was very helpful.
5
Anonymous Author
Interesting course and a few items were useful to me but I suppose there is a reason excel put these items in the basement to make room for more powerful and useful functions.
5
Anonymous Author
The instructor is good...I like the way he goes over the material twice in different ways to help you learn the information.
5
Anonymous Author
This presenter gives the participant exactly the information necessary without wasting words or time.
5
Anonymous Author
Very helpful, I had forgotten a few of the features.
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 .
Instructor for this course
  Course Overview CPE
Course Syllabus
INTRODUCTION AND OVERVIEW
  Reclaim Forgotten Features in Excel10:09
  Restoring Classic Print Preview7:48
  Toggle Full Screen Shortcut8:22
  Rotating 3D Charts7:48
  Office 365 Shared Workbooks8:39
  Enabling From Text In Office 3657:38
  Funnel Charts (Excel 2019+)6:09
Continuous Play
  Zombie Excel:Reclaim Forgotten Features56:44
Supporting Materials
  Slides: Zombie Excel-Reclaim Forgotten Features.PDF
  Excel: Zombie Excel-Reclaim Forgotten FeaturesXLXS
  Excel: Zombie Excel-Reclaim Forgotten FeaturesCSV
  Zombie Excel-Reclaim Forgotten Features Glossary/IndexPDF
Review And Test
  REVIEW QUESTIONSquiz
 FINAL EXAMexam