- Text To Columns and then Reverse w/ Concatonate
- Flash Fill (new in 2016)
- Transpose Data that may be organized incorrectly
- Remove Duplicates while staying in charge of the process with Conditional Formatting
- Home
- Simpliv Learning
- Courses
- 4 Hour Live Virtual Training on MS Excel Formulas and Tools of the Trade
4 Hour Live Virtual Training on MS Excel Formulas and Tools of the Trade
BY
Simpliv Learning
Online
4 Hours
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study, Virtual Classroom
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
certificate availability
Yes
certificate providing authority
Simpliv Learning
The syllabus
Index
Hour 1
Hour 2
- Use two types of IF Functions (Logical and Error)
- Understand the syntax of the VLookup and HLookup formulas
Hour 3
- Understand the syntax of the Index and Match formulas (finally ‘simply’ explained)
- Absolute Ref vs Named Range in Formulas
- Formula Auditing + Show Codes
- Formula Watch Window
Hour 4
- Tools to add to your Quick Access Toolbar (QAT)
- Interactive session to customize your QAT for efficiency