Sometimes, it can be a pain swapping from different headings in Word but with DigiTip 58 it doesn’t have to be a pain anymore!
Use the simple shortcut: Ctrl + Shift + S to easily swap between all the different heading styles available in Word.
To follow our DigiTips, subscribe to our Digital Skills Blog. Or alternatively, you can bookmark this webpage, where a new DigiTip will be added each week!
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.
To follow our DigiTips, subscribe to our Digital Skills Blog. Or alternatively, you can bookmark this webpage, where a new DigiTip will be added each week!
If you want to take your presentations to the next level you could try inserting a cameo, learn how with DigiTip 56!
A cameo is a recording of yourself talking through your slides and presenting your PowerPoint.
You can view how to do this through the video below.
To follow our DigiTips, subscribe to our Digital Skills Blog. Or alternatively, you can bookmark this webpage, where a new DigiTip will be added each week!
In 2024, our Student Digital Champions conducted interviews with eight Aberystwyth University graduates to understand what skills they now use after graduating and skills that they wished they had learnt and developed while at university. Below are the top five skills across all the profiles that the graduates now use and how you can develop these skills:
If you would like to read the Graduate Digital Skills Profiles, you can view them here or you can download them here.
Do you want to make your PowerPoints more Dynamic? DigiTip 53 Will help you to do that by using a transition in PowerPoint called Morph which can give more flow to a PowerPoint by giving smooth transitions to shapes and text changing in the slides.
To follow our DigiTips, subscribe to our Digital Skills Blog. Or alternatively, you can bookmark this webpage, where a new DigiTip will be added each week!
Have you ever wanted to cross something out in Excel? Sometimes you don’t want to delete or hide the cells. DigiTip 52 has a quick shortcut to help you out!
Simply select the relevant cell(s) and use the shortcut: Ctrl + 5
To follow our DigiTips, subscribe to our Digital Skills Blog. Or alternatively, you can bookmark this webpage, where a new DigiTip will be added each week!
Do you want a faster and more efficient way to navigate MS Teams, for example to let your colleagues know your status on Teams or send a message? DigiTip 51 can show you quick commands to do just this. For this DigiTip we will be using the forward slash commands in the search bar on Teams.
To follow our DigiTips, subscribe to our Digital Skills Blog. Or alternatively, you can bookmark this webpage, where a new DigiTip will be added each week!
Would you like to advance your note taking but you’re stuck on a format? With DigiTip 50 and page templates in OneNote you can do just that!
Microsoft OneNote has the option to insert page templates to help you format your notes. There are templates from simple lecture notes to project overview to prioritised to do lists. Watch the video below to find out more!
To follow our DigiTips, subscribe to our Digital Skills Blog. Or alternatively, you can bookmark this webpage, where a new DigiTip will be added each week!
Do you want to add interesting ways of presenting your data in MS Excel? DigiTip 49 can help with that by introducing Sparklines. Sparklines are small graphs that only take up one cell in an excel sheet and are an effective way of presenting data without having a graph that takes up a whole sheet. This could be useful for presenting data that is important but not vital to a presentation.
To follow our DigiTips, subscribe to our Digital Skills Blog. Or alternatively, you can bookmark this webpage, where a new DigiTip will be added each week!
Time to learn a new shortcut with DigiTip 48!
An easy shortcut to selecting an entire row in Excel. Simply be in the row you’d like to select and use the shortcut: Shift + Space bar.
To follow our DigiTips, subscribe to our Digital Skills Blog. Or alternatively, you can bookmark this webpage, where a new DigiTip will be added each week!
