Month: July 2018
The Spreadsheet Guru shows us how to create custom lists to improve our Slicers!
Excel TV builds a map using Conditional Formatting!
Not Just Numbers walks through some interesting applications for the SUMPRODUCT() formula!
My Online Training Hub shows us an add-in that can translate into 80 languages!
MVP John MacDougall guest posts on Vertex42 to show us how to track Income and Expenses with Pivot Tables!
Peltier Tech shows us how to create Step Charts in Excel. This is great for tracking periodic changes in value, and the duration of the value!
Excel Spreadsheets Help is here with a quick tip on one of my pet peeves. Hide your gridlines!
CPA Self Study has a neat trick to prevent users from entering duplicate data.
Ann K Emery is here with some solid advice on improving your charts. Make them easy to understand!
Jay Burleigh uncovers a strange addition error in Excel, and explains why this is happening. Very interesting; try it out for yourself!