Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
551 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers 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
Search our website
We also send out useful tips in a monthly email newsletter ...
You are welcome to try any of the 21 OfficeScripts exercises listed below, but please do not distribute them in any form without asking for our written permission first.
Software: | OfficeScripts |
Topic: | Referring to ranges |
Level: | Relatively easy |
Exercise: | Change formatting properties of ranges using various methods. |
Software: | OfficeScripts |
Topic: | Referring to ranges |
Level: | Relatively easy |
Exercise: | Enter data into cells and apply a custom date format. |
Software: | OfficeScripts |
Topic: | Referring to ranges |
Level: | Relatively easy |
Exercise: | Fill in the gaps in a list of capital cities. |
Software: | OfficeScripts |
Topic: | Referring to ranges |
Level: | Average difficulty |
Exercise: | Copy a range to the end of an existing list using getRangeEdge, getOffsetRange and getExtendedRange. |
Software: | OfficeScripts |
Topic: | Referring to ranges |
Level: | Average difficulty |
Exercise: | Use the getOffsetRange method to navigate a maze. |
Software: | OfficeScripts |
Topic: | Variables |
Level: | Average difficulty |
Exercise: | Use variables to find and calculate new values in a list of dinosaurs. |
Software: | OfficeScripts |
Topic: | Functions |
Level: | Relatively easy |
Exercise: | Create a function in Office Scripts to convert metres to feet and inches. |
Software: | OfficeScripts |
Topic: | Functions |
Level: | Average difficulty |
Exercise: | Create functions in Office Scripts to validate user inputs. |
Software: | OfficeScripts |
Topic: | Conditional statements |
Level: | Relatively easy |
Exercise: | Use if statements in Office Scripts to control the selection of cells in an Excel workbook. |
Software: | OfficeScripts |
Topic: | Conditional statements |
Level: | Average difficulty |
Exercise: | Use if statements to validate a set of user inputs and verify the existence of objects in a workbook. |
Software: | OfficeScripts |
Topic: | Loops |
Level: | Relatively easy |
Exercise: | Use Office Scripts to loop through a collection of worksheets and tables in a workbook. |
Software: | OfficeScripts |
Topic: | Loops |
Level: | Average difficulty |
Exercise: | Loop through the charts and worksheets collections in Office Scripts. |
Software: | OfficeScripts |
Topic: | Loops |
Level: | Average difficulty |
Exercise: | Use a for loop in Office Scripts to work through a list and apply formatting to rows meeting a condition. |
Software: | OfficeScripts |
Topic: | Loops |
Level: | Average difficulty |
Exercise: | Use a while loop in Office Scripts to follow the instructions in each cell. |
Software: | OfficeScripts |
Topic: | Loops |
Level: | Average difficulty |
Exercise: | Use a while loop in Office Scripts to process a list and apply formatting to each row. |
Software: | OfficeScripts |
Topic: | Loops |
Level: | Average difficulty |
Exercise: | Use nested for loops in Office Scripts to check a range of cells contains only negative numbers. |
Software: | OfficeScripts |
Topic: | Loops |
Level: | Harder than average |
Exercise: | Loop through various collections using Office Scripts to create a summary worksheet. |
Software: | OfficeScripts |
Topic: | Arrays |
Level: | Relatively easy |
Exercise: | Use basic array techniques in Office Scripts to work with a list of pizza toppings. |
Software: | OfficeScripts |
Topic: | Arrays |
Level: | Average difficulty |
Exercise: | Use an array in Office Scripts to check the values of a range of cells. |
Software: | OfficeScripts |
Topic: | Arrays |
Level: | Average difficulty |
Exercise: | Use arrays to calculate new values for an Excel list. |
Software: | OfficeScripts |
Topic: | Arrays |
Level: | Harder than average |
Exercise: | Use an array to capture and manipulate areas of special cells in Office Scripts. |
You can search our full list of Office Scripts exercises here. Or why not learn to do them the right way on one of our Office Scripts training courses? You can attend our online training classes wherever you are in the world!
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.