Effortless VLOOKUP Function | Learn How to Use VLOOKUP in Excel
Event Information
About this Event
Are you sick and tired of relying on someone else to help with your VLOOKUP functions?
Are you looking for the most efficient and thorough way to master Excel VLOOKUP functions?
Have you taken a VLOOKUP class, but felt rushed so that you didn't retain what you learned?
Have you inherited workbooks with intricate VLOOKUP functions, and you aren't sure how to edit them?
If so, our course, Effortless VLOOKUP Functions, is for you!
Who should attend this Excel VLOOKUP course?
You should attend this class if you are interested in:
- Interactive, fun sessions.
- Immersive learning, where you practice as you learn.
- An on-hand expert to critique your work, so that you don’t get stuck.
- Small class size, so that you get the attention you deserve.
- Complex topics broken up into smaller bites, so that your brain doesn’t explode.
- Little-known shortcuts and hacks to create your VLOOKUP functions.
- A course tailored to your level and goals. (In order to help us tailor this course, please complete the survey you'll receive once you register).
What to expect from this VLOOKUP Course
You'll learn:
- Foundational concepts that you'll need to use in working with VLOOKOUP functions
- Your first VLOOKUP function, step-by-step.
- The various flavors of VLOOKUP functions.
- Advanced-level VLOOKUP functions, including nested VLOOKUPs, MATCH & INDEX.
Topics Include:
- What are VLOOKUP functions?
- How to use VLOOKUP functions
- Closest vs. Exact Match VLOOKUP Functions
- Multiple Value VLOOKUPs
- Multiple Criteria VLOOKUPs
- Nested VLOOKUPs
- XLOOKUP Functions
- MATCH/INDEX Functions
- Trouble-shooting VLOOKUP functions
- When to use VLOOKUP vs. XLOOKUP vs. MATCH/INDEX.
What you'll get:
- Learning tailored to the participants’ needs and skill level.
- Hands-on practice exercises for each concept so that you retain what we teach.
- An expert on hand to review your work so that the class moves along.
- The ability to share your screen with your instructor (you need to give permission each time you share your screen).
VLOOKUP Function Course Bonuses
We want to do everything possible to support your successful learning and retention.
Your registration includes the following bonuses:
- Course handouts in PDF. (A $35 value)
- 6 months’ access to the recordings. (A $197 value)
- Practice exercises
- 4 weeks of challenge exercises (Have you ever attended a course, only to find yourself forgetting key concepts? We’ll send you a project each week to help reinforce what you learn.)
Would you like us to customize this virtual course for your organization? We offer customized training with the option to incorporate your Excel projects. Contact us or call 770.498.7333 for details.
Organizations we've served include:
- The City of Atlanta
- Coca-Cola
- Zaxby's
- Environmental Protection Agency
What people say about our Excel training
(Jackie) was interesting and upbeat during training. A great deal of knowledge and assistance was provided. Zodiac Aerospace
... went the extra mile to give me additional information and shortcuts that the books didn't cover. I learned a lot from this class/training that will help throughout my day-to-day projects. I would highly recommend (Jackie) for future training.
I highly recommend the Excel ... class to anybody who wants to learn ... Excel. Jackie teaches the class at a pace that is enjoyable.
Learning how to use Excel spreadsheets has enabled me to record and interpret data in a MUCH FASTER and more efficient way. I had been putting off how to use Excel, and Jackie greatly relieved my anxiety by showing me the ropes of Excel and making it easy for me to learn. David Redding, M.D. Redding Allergy and Asthma Center
Very personable. Provided good training materials. Provided opportunities to answer questions. Practice exercises (were done well).
Walked through every aspect of questions the group had. Kept the attention of everyone, tailored (courses) to our needs. Explained to where everyone could grasp concepts.
(What Jackie did well) Everything from explaining unfamiliar material to simplifying information to relay to class; she is excellent. Coca-Cola Company
(Jackie) also encouraged participation and answered all questions clearly. Zodiac Aerospace
Jackie allowed time for candid questions and real life work/application questions. Zodiac Aerospace
(Jackie) Answered questions, but also allowed us to solve practice problems on our own. I liked the "pop quiz" type problems.
Prerequisites:
In order to keep pace with this course, you should be very familiar with basic excel functions:
- SUM, COUNT, AVERAGE, MIN, MAX
- Date Functions
- Text Functions
If you aren't, consider attending our Basic Excel Functions: Step-by-Step course.
Excel VLOOKUP Course Logistics:
Please check your inbox for the pre-course survey and complete it. The answers to this survey enable us to TAILOR the class to your needs.
We will use Zoom. The free version will work. If you haven't downloaded Zoom before, make a plan to download it (https://zoom.us) at least 1 day before class. If you have Zoom on your system, please log on at least 5 minutes early to allow you to troubleshoot any problems.
We will email your Zoom link and any practice files or handouts 48 hours before class.
All sessions are recorded. Recorded sessions are available for purchase ($197 each).
While not required, it is best when learners join with the video ON, use headphones or earbuds.
Please carve out this time to focus on mastering the subject. Exit email and other programs, make sure you're in a distraction-free zone, etc. Since our learning modules build on each other, if you miss a section it might be difficult to catch up .
Hardware and Software:
You will need a PC with Excel 2016 or later installed. If you do not have Office 365, the XLOOKUP function might not be available.
Having an external monitor is very helpful, although not necessary.
Please use a LAPTOP or DESKTOP, and not a tablet or MAC. To request Excel for MAC training, call 770-498-7333 or contact us.
About your Excel Instructor:
Jackie Kiadii, Microsoft Certified Trainer
- Modern Classroom Certified Trainer - Virtual Training
- Microsoft Office Expert - Excel
- Microsoft Office Expert - Word
Since 2001, Jackie Kiadii has developed courses and taught business professionals how to leverage technology to increase their productivity and profitability.
She and her team of Subject Matter Experts provide training in all Microsoft Office applications: Access, Excel, Outlook, PowerPoint, Publisher, Project, SharePoint, Teams, Word and more.
Organizations served include: Airbus Americas, The CDC, The Coca-Cola Company, City of Atlanta, Emory University, Novelis, Georgia Pacific.
Refund / Cancellation Policy:
If we cancel class, students will be issued a full refund. If a student cancels registration at least 1 week prior to class, instructor will issue a refund less $85 administrative fee; student will receive 6-month access to the recording of the class.
Would you like us to customize this virtual course for your organization? We offer customized training with the option to incorporate your Excel workbook projects. Contact us or call 770.498.7333 for details.