XLOOKUP has become Excel's premier lookup function, replacing many of the limitations of VLOOKUP and HLOOKUP while introducing capabilities that were previously difficult or impossible to achieve. In this practical session, CPA and author of Microsoft 365 Excel for Dummies David Ringstrom demonstrates how to use XLOOKUP confidently to retrieve information, solve common lookup challenges,...

PivotTables are among Excel’s most powerful reporting tools, but small setup and design choices can determine whether the results are useful, confusing, or incomplete. In this practical session, CPA and author of Microsoft 365 Excel for Dummies David Ringstrom demonstrates how to build PivotTables that summarize detailed data clearly, adapt to changing questions, and remain...