In this exclusive Halloween presentation Excel instructor David H. Ringstrom, CPA will shine a light on some of the darkest corners of Excel. Watch as David helps you resurrect features that you may have thought are gone from Excel, or in other cases confirms your suspicions. You’ll 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.

Topics Covered:

  • Learning the benefits and risks of sharing workbooks via OneDrive in Office 365.
  • Converting .XLS files compatible with Excel 2003 into the modern Excel workbook format.
  • Restoring Full Screen View in Excel 2013 and later as well as enabling a keyboard shortcut for this feature.
  • Overcoming user interface annoyances by making simple adjustments to Excel’s options.
  • Utilizing the Split Worksheet feature properly to lock certain rows at the bottom of the Excel window.
  • Review Excel 2003 charting features that are no longer available in Excel 2007 and later.
  • Learning how to deal with annoying changes to Print Preview in Word 2010 and later.
  • Recovering the From Text command in Excel 2019 and Office 365.
  • Visualizing data with a Funnel chart in Excel 2019 and Office 365.
  • Discovering new worksheet functions available in Excel 2016 and later.
  • Restoring the Workbook Sharing and Track Changes commands that have vanished in certain builds of Office 365.
  • Restoring “classic” Print Preview functionality in Excel 2010 and later.

Learning Objectives:

  • Identify the hidden command can you add to your Quick Access Toolbar to restore the full-screen Print Preview as it appeared in Excel 2007 and earlier.
  • State the type of workbooks that trigger Compatibility Mode in Excel 2007 and later.
  • Recall the worksheet function that the CONCAT function replaces in Office 365.