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
546 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 ...
Software ==> | Power Automate Desktop (18 exercises) |
Topic ==> | Working with Excel (3 exercises) |
Level ==> | Relatively easy |
Subject ==> | Power Automate and PAD training |
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:
Action | Notes |
---|---|
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:
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.