Zoom in and out with ease with DigiTip 61! If you need to quickly zoom in or zoom out on your Windows computer, the easy shortcut for this is Windows Key and + to zoom in and then Windows Key and – to zoom out!
Since September 2023, the Digital Skills Team have been publishing weekly tips and tricks to help improve your Digital Skills one DigiTip at a time. So far, we’ve published 60 DigiTips from Microsoft shortcuts to digital wellbeing app suggestions!
We’ll be returning next week on Tuesday 29 April with a further 5 DigiTips, if you want to go back and look at previous DigiTips you can read them all from this webpage.
How can I follow the DigiTips?
If you want to keep up weekly with our DigiTips, there are a couple of different ways you can follow our DigiTips.
You can bookmark this webpage and a new DigiTip will appear here at 10am each Tuesday during term time (Read DigiTip 1 if you’re unsure how to bookmark a webpage).
We also publish each DigiTip on Facebook and Instagram pages which you can access from the icons below. From there, you can follow our hashtags #TipiauDigiPA#AUDigiTips
Have you ever struggled with presenting your PowerPoint online through sharing your screen? Did you know that you can present directly from PowerPoint to Teams? With DigiTip 60 – now you do!
When you’re in your meeting and ready to share your slides – simply select the “present in Teams” button in your PowerPoint and present!
Forgetting to stay hydrated while at Uni or work? This DigiTip is for you. Staying hydrated is a major part of wellbeing as it influences how much energy you have and helps you to stay focussed.
My Water has a free version which will send you notifications at set intervals reminding you to drink to reach your goal for the day. Alongside this you are also given statistics based on how you are doing for the week with your water intake. There’s also an Achievements page that shows what milestones you’ve hit and how to achieve more. When reporting what you have drank on the free version you are given the option of selecting water, coffee or tea which will return different amounts to your water progress based on the water balance of the drink.
Below are some screenshots from the app that show some of these features.
There is still just over a week until our subscription to LinkedIn Learning ends. If you have completed any training courses on LinkedIn Learning and wish to retain your certificate(s) of completion, you have just over a week to download them. You can view this short video for guidance of how to do this.
DigiTip 40: Get More Connected to Nature with Seek by iNaturalist 🔎🌼: You may come across birds, plants, fungi, and amphibians that you can’t identify. Using image recognition technology, the Seek by iNaturalist app will help you take your knowledge of nature to the next level!
DigiTip 4 – Increase your productivity whilst helping the planet with the Forest App 🌱: Do you want to increase your productivity whilst helping the planet? The Forest App will help reduce your procrastination and distractions whilst giving you the extra incentive to stay productive, by growing trees and earning virtual coins to unlock new plants depending on how long you have stayed productive for.
Wanted to count how many times a name appears in a column alongside other conditions in Excel? With DigiTip 57 we can show you the formula to get this done.
First you will need data similar to that shown in the screenshot where you have multiple columns of information where you want to count how much of a certain criteria exists such as names or dates for example.
To do this we are going to need to use the COUNTIFS function in the formula tab, this is shown in the screenshot below.
This takes the criteria range which in the example is the column of names and then the criteria itself which in the example would be the name Chris at E2. Also include in the example is another criteria range of the column of gifts and the criteria of Chocolate. This will then go through all the information and count only when these two criteria are met.
This could be useful on a larger scale for tracking any number of things that are happening on a spreadsheet.
Today we celebrate International Women’s Day! The 2025 theme is #AccelerateAction and is an important message that focuses on speeding up the achievement of gender equality. At its current rate it is predicted that we won’t achieve gender equality until 2158 and so this International Women’s Day calls for us to work together to create a more inclusive world. You can view the resources below inspired by International Women’s Day. These include a selection of LinkedIn Learning videos and courses, please note that the University’s subscription to LinkedIn Learning finishes on 28th March 2025. If you have completed any training courses on LinkedIn Learning and wish to retain your certificate(s) of completion, please view our previous blogpost to learn more about this.
Code First Girls: Code First Girls is a free online service that is partnered with Aberystwyth University and is dedicated to providing coding courses to help women and non-binary people develop their coding skills.