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 WODA Application.xlsx file. The aim of the exercise is to copy the new values from Sheet1 to the end of the list on Sheet2.
You can enter your own details if you prefer.
To do this, create a new script and write an instruction which:
Refers to cell A1 on Sheet2 then uses the getRangeEdge and getOffsetRange methods to find the next blank cell in column A.
Applies the copyFrom method to this cell.
Uses the getExtendedRange method to reference the column of values starting in cell C4 on Sheet1.
Transposes the copied cells from a column to a row.
Run the script and check that the details were copied to the appropriate place:
The new row should appear at the end of the list on Sheet2.
Add an instruction which clears the cells on Sheet1 that you copied the details from.
Save the script and workbook then close them both.
25 Aytoun Street