Conference Info
- IndustryHuman Resources
- Unique IDUSC2025332
- Duration60 Minutes
- DateFeb 20,2026
- Time10:00 AM PST | 01:00 PM EST
Description
Overview
In this practical webinar, you will learn and understand the syntax of a handful of the most useful and common formulas in Excel. These will include: VLookup, HLookup, XLookup, Flash Fill, Remove Duplicates, IF functions and more!
Who should attend?
- Anyone who is mostly self-taught in Excel, from beginner to advanced, you will learn amazing tips in this webinar.
Why should you attend?
Attend this webinar and learn time saving formulas that will improve your efficiency on projects.
This class demonstrates the most common formulas so attendees will understand formula syntax to build and fix their own calculations as needed.
What you'll learn?
- Flash Fill replaces complex Text-To-Columns and Concatenate functions
- Use two types of IF Functions (Logical and Error)
- Understand the syntax of the V- H- and X-Lookup formulas
- Transpose Data that may be organized incorrectly
- Remove Duplicates while staying in charge of the process with Conditional Formatting
- Name Box – Advanced level
- Absolute Ref vs Named Range in Formulas
- How to Audit Formulas

Ms. Andy Lanning