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

Topics

• 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
• Other Accounting and Finance Professionals
• Managerial Accountants
• IT Departments
• Human Resources Departments
• Banking Professionals
• Auditors
• Excel Users in Regulated Lifesciences Industry
• Insurance Professionals
• Sales and Marketing Professionals
• Logistics and Supply Chain Professionals