Are you looking to make your PowerPoint presentations more interesting? But you’re not sure where to start? Why not use PowerPoint’s ‘Designer’ feature. The Designer feature presents generated ideas to make your slides look more interesting. View the short video below for a quick demonstration.
Before we move into the new academic year and into a new batch of DigiTips – weekly blogpost to highlight a useful tip that you can use to make your daily digital life easier – let’s look back on our most popular DigiTips from 2024/25!
Have you ever been in an MS Teams meeting where you’ve needed to send a quick list that’s easy for others to read? There are actually two quick ways to create bullet points or numbered lists in any MS Teams chat.
There may be times when someone has sent you an email, and you’d like to acknowledge its receipt without sending another reply. A great feature to use in this case is the reactions feature in Outlook, which works similarly to those in MS Teams or on various social media platforms.
Teams has a useful search function, but it can sometimes produce too many results. To save you unnecessary time searching, you can utilise filters.
These filters allow you to search using specific criteria such as date, sender, and file type, helping you to quickly pinpoint the information you need!
If you have ever begun writing a sentence and realised, you were in the wrong case – this DigiTip is for you! Did you know that you can change the case of your word in Office 365 by selecting the text and then using Shift + F3?
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.
Swap out typing for talking with DigiTip 65 and Microsoft Word’s Dictate tool. On Microsoft Word there is the option to dictate by either clicking the microphone button or using the shortcut Alt and +. This means that you can talk, and Microsoft Word will type for you!
Take your spreadsheets to the next level with DigiTip 64. Did you know that you can change the direction of text on your spreadsheets. This can help if your spreadsheets are becoming text heavy, especially headings. View the short video below to learn how!
With DigiTip 63, learn how to insert tags into your pages on OneNote. Tags are small emojis such as checkboxes to help you keep track of what’s important in your OneNote pages.
Do you want to perfect your presenting skills before your next big presentation? With DigiTip 62 and PowerPoint’s Presenter Coach you can get feedback while you practice! Simply follow these steps:
In your PowerPoint go to ‘Slide Show’ then ‘Rehearse with Coach’.
Run through your presentation as usual
Once finished – receive your personalised feedback summary of statistics on what you did well and how you can improve!
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!
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.