April 24, 2019 - by Bill Jelen
You might wonder how the pivot table above changed from green to orange. The Design tab has a gallery with 84 built-in formats for pivot tables. Choose a design from the gallery and the colors change.
One frustrating feature with a pivot table is that the numbers always start out as General format. Right-click any number and choose Number Format....
Excel 2019: Rearrange fields in a pivot table »
April 22, 2019 - by Bill Jelen
The power of pivot tables is the ability to rearrange the fields. If your manager decides you should put Regions across the top and products down the side, it is two drags to create the new report.
Excel 2019: Create Your First Pivot Table »
April 18, 2019 - by Bill Jelen
Pivot tables let you summarize tabular data to a one-page summary in a few clicks. Start with a data set that has headings in row 1. It should have no blank rows, blank columns, blank headings or merged cells.
Excel JavaScript UDFs Straight to the Point »
JavaScript custom functions - UDFs can be used like any other native functions or UDFs in Excel. This book shows the process of creating JavaScript UDFs in Excel Developer Preview for Office Insider program subscribers.
This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.
Microsoft Excel 2019 Pivot Table Data Crunching »
Use Excel 2019 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 2019 and Excel in Office 365.
MrExcel LX – The Holy Grail of Excel Tips »
A book for people who use Excel 40+ hours per week. Illustrated in full color.
Covering a variety of Excel simulations, from gambling to genetics, this introduction is for people interested in modeling future events, without the cost of an expensive textbook.
Power Excel With MrExcel - 2017 Edition »
This is the print book edition of "Power Excel with MrExcel - 2017 Edition" - by Bill Jelen. Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis.