wolters kluwer

Excel Speed Tips

This course brought to you by Wolters Kluwer

1 Lesson / $55 / 2 CPE hours

Topics Covered

  • How to use the Slicer feature to streamline data analysis within tables and pivot tables.
  • Techniques that automatically provide fallback positions in the event you need to see an earlier version of your spreadsheet
  • Navigate large workbooks with ease by way of a hidden menu as well as keyboard shortcuts
  • Avoid disabled features by converting Excel 97—2003 files to modern workbook formats with ease
  • Use the Table feature in Excel 2007 and later to create charts that expand or contract automatically as your source data changes
  • Launch macros that clean up pivot tables with a single mouse click
  • How the Table feature allows you to transform filtering tasks
  • Embed frequently used lists, such as employees, departments, or key customers, into Excel’s interface for use with any spreadsheet
  • Apply different filter settings with just a couple of mouse clicks using the Custom Views feature
  • Strike through list items with a custom shortcut
  • Convert .XLS workbooks to the up-to-date .XLSX format with just two keystrokes
  • Bypass filter drop-down lists by filtering based on cell contents with a single keystroke or mouse click