Sometimes a refresher on tips and tricks is a very good thing. We get stuck in our rut of how we use apps and how we process data. Here are some of my favorite Excel tips.
- Add a Total Row without writing a formula. Just click anywhere inside an Excel table. Then press Ctrl+Shift+T and Excel will add the Total Row to the bottom.
- Select any cell in your data range and press Alt+F1. Voila! You now have a chart!
- The Status Bar shows averages, counts, and sums — without typing out complicated formulas! Just select some cells in your table, and then gaze your eyes on the lower right-hand corner of the Excel window. There you’ll see instant stats about your selection. See below.
- Select any range in a table or PivotTable, and go to Insert > Slicer. Select the column you want to filter by. When you’re done, you’ve got handy buttons that let you filter.
Try these tips to make Excel more fun.