March 25, 2019 - by Bill Jelen
Early in 2017, Map Charts appeared on the Insert tab in Office 365. A Map chart shades closed regions on a map such as countries, states, counties, even zip code boundaries.
Editorial: Microsoft Should Stop Selling Office 2019 to the General Public »
March 24, 2019 - by Bill Jelen
Wondering if you should upgrade to Office 2019 or Office 365? If you have access to the Internet, there is only one viable choice, and it is Office 365.
Excel 2019: Create Funnel Charts in Office 365 »
March 22, 2019 - by Bill Jelen
In 2016, Office 365 introduced Funnel charts, as well as Treemap, Sunburst, Box & Whisker, Pareto, and Histogram charts. A Funnel chart is great for showing a sales funnel.
Excel Subtotals Straight to the Point »
I used to use the Subtotals feature daily after downloading mainframe data. This book covers every tip and trick for using Subtotals.
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.
Cleaning Excel Data With Power Query Straight To The Point »
This book provides a quick Straight-to-the-Point introduction to Power Query. There’s a lot here, and there’s also a lot that’s not here. Reading this book will be like sitting down at a café and striking up a conversation with the person at the next table, where you learn enough random stuff about that person to decide if you want to know more and keep in touch.
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.
