Practical Excel - How to Work Faster - 2 Part Web Series (Module 1) 2019

Topics

• 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

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