Sparklines
IntermediateAdvanced
6 questions, about 11 minutes
With sparklines and conditional formatting you can see trends without a big chart.
What we'll do
- Inserting sparklines
- Data bars and colour scales
What you'll use
- The Excel menus
How it works
In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.
2examplesYou watch
6questionsYou do it yourself