Top Excel Tips

Top Excel Tips

I should not even be telling this story but here goes. My husband took an Excel course yesterday and came home all excited to share the tips he learned. Yes, I too wondered why he was taking an Excel course when he could ask me a question or better yet – read my blog...
Plotting Empty Cells

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...

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:...

Using TextJoin

          TextJoin() TEXTJOIN is a text function that was introduced in Excel 2016 to join text in cells together. Initially, you may think that the function is not that worthwhile. After all, we already have the ampersand (& ) as well as...