MrExcel 2024: Igniting Excel

by: Bill Jelen (Author)

Publisher: Holy Macro! Books

Edition: Seventh edition

Publication Date: 2024/5/14

Language: English

Print Length: 340 pages

ISBN-10: 1615470794

ISBN-13: 9781615470792

Book Description

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 VLOOKUP and the new XLOOKUP. It introduces elements of mode 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.

About the Author

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 VLOOKUP and the new XLOOKUP. It introduces elements of mode 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.