Bill Jelen Books

Microsoft Power BI, including Power Pivot and Power Query, are a set of free add-ons to Excel that allow users to produce new kinds of reports and analyses that were simply impossible before. This book, printed in full-gorgeous color, gives you an overview of Power BI, Power Pivot and Power Query, and then dives into DAX formulas, the core capability of Power Pivot. Always from the perspective of the Excel audience. Written by the world's foremost Power BI bloggers and practitioners, the book's concepts and approach are introduced in a simple, step-by-step manner tailored to the learning style of Excel users everywhere. The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce. -- Provided by publisher

Learn how to use Excel pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you've never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power--including valuable improvements in Excel and in Office 365. Drawing on more than 45 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical recipes for solving real business problems, help you avoid common mistakes, and present tips and tricks you'll find nowhere else.

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.

Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad help you automate Excel tasks to get more done, faster than ever. Use this guide to automate virtually any routine Excel save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Microsoft Excel. You'll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions. By reading this book, you About This Book • For everyone who wants to get more done with Microsoft Excel in less time • For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data

Two of the leading Excel channels on YouTube join forces to combat bad data. This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, "MrExcel," and Oz do Soleil during their careers run as financial analysts charged with taking mainframe data and turning it into useful information quickly. Topics include data quality, validation, perfectly sorting with one click every time, matching lists of data, data consolidation, data subtotals, pivot tables, pivot charts, tables, and much more.

Provides comprehensive coverage on the spreadsheet software, including detailed solutions to everyday problems, real-world examples, troubleshooting help, and in-depth explanations of new features.

You're beyond the basics--so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Learn how the experts tackle Excel--and challenge yourself to new levels of mastery. Includes companion eBook and sample files. Topics include: Customizing the Excel workspace Best practices for designing and managing worksheets Creating formulas and functions Performing statistical, what-if, and other data analysis Core to advanced charting techniques Using graphics and sparklines Managing databases and tables Automating Excel with macros and custom functions Collaborating in Excel online, in the cloud, and more Extending Excel

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 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.

Provides a series of practical, easy-to-follow patterns for common analysis, reporting, and dashboarding functions when using Power Pivot. Includes newer Excel products such as Power Query, Power View and Power Map

Dzięki tabelom i wykresom przestawnym w Microsoft 365 i Excel 2021, tworzenie dynamicznych raportów staje się szybkie i proste. Nawet jeśli nigdy wcześniej nie korzystaliśmy z tabel przestawnych, ta książka pozwoli nam wykorzystać ich elastyczność i analityczne możliwości, wzbogacone o nowe funkcje Microsoft 365. Bill Jelen, znany jako „MrExcel”, dzieli się swoją ponad 30-letnią wiedzą, oferując praktyczne rozwiązania dla rzeczywistych problemów biznesowych. Czytelnicy nauczą się skutecznie tworzyć, dostosowywać i kontrolować tabele przestawne, przekształcać duże zbiory danych w czytelne raporty oraz analizować dane z różnych źródeł przy użyciu Power Query. Poznają również techniki tworzenia raportów krzyżowych, tabel przestawnych z danymi geograficznymi oraz nowoczesnych dynamicznych pulpitów. Książka jest skierowana do profesjonalistów w biznesie, finansach, naukowców, studentów i wszystkich, którzy chcą efektywnie zarządzać danymi. Bill Jelen, Excel MVP, jest autorem 64 książek i gospodarzem popularnego podcastu, oferując cenne wskazówki i unikalne triki, które pomogą uniknąć typowych błędów.