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.
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.
Struggling to focus when you’re trying to get work done? DigiTip 55 has what you are looking for with focus mode in Windows 11. Focus mode is a new feature for Windows 11 that has multiple features to help you try to concentrate on your work. These include: a timer that can be set to whatever time you need with the default set to 30 minutes, hiding the badges on taskbar apps, hiding the flashing on taskbar apps and turning on do not disturb.
To use this feature, you need to go to Setting -> System where you should see Focus. Once the options are selected as how you want them you just need to click ‘start focus session’ and a timer should appear in the corner of your screen which you can cancel or pause at any time.
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.
First Open up PowerPoint
Then create two slides, one with normal text and in the following slide split up the letters of the word across the slide. I did this by using multiple text boxes.
On the second slide go to the transitions tab and choose morph
Then still on the transitions tab go to effect options and choose characters
From there press F5 or go to the slide show tab and click on from beginning where you should now by pressing space see the morph transition take place.
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