Description

Practical Excel How to Work Faster 2 Part Web Series 2019 is a webinar that covers topics such as:

Module 1
- Discovering how to quickly access folders and workbooks regardless of whether they`re stored on your computer or on a network
- Streamlining filtering of lists in Excel 2013 and later by using the Slicer feature with tables
- Discovering how to quickly access folders and workbooks regardless of whether they`re stored on your computer or on a network
- Exploring the pros and cons of merging cells in 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
- Leveraging Excel`s Quick Access Toolbar to create a shortcut that enables you to filter lists with a key stroke instead of multiple mouse actions
- Enabling a hidden keyboard shortcut for toggling the Freeze Panes feature on or off
- Restoring "classic" Print Preview functionality in Excel 2010 and later
- Learning how the Table feature empowers you to improve the integrity of Excel spreadsheets
- Keeping an eye on how much your text is being reduced as you try to squeeze more on a page
- Streamlining repetitive tasks by way of Excel`s Quick Access Tool bar
Mudule 2
- Separating first/last names into two columns without using formulas or retyping
- Applying formatting to multiple locations within a worksheet by way of the Format Painter feature
- Streamlining the process of printing spreadsheets to.PDF format
- Editing.PDF documents in Word 2013 and later - useful for unlocking data you wish to edit in Excel
- Making the same edits on multiple worksheets at once by grouping worksheets
- Using Flash Fill in Excel 2013 and later to quickly insert dashes into a column of Social Security or telephone numbers
- Eliminating duplicates from a list with just a few mouse clicks
- Discovering the Custom Lists feature in Excel, which enables you to embed frequently used lists into Excel`s Options dialog box for use with any spreadsheet
- Streamlining redundant data entry with a handy keyboard shortcut