Course Information
Schedules
- Anytime
Registration period
Year-round Recruitment
Price
-
Course Level
Study Mode
Duration
4 Hour(s)
Language
English
Location
-
69 views
Course Overview
About the Course
In this practical and interactive webinar, you will work along with the instructor. As you progress through the provided spreadsheet of exercises, you will learn a handful of the most often used formulas in Excel. These will include: VLookup, HLookup, Index and Match (solved at last!), Text to Columns, Concatenate, remove Duplicates, IF Functions, Flash Fill and more! You will also discover the tools Andy uses almost daily, but are overlooked and mostly forgotten in Excel. These include, Formula Auditing, Formula Watch, Show Formulas and special tools to add to the Quick Access Toolbar.
Who is the Target Audience?
- Accountants, Accounts, Audit
- Aviation
- Banking, CFOs
- Controllers, CPAs
- Education
- Energy
- FDA
- Finance, Financial consultants
- Human Resource
- Insurance
- Investments
- IT
- Logistics & Supply Chain
- Marketing
- Medical Devices
- Pharmaceutical
- Retail,Sales
- Telecom
Basic Knowledge:
This is an intermediate level class. Attendees should be familiar with Excel and use it on a regular basis, at least weekly.
What You’ll Learn
Course Objective
- Text To Columns and then Reverse w/ Concatonate
- Use two types of IF Functions (Logical and Error)
- Understand the syntax of the VLookup and HLookup formulas
- Understand the syntax of the Index and Match formulas (finally ‘simply’ explained)
- Transpose Data that may be organized incorrectly
- Remove Duplicates while staying in charge of the process with Conditional Formatting
- Flash Fill (new in 2016)
- Absolute Ref vs Named Range in Formulas
- Formula Auditing + Show Codes
- Formula Watch Window
- And hidden tools to add to your Quick Access Toolbar
