Description
Inspiring Excel tips designed to save 100 hours per year.
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 VLOOKUP and 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 2022 adds information on collaboration features, LET and LAMBDA functions, amazing new data types, dynamic array formulas, and more.
About the Author
Bill Jelen is the host of www.MrExcel.com, a Microsoft MVP, and the author of 65 books about Excel. He lives in Merritt Island, Florida.
Book Information
ISBN 9781615470778
Author Bill Jelen
Format Paperback
Page Count 298
Imprint Holy Macro! Books
Publisher Holy Macro! Books
Weight(grams) 680g
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 VLOOKUP and 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 2022 adds information on collaboration features, LET and LAMBDA functions, amazing new data types, dynamic array formulas, and more.
About the Author
Bill Jelen is the host of www.MrExcel.com, a Microsoft MVP, and the author of 65 books about Excel. He lives in Merritt Island, Florida.
Book Information
ISBN 9781615470778
Author Bill Jelen
Format Paperback
Page Count 298
Imprint Holy Macro! Books
Publisher Holy Macro! Books
Weight(grams) 680g
