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

By Visited 1 times , 1 Visits today

Start Date: 2020-08-06
End Date: 2020-08-06
Time: 1:00 pm to 5:00 pm

Phone: 5108496155

Location: online


Get Direction View Large Map


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. 

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

Who is the Target Audience?

Accountants, Accounts, Audit


Banking, CFOs

Controllers, CPAs




Finance, Financial consultants

Human Resource




Logistics & Supply Chain


Medical Devices




Basic Knowledge:

This is an intermediate level class. Attendees should be familiar with Excel and use it on a regular basis, at least weekly.

Registration Information

Register here:

Click the link for registration or ticketing information:

Registration URL


Organized by :  simplivllc Organizer's Address : online, 39658 Mission Boulevard, Fremont, CA 94539, USA. Website :

About the Organizers :