MrExcel 23 : The Greatest Excel Tips of All Time
(Author) Bill JelenExcel 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 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.
Bill Jelen
Bill Jelen, also known as "Mr. Excel," is a renowned author and expert in the field of Microsoft Excel. He is best known for his series of books on Excel, which provide practical tips and techniques for users of all levels. Jelen's writing style is clear, concise, and easy to understand, making complex Excel functions and formulas accessible to a wide audience. His contributions to literature include empowering individuals and businesses to maximize their use of Excel for data analysis, reporting, and decision-making. One of his most famous works is "Excel 2019 Power Programming with VBA," which has become a go-to resource for Excel users looking to automate tasks and enhance the functionality of the software. Jelen's impact on the literary genre of Excel guides is unparalleled, as he continues to educate and inspire readers around the world with his expertise and passion for Excel.