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
Maria
Client
Speaker was very animated, which I found amusing and kept me engaged on a topic that could be quite boring.
Angelique Luzader
Client
I feel much more prepared to do my job. Thank you so much. Speaker provided Clear concise information, she was extremely knowledgeable.
Kari Annen
Client
Elga was very engaging to listen and learn from. She gave good examples to follow.
Lucious Cameron
Client
The subject matter was very interesting and the instructor was well informed. Content of the webinar was Very Helpful!
Sheri
Client
The presenter is knowledgeable about the topic and makes the webinar interesting
Azahara
Client
Gave samples and took their time to explain everything to the point
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
Mar 02nd 2022 @ 01:00 PM ET
Managing Your Inevitable Workplace Conflicts: Are You a Teddy Bear, a Turtle, a Shark, a Fox or an Owl?
Jun 27th 2019 @ 01:00 PM ET
Can an Employee be Fired over a Social Media Posting?
Jun 17th 2021 @ 01:00 PM ET
PDF Tips and Tricks for Business Professionals
Sep 02nd 2020 @ 01:00 PM ET
New FMLA Forms with FFCRA Guidelines as Per DOL!
Event Calendar
Our Accreditation Partner
PAYMENT
100% secure payments. All major credit and debit cards are accepted.
