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

Topics

• 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

Who should Attend

• 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