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

February 11, 2019
Webinar

Practical Excel – How to Work Faster – 2 Part Web Series 2019 will be held on February 11, 2019.

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
195 US Dollar
No exhibition

Important

Please, check the official conference website for possible changes, before you make any traveling arrangements

Prices are for evaluation only.

Find Similar Events by Category

Education:   Training   
Services:   Banking    Insurance   

People interested in this event are also interested in:

NG Financial Services Technology Summit North America 2019
May 13-15, 2019
Broomfield, United States
Small Business Expo 2019 - New York
June 5, 2019
New York City, United States
Small Business Expo 2019 - Chicago
June 20, 2019
Chicago, United States