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.
The aim of this exercise is to create your very own personalised Excel workbook:
This file should not only bear your name, but also have it typed into cell A1 (everyone likes to see their name in ... cells).
Create a new flow (called It's all about me). Start by using an input dialog to capture your user's name in a variable called PersonName (no need to capture the button chosen though):
Your input dialog should ask for someone's name, and store this in a variable.
Now add actions as follows:
|Launch Excel||Start Excel with a blank worksheet.|
|Write your name||Use the Write to Excel worksheet action to write the PersonName variable to the active cell (for a new workbook this will be A1).|
|Save your file||Use the Save As option for the Save Excel action to save your workbook using the name PersonName (see below this table for how to do this).|
|Close Excel||At this point you can close Excel without saving any changes (since you've just saved your workbook).|
|Display a message||Use a Display message action to show a reassuring message saying that you now have a new file bearing your name.|
Here are the Save Excel action parameters that you can use:
You can build up a suitable document path based on the value of the variable called PersonName.
When you've written your flow, test that it works.
Don't be too ambitious! Your flow will crash if you choose the Cancel button at any point, or if your name happens to contains any special characters which can't form part of a file name.
Check that you have only created two variables:
You should only have one variable for the Excel instance you opened, and one to hold the name of the person.
Save your flow and then close it!
You can find other training resources for the subject of this exercise here:
25 Aytoun Street