How to Count Blank or Empty Cells in Google Sheets

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 Use Google Slides Animated Transitions

Google Slides Header

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 Connect Your Android Device to a Projector

The Chromecast "Mirror Device" screen on Android.

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

Google Drive Logo

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...]

How to Change the Default Shell to Bash on macOS Catalina

Terminal window on a macOS Catalina desktop.

With macOS Catalina, Apple is now using Zsh as the default shell. We love Zsh, but the trusty old Bash shell is still included with macOS, and you can quickly switch back to Bash if you prefer.

Zsh is only the default shell on newly created user accounts, so any existing accounts you have on an upgraded  Mac will still use Bash by default unless you change it. Each user account has its own default shell preference.

[mai mult...]