This practical webinar teaches attendees to build reliable lookup formulas in Microsoft 365 Excel for Windows. The F.I.N.D. method (Find what, In which table, Number of the return column, Decide exact or approximate) breaks VLOOKUP into four clear decisions. Attendees then learn MATCH and INDEX separately before combining them into the more flexible INDEX/MATCH pattern. The session closes with error handling, troubleshooting #N/A, and a brief look at XLOOKUP. A practice workbook with sample data is provided for following along.
A lookup formula that returns the wrong value doesn't show an error. It shows a believable number. If you've ever copied a VLOOKUP from a colleague, watched it break after someone inserted a column, or struggled with a sheet full of #N/A errors, this session is for you. You'll learn how each function works, when to use which, and how to build lookups you can trust.
Speaker Profile
Allen Evitts is a seasoned project management professional with extensive experience in the field. With a career span of over two decades, Allen has successfully led numerous projects across various industries, including technology, healthcare, and construction. Allen's expertise lies in both traditional and Agile project management methodologies, making them a versatile and knowledgeable instructor.
Allen has a proven track record of delivering projects on time, within budget, and to the satisfaction of stakeholders. Their ability to organize, communicate, and lead teams has earned them recognition as a top project management consultant. Allen's approach to project management is rooted in practical, real-world experience, ensuring that participants in their webinars gain valuable insights and actionable skills.
In addition to their professional experience, Allen is a certified Project Management Professional (PMP) and holds certifications in Agile methodologies, including Scrum Master, and in Cybersecurity. Allen is also an active member of the Project Management Institute (PMI).
Allen's passion for teaching and mentoring has led them to develop and deliver comprehensive training programs that empower project professionals to excel in their roles. Their engaging and interactive teaching style ensures that participants not only learn the essential skills but also feel confident in applying them to their projects.
Join Allen Evitts in the webinar "Organize, Communicate, Lead: Essential Skills for Project Professionals" to enhance your project management skills and lead your projects to success!