Plotting Empty Cells
I received a call from my daughter yesterday. She was totally frustrated as she was trying to plot data for a class project that contained a lot of empty cells. I told her how to fix it and then learned that these suggestions would not work on a MAC. As I helped her...
Find & Select Constants
I just discovered this little timesaver and thought I would share it with you. Okay, to be honest, my husband told me about it. Suppose you have an Excel spreadsheet and you have a number of product codes all in one row and need to break them out. You can do text to...
What is a Pivot Table?
I have had a couple of people ask me what a pivot table is so I made a short video that walks you through the basics. One key bit of information that I left out of the video is that if your underlying data changes, all you have to do is right-click the pivot table and...New Excel Functions Coming!
New Functions in Excel I just read a tweet from David Ringstrom and Joe McDaid about dynamic arrays and new Excel functions that are coming soon. Truly amazing and a huge time saver for many. Check out this article which shows how each of the formulas works:...