564 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
Using the Excel file in the above folder create a chart, a slicer and apply a page filter. The results should look something like this:
Wouldn't it be nice to have a message box saying which filters had been applied?
From the Home tab choose Quick Measure, then from the bottom of the list choose Concatenated list of values:
All the values in the Field column will be concatenated. The Number of values before truncation box indicates how many are listed before returning etc.
Repeat this for all the columns you have used for filtering, and then insert the newly created measures into cards:
What would be slightly nicer is having them in one card together, but there isn't a quick measure to do this.
From the Home tab choose New measure and concatenate the two previously created measures together:
The UNICHAR(10) returns a line break, so the filters will be listed on two lines.
Put this in a card to create a new dynamic title:
The final title shows all of the filtering and slicing choices that you have made.
Optionally save your report as Helpful headlines then close it down.
25 Aytoun Street