Description
If you’d like to discover features and techniques you can use to speed up your work in Excel, this is the perfect course for you! In his jam-packed session, Excel expert David Ringstrom, CPA, explains a variety of time-saving features and shares helpful tips, such as how to filter data faster, streamline repetitive tasks, create keyboard shortcuts, access folders and workbooks easily, and more.
Topics Covered:
- Overcoming user interface annoyances by making simple adjustments to Excel’s options.
- Learning how the Table feature empowers you to improve the integrity of Excel spreadsheets.
- Inserting totals into lists with a few mouse clicks by way of Excel’s SUBTOTAL function.
- Seeing how to customize the default workbook that all new workbooks will be based on going forward.
- Streamlining repetitive tasks by way of Excel’s Quick Access Toolbar.
- Understanding how the Table feature automates formula management within lists.
- Leveraging Excel’s Quick Access Toolbar to create a shortcut that enables you to filter lists with a keystroke instead of multiple mouse actions.
- Restoring “classic” Print Preview functionality in Excel 2010 and later.
- Gaining control of long lists of data by filtering instead of sorting.
- Simplifying repetitive tasks by creating your own keyboard shortcuts.
- Streamlining filtering of lists in Excel 2013 and later by using the Slicer feature with tables.
- Surfacing hidden Excel commands instantly by way of the Tell Me feature in Excel 2016.
Learning Objectives:
- Recall how to create your own custom keyboard shortcuts.
- Identify how to unlock hidden functionality by double-clicking on certain aspects in Excel.
- Describe how to easily compile large lists of data by filtering vs. sorting.
