10 must-have Excel skills everyone should know: 📊
Sparklines:
One of my personal favorites.
Sparklines allow you to insert miniature graphs inside an individual cell to easily visualize data.
•Select range
•Insert ⇢ Sparkline
• Choose type
People Graph:
I'm a big fan of visual representations of data.
Using 'People Graph' is an easy way to liven up your spreadsheet, especially when tracking metrics related to, well, humans.
Create an infographic to visualize social media engagement, app users, customers, & more.
Tables:
If you're not using tables in Excel, you should be.
• Clean formatting
• Auto-expand as new data is added
• Total row quick and easy data summaries
• Formulas carry through entire columns
• Create dynamic charts that update automatically & much more.
Here's how:
Slicer:
Now that you're using tables, let's insert one of my favorite filtering tools.
The Slicer
•Click anywhere inside a table
•Go to table ⇢ insert slicer
•Select the fields you want
A dialog box will appear.
Click any slicer button & data is filtered accordingly.