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