Practical Excel – How to Work Faster – 2 Part Web Series 2019

Topics

• 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

Who should Attend

• CPAs
• CFOs
• Investment Analysts
• Controllers
• Business Analysts
• Financial Analysts
• M&A Specialists (Mergers & Acquisitions)
• Forecasting & Planning Teams
• Strategic Planners
• Risk Managers
• Cost Accountants
• Capital Expenditure Planners
• Human Resources Departments
• IT Departments
• Banking Professionals
• Auditors
• Excel Users in Regulated Lifesciences Industry
• Insurance Professionals
• Sales and Marketing Professionals
• Logistics and Supply Chain Professionals
• Managerial Accountants
• Other Accounting and Finance Professionals