557 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 Capital Cities.xlsx file and create a new script.
Loop through the collection of worksheets and create a table from the list of countries and cities on each one.
Each worksheet should have a table.
Create a new script which loops through the collection of tables in the workbook. Apply a filter to each table to show rows where the capital city is blank. Use the code below as a guide:
let cityFilter = tbl.getColumn("Capital City").getFilter();
Run the script to filter each table.
The filtered table on the Europe worksheet.
Create one more script to clear the filter from the Capital City column for each table in the workbook.
Save and close the script and workbook.
25 Aytoun Street