Go Ask DebbieApr 26, 20212 minDisplay or Hide Zero values in ExcelSometimes you might not want zero (0) values showing on your worksheets, sometimes you need them to be seen. Whether your format...
Go Ask DebbieMar 8, 20211 minExcel =SUM vs =SUBTOTALDo you know the difference between =SUM and =SUBTOTAL in Excel? Both provide totals, but when cells are hidden, the =SUM will provide the...
Go Ask DebbieFeb 2, 20212 minExcel 2019 and Office 365 New Function =CONCATMany people have recently, or will be in 2021, upgrading to Excel 2019 or Office 365. And, I’m personally excited for some of the new...
Go Ask DebbieJan 11, 20216 minExcel Data AnalysisData Analysis is all about telling a story so that someone can take action on the data.
Go Ask DebbieDec 5, 20202 minExcel Tutorial: Text to ColumnsI've had so many people over the years ask, "I have data in a text file, but need to put it into Excel to analyze the data and get...
Go Ask DebbieDec 1, 20201 minExcel Tutorial: Remove DuplicatesSince Excel 2013, removing duplicates has now become such an easy task, I wanted to share it with you. So, when would you need to remove...
Go Ask DebbieNov 25, 20203 minExcel Slicers - How to Use them and WhyDid you know that Excel Pivot Tables can do so much more than just show your data and sum or count it? Are you saying, "Debbie, what are...