556 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.
Open the file contained with the folder name shown above.
Create a new pivot table on a new worksheet to show the following:
Show just the site type in the rows and a count of Days til next check as the values.
Right click on any of the pivot table numbers and use the Show Values As short-cut menu option to show the figures as % of Grand Total instead:
This should give these figures.
Now use the same menu option to show the percentage difference from the mixed playground type figures:
Everything is being compared to the base figures of the Mixed figures.
Rename the sheet tab to Using Show Values As.
Create another new pivot table of the playground data on another new sheet. We want to show a percentage frequency table:
We want to create a frequency table like this that shows how many of our playgrounds fall in each sub-category of number of days till the next check, so that we can plan our staffing levels accordingly.
This time begin with a very weird pivot table as shown below:
Add Days til next check in the rows and the values so you get 2 identical columns next to each other as shown here.
Change the Sum of Days til next check field to use the Count function instead.
Click on a single value in your row labels in column A and ask to group:
Change the values in the dialog box so that your Starting at value is below or equal to your minimum value, and the Ending at value is above or equal to your maximum value. Decide on the increment By value also.
Rename the sheet tab to Frequency Pivot and then choose Save As... to save the file in your own new Excel work folder.
You can find other training resources for the subject of this exercise here:
25 Aytoun Street