Curriculum

12 Chapters · 12 Lessons

  1. 1

    Book Preview

    1. Ultimate Excel with Power Query and ChatGPT Free preview
  2. 2

    Introduction

    1. (Included in full purchase)

      Introduction

  3. 3

    Chapter 1 : Excel Environment

    1. (Included in full purchase)

      Excel Environment

  4. 4

    Chapter 2 : VLOOKUP Is Dead: Or is it?

    1. (Included in full purchase)

      VLOOKUP Is Dead: Or is it?

  5. 5

    Chapter 3 : INDEX and MATCH

    1. (Included in full purchase)

      INDEX and MATCH

  6. 6

    Chapter 4 : LOOKUP

    1. (Included in full purchase)

      LOOKUP

  7. 7

    Chapter 5 : Other LOOKUP Methods and Functions

    1. (Included in full purchase)

      Other LOOKUP Methods and Functions

  8. 8

    Chapter 6 : XLOOKUP

    1. (Included in full purchase)

      XLOOKUP

  9. 9

    Chapter 7 : FILTER: The Ultimate Lookup Function

    1. (Included in full purchase)

      FILTER: The Ultimate Lookup Function

  10. 10

    Chapter 8 : Power Query: One-Stop Solution

    1. (Included in full purchase)

      Power Query: One-Stop Solution

  11. 11

    Chapter 9 : ChatGPT: Using ChatGPT to solve lookup issues

    1. (Included in full purchase)

      ChatGPT: Using ChatGPT to solve lookup issues

  12. 12

    Index

    1. (Included in full purchase)

      Index

About the course

The Ultimate Excel with Power Query and ChatGPT is a revolutionary handbook to help you embark on a transformative journey through the intricate world of Excel's lookup functions. The book dives deep into Excel's lookup universe, offering a meticulous exploration of over 100 techniques. Each method is presented with clarity and precision, making even the most complex lookup scenarios comprehensible. From traditional functions to innovative problem-solving approaches, this book equips you with versatile tools to navigate any data challenge efficiently. What sets this book apart is its focus on job roles. You'll discover techniques that directly enhance productivity, streamline data management tasks, and elevate your efficiency in Excel-related responsibilities. With a comprehensive, engaging, and interactive approach, it transforms learning Excel formulas into a journey of building practical data lookup expertise.

About the Author

Crispo Mwangi is a globally recognized Microsoft Most Valuable Professional (MVP) in Excel, a distinguished Microsoft Certified Trainer, and an Excel Expert accredited by Microsoft Office. With an illustrious career spanning over a decade, Crispo is not just an expert in Excel but a true trailblazer in the world of technology and data management. Renowned for his exceptional leadership in the technology community, Crispo is more than just an expert; he is a mentor, guiding individuals worldwide with unparalleled expertise and passion. His commitment to knowledge sharing is unparalleled, evident through his high-quality blogs and comprehensive training programs, which have empowered countless individuals to harness the full potential of Excel.