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
Practical Excel How to Work Faster 2 Part Web Series 2019 is intended for:
- 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