In the past, if you ever wanted to tweet the animated Live Photo captured by your iPhone or iPad, you had to convert the image to a GIF. That’s now a thing of the past, as Twitter will do the conversion for you automatically!
[mai mult...]How to Record Voiceover Narration in PowerPoint
If you’re sending out your presentation instead of giving it in front of an audience, but you feel adding a vocal explanation would better help to deliver the message, record a voiceover narration. Here’s how to do it.
[mai mult...]How to Count Blank or Empty Cells in Google Sheets
When you’re analyzing data in a spreadsheet, counting empty or blank cells could help you focus on specific areas. This is why functions like COUNTBLANK, COUNTIF, COUNTIFS, and SUMPRODUCT are so important in Google Sheets.
A word of warning, however. If you have a cell that contains an empty text string (“”) or has a formula that returns a similar result, this cell would be blank, but it wouldn’t technically be empty. If you want to know the number of truly empty cells, you’ll need to use a combination of the SUM, ROWS, COLUMNS, and COUNTIF functions.
[mai mult...]How to Save an Email to Your Hard Drive
Emails normally stay in your email program, but occasionally you might need to keep a copy as an offline backup. Here’s how to save an email to your hard drive so it’s always available and accessible.
[mai mult...]How to Use Google Slides Animated Transitions
Fade, dissolve, slide, cube, or flip. Spice up your presentations with transitions between slides and add visual effects to animate text, images, and other objects in Google Slides. Here’s how to use transitions and animations in slides.
Fire up your browser, head to Google Slides, open a presentation, or upload an existing PowerPoint presentation.
[mai mult...]How to Convert Live Photos to Videos or GIFs on Your iPhone
Live Photos on iPhone capture one-and-a-half seconds of video before and after you tap the shutter button. If you want to share your Live Photos with almost anyone, you can convert them to a video or GIF.
[mai mult...]How to Update Your Apple Watch
Apple routinely releases watchOS updates with new features and watch faces. watchOS 6, for example, comes with a new App Store app and awesome new analog watch faces. Here’s how you can update your Apple Watch.
[mai mult...]
How to Count Data Matching Set Criteria in Google Sheets
The COUNTIF function in Google Sheets lets you analyze data in your spreadsheet and returns the number of times it appears in your document if it meets a set of specific criteria. Here’s how to use it.
[mai mult...]How to Connect Your Android Device to a Projector
Android devices are great, but their small size can sometimes be limiting. When you connect your device to a projector, you can share your screen with others for business or pleasure. Here are a few ways to do it.
If you don’t have a projector, you can also connect Android to a TV. Projectors are the better option, though, as they normally project a much bigger screen size than a TV, making them ideal for media playback or data presentations.
[mai mult...]How to Assign Tasks in Google Drive
When collaborating on files in Google Drive (Docs, Sheets, and Slides), it’s easy to lose sight of who’s working on specific parts of a project. With Google Drive, you can assign tasks to another collaborator on your team.
Fire up Google Drive and open a file you currently collaborate on with other people.
[mai mult...]