4 Hour Live Virtual Training on MS Excel Formulas and Tools of the Trade

Description

4 Hour Live Virtual Training on MS Excel Formulas and Tools of the Trade is a webinar that covers topics such as:

  • Use two types of IF Functions (Logical and Error)
  • Text To Columns and then Reverse w/ Concatonate
  • Understand the syntax of the Index and Match formulas (finally ‘simply’ explained)
  • Understand the syntax of the VLookup and HLookup formulas
  • Remove Duplicates while staying in charge of the process with Conditional Formatting
  • Transpose Data that may be organized incorrectly
  • Absolute Ref vs Named Range in Formulas
  • Flash Fill (new in 2016)
  • Formula Watch Window
  • Formula Auditing + Show Codes
  • And hidden tools to add to your Quick Access Toolbar

4 Hour Live Virtual Training on MS Excel Formulas and Tools of the Trade is intended for:

  • Aviation
  • Accountants, Accounts, Audit
  • Controllers, CPAs
  • Banking, CFOs
  • Energy
  • Education
  • Finance, Financial consultants
  • FDA
  • Insurance
  • Human Resource
  • IT
  • Investments
  • Marketing
  • Logistics & Supply Chain
  • Pharmaceutical
  • Medical Devices
  • Telecom
  • Retail,Sales

Future Events

Past Events

Important

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

Prices are for evaluation only.

Other Events with Similar Categories

Other Events with Similar Location or Organizer

Featured Conferences & Exhibitions