Excel tips to skyrocket white-collar productivity.
Originally designed for Bill Jelen's live Power Excel seminars, the target audience already uses Excel 40 hours a week. These tips are the ""aha"" tips that uncover secret methods in Excel. The book covers general Excel functions, pivot tables, and formulas such as VLOOKUPand the new XLOOKUP. It introduces elements of modern Excel such as the Power Pivot Data Model and cleaning data with Power Query. Updated annually, this edition for 2021 adds information on LET and LAMBDA functions, amazing new data types, dynamic array formulas, and more.
By:
Bill Jelen Imprint: Holy Macro! Books Country of Publication: United States Edition: Seventh edition Dimensions:
Height: 273mm,
Width: 209mm,
ISBN:9781615470792 ISBN 10: 1615470794 Pages: 282 Publication Date:21 August 2024 Audience:
General/trade
,
ELT Advanced
Format:Paperback Publisher's Status: Active
Bill Jelenis the host of www.MrExcel.com, a Microsoft MVP, and the author of 68 books about Excel. He lives in Merritt Island, Florida.