562 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 Coffee Shop.xlsx file and create a new script.
Write code to loop through the collection of charts on the Analysis sheet and apply the following changes to each chart:
Set the style to 44.
Set the chart type to barClustered.
Set the height to 100 points more than its current height.
Run the script to see the effects.
Part of one of the charts.
Create a second script to loop through the collection of worksheets. For each sheet:
Check that its name is not Analysis.
Create a new columnClustered chart using the data in cells B3:E8.
Set the chart's position to cover cells B11:F25.
Change the chart's style to 44.
Run the script and make sure that each sheet contains a new chart.
Create a third script to loop through the collection of charts on each worksheet and delete each one.
Run the script and check that there are no charts left in the workbook.
Save and close the script and workbook.
25 Aytoun Street