Excel Tip – 3 Different Count Functions

Have you ever wanted to know how many entries were in a list in Excel? You can use the Count functions to give you an accurate number. The first Count function only counts cells that contain numbers. Will ignore any cell that has text in it    =COUNT(A2:A24) The...

Excel Tip – Very Tiny Charts

In Excel there will be occasions where you would like to show the trend of data, but have no room for a chart. There is a feature in Excel that can solve your problem . . small charts that fit into one cell! They are called Sparklines, which include line charts and...