MrExcel 23
About This Book
Written for professionals who spend roughly 40 hours a week in Excel, this collection of tips is meant to help them get more done in less time. The entries grew out of Bill Jelen's live Power Excel seminars and concentrate on hidden methods that lead to sudden moments of insight into features many users never discover. The material covers general Excel features, pivot tables, and formulas, with particular attention to VLOOKUP and the newer XLOOKUP. It also introduces more recent parts of Excel, including the Power Pivot Data Model and Power Query, which is used to clean up messy data. Revised every year, this edition for 2021 adds coverage of the LET and LAMBDA functions, new data types, dynamic array formulas, and more.
ISBN: 9781615470792
Unlock Exclusive Content
Experience the hidden layers of 'MrExcel 23'. Scan the book cover with the Appilog mobile app to see behind-the-scenes videos, author reviews, and interactive digital stories.
Available on iOS & Android






