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