Advanced Excel Functions: Lookup and Logical Tools
| Duration: 60 minutes | Speaker: Neil Malek |
Available On-Demand
PURCHASE OPTIONS
ABOUT THE EVENT
There are dozens of scenarios in Excel where most users resort to scrolling, staring, and copying-and-pasting information back-and-forth between sheets, and the lookup and logic functions make many of those scenarios very simple to solve automatically.
In this webinar, we’ll demonstrate how a few simple functions can make combining and comparing data easier and less prone to human error.
Topics include:
- Understanding and Using VLOOKUP
- Adding IFERROR and MATCH to Improve VLOOKUP
- Replacing VLOOKUP with INDEX and MATCH
- Creating Dynamic References with INDIRECT and OFFSET
- Implementing Table-Based Referencing in your Spreadsheets
- Adding IF, AND, and OR to your Skillset
- Using Logical Functions for Dynamic Values
- Using Logical Tests for Conditional Formatting
Learning Objectives
- VLOOKUP Fundamentals
- Nesting VLOOKUP with other functions
- Building INDEX / MATCH nested functions
- Dynamic Table References
- Dynamic INDIRECT References
- Dynamic OFFSET References
- Creating IF Logical Functions
- Adding AND and OR to IF Functions
- Adding Logic to standard calculations
- Using Logical Tests in Conditional Formatting
Who Should Attend
- Project Managers
- Business Analysts
- Team Leads
- Financial Professionals
- Business Owners
- Administrative Professionals
Bonus Handout
How-to job aid: Leveraging Lookups and Logic
Neil Malek
Neil Malek runs Knack Training, an Orlando, FL area software and professional development training company. He is a Microsoft Certified Trainer, Adobe Certified Instructor, and CompTIA Certified Technical Trainer with 20 years of working with individuals, small businesses, non-profits, and Fortune 500 companies to identify and close skill gaps. He specializes in customized, hands-on, live workshops.
Why You Should Subscribe?
Unlimited Live and On-Demand Courses
Watch all live or recorded webinars (up to 120 minutes long). Get instant access to a library of more than 500 high quality courses presented by best-in-class presenters.
CEUs: APA, CPE, SHRM and HRCI Credits
Fulfil your recertification requirements by earning CEUs from APA, CPE, SHRM and HRCI.
Free Access to Course Materials
Each program comes with Additional Course Materials, which you can download and read anytime.
Additional Discounts
Get flat 20% discount on Premium Product Category like, Long Hour Webinars.
Call Now At
888-527-3477
Email Us At
Subjects:
Microsoft Excel
Testimonials
What people are saying about us
Sara
Client
I have loved every webinar that Gwen has done. She is informative and helpful.
Katie
Client
I learned the different levels of violations. Her experience is very evident. As long as I can retain the information, I will be on top of my game.
Josephine
Client
Gwen is a very good teacher cause of all her years in the field.
Dustin Yellin
Client
Thanks to you, we don't miss any update from my industry. I will recommend my colleagues to sign-up.
Elizabeth Jeffery
Client
The speaker was extremely knowledgeable. Speaker moved the program forward at a good pace. The time flew by.
Donald
Client
The presenter was knowledgeable and answered questions along the way and after.
Get Unlimited Webinars, Starting $799 only!
- Unlimited Live and On-Demand Webinars (Up to 120 Minutes Long)
- Unlimited Course Materials
- CEUs: APA, CPE, SHRM and HRCI
- 20% Discount on Long Hour Webinars
- Certificate of Participation
Choose Membership
Similar Events
Apr 20th 2022 @ 01:00 PM ET
Are WE No Longer User Friendly? Keeping Peace with Your Resident
Apr 18th 2019 @ 01:00 PM ET
Preparing, Presenting, and Challenging Delay Claims
May 04th 2022 @ 01:00 PM ET
Documenting Resident Violations in 2022 and Beyond
May 15th 2024 @ 01:00 PM ET
Deconstructing Disparate Impact: What It Is and Ten Compliance Strategies
Event Calendar
Our Accreditation Partner
PAYMENT
100% secure payments. All major credit and debit cards are accepted.
