MS EXCEL - VLOOKUP and XLOOKUP function

What will you learn on the workshop MS EXCEL – functions VLOOKUP and XLOOKUP?

Workshop MS EXCEL functions VLOOKUP and XLOOKUP is designed for EXCEL users, who already do have basic experience with using of  EXCEL functions and need to get the answers to the following questions:

How to map the data from one table / sheet /  workbook to another?

How to prepare your data before you use VLOOKUP or XLOOKUP?

How to understand the syntax (parameters) of these functions?

How to check the results after you use these functions?

Objectives

• When do you need functions XLOOKUP / VLOOKUP in daily work and when you can actually use them?
• How does the  XLOOKUP / VLOOKUP „think„? 
• How to prepare data before you start writing XLOOKUP / VLOOKUP?
• How to truly understand and use the syntax of  XLOOKUP / VLOOKUP?
• Why is it useful to use „zero“ in the last argument of VLOOKUP?
• What will be the impact on the data, if  we will not use „zero“ in the last argument of the function VLOOKUP? 
• How to work with „dollars“ by functions  XLOOKUP / VLOOKUP?
• Is it possible to „drag“ the functions  XLOOKUP / VLOOKUP to the right? 
• What are the limitations of functions  XLOOKUP / VLOOKUP ? 
• How to understand the errors of functions  XLOOKUP / VLOOKUP? 
• How to use nesting of VLOOKUP to the IFERROR function in order to „clean up“ the errors?
• „Decalogue of  XLOOKUP / VLOOKUP“ – a step-by-step guide with clear process of what to do before, during and after you use XLOOKUP / VLOOKUP (also as printable .pdf)

How do I lead the workshop?

I lead the workshop ONLINE LIVE, via Zoom (in case your company prefers different meeting app, let me know on info@love2teach.sk).  The training lasts 3 hours and it’s split into two 90 minutes blocks, to maximize participants attention. I strongly prefer that participants work together with me during the sessions on their computers. In this way they can work on the assignments on their own and ask me the questions directly.

What do you need for the workshop?

• reliable internet connection
• installed version of MS EXCEL. I lead workshops with the version MS Office 365, but the participants could use older/other versions. In case you are not sure about the EXCEL version, contact me on info@love2teach.sk

Communication with the participants during the workshop could be led via chat. In case you prefer live QnA, make sure that your employees will have microphones.

Recommendations from my clients

My colleagues approached me with a request to find training focused on enhancing their Excel skills. Selecting the right instructor, given the diversity of activities and responsibilities, seemed like a real challenge at first glance. The top priority was for the training to be practical, effective, and useful for all participants. And that’s exactly what it was. Participants highly appreciated the instructor’s professional (yet personable) and especially proactive approach. Veronika tailored the entire program to meet our needs, working with real requests, expectations, and data from colleagues. I give an NPS score of 10!Monika V.

Thank you very much, Veronika, for the comprehensive package of Excel training for the entire Pharm-In team. The atmosphere was fantastic, and you know how to explain tasks and Excel’s capabilities in a professional and enthusiastic manner, tailoring them to specific situations. Excel in your hands is enjoyable, clear, and easily applicable. We will gladly use your expert advice, tricks, and tips in future projects as well! 😉👍🏻 Janka V.

Veronika is a very skilled and experienced instructor with a client-focused approach. We chose her as the instructor for a two-day Excel course at our company. She created a pleasant atmosphere during the training and, even while teaching a group, maintained an individual approach to everyone who had questions. She genuinely cares about ensuring that clients truly understand the topic she is teaching and that they leave the training not only with valuable information but also with a positive experience. 🙂 We were very satisfied and recommend her to anyone looking to improve their Excel skills.Ivana Š.

I met Veronika only recently while we were planning and organizing several Excel training sessions for our team at Martinus. Throughout the process, I found communication with her very easy; she radiates not only humanity but also great professionalism. Although I didn’t experience the training personally, I’ve heard a lot of praise from colleagues about her teaching skills and overall approach. The greatest achievement for me, however, is the fact that she sparked their interest in Excel, its intricacies, and tips, regardless of their skill level. It’s clear that they genuinely enjoy using it. Andrea K.

I had the opportunity to get to know Veronika through the Excel training sessions she conducted at our company. The training was excellently tailored to the groups, interactive, and we learned a lot. Veronika is an empathetic and kind instructor, and we will definitely arrange for more training sessions in the future. Nikola B.

To see more recommendations, check my LinkedIn profile.