In cell I3, we want to tell Excel to look in Table ... you want to impress your friends and colleagues, you can make an Excel ...

An curved arrow pointing right. Sparklines are word-sized charts that live in individual cells. This great feature was added to Excel in 2010 but still remains massively underutilized. Produced by ...

Of course, you can do the same on a cell from the end of a row. For instance, I used the =AVERAGE(LEFT) formula to calculate the average number on a row. A great Excel feature is creating charts ...