We’ve shown you how to enhance your Google Slides presentation by adding animated transitions between slides. But maybe you want to animate text, images, or objects in addition or instead. Here’s how to add animations in Goog…
You can use the COUNT function and variations to count cells that contain numbers. But what if you want to count only the distinct values in a cell range? We’ll show you two ways to count unique values in Excel….
Do you have a document where you need to number the paragraphs? Maybe you want the numbers as reference points or are simply required to include them. We’ll show you how to number paragraphs in Microsoft Word….
When you enter numeric data into your spreadsheet, do you pay attention to how it’s formatted? Many times, numbers are formatted as text which can wreak havoc with formulas. Here are various ways to convert text to numbers in…
When you need to find a value’s exact position in your spreadsheet, you can use the MATCH function in Excel. This saves you from manually searching for the location that you may need for reference or another formula….
If you create slideshows often, whether for your company, charitable organization, or classroom, why start from scratch each time? You can import slides from other Google Slides presentations and reuse them….
Slide numbers in a presentation are helpful for referring to a particular slide, using a table of contents, or simply making the show more professional. We’ll show you how to add and remove slide numbers in Google Slides….
When you work with tables in Word, formatting the text inside is just as important as the rest of the text in your document. If you want a uniform look, we’ll show you how to center text in a table, either horizontally or ver…
With all of the tasks you can use Microsoft Excel for, one of the most popular is tracking finances. If you’d like to create a sheet to manage your budget, we’ll show you several basic functions you need….
You can not only make text stand out in your presentations but make it pop right off the screen. Using animations to highlight text is a great way to add some pizzazz to your Microsoft PowerPoint slideshow….
Counting how many cells contain numbers is a basic and useful task. With this in mind, Microsoft Excel gives you a handy function to save you from counting cells manually. The function is COUNT and here’s how to use it….
When you need to obtain a value that resides in a particular spot in your spreadsheet, you’ll want one of Excel’s lookup and reference functions. Here, we’ll show you how to find values by location with INDEX in Excel….
You can always set up another conditional formatting rule in Google Sheets for one set of cells exactly the same as another. But why do the extra work? Here are a few ways you can copy your conditional formatting….
If you use templates for quick starts on documents, reports, or spreadsheets, then you know their value as time savers. In Gmail, you can create your own templates to save time on those emails you send often….
There are many ways to make text stand out in your document. You can format the font in bold or italic or highlight the text using color. For another option, we’ll show you how to circle text in Microsoft Word….
People use all sorts of methods for organizing their inbox. One way is to move emails to specific folders, which in Gmail, are called Labels. So here, we’ll show you how to automatically label and move emails….
Using a pivot table, you can analyze large amounts of data easily. But as we all know, data can and often does change. To make sure that your data is current, here’s how to refresh a pivot table in Excel….
Adding numbers together in Microsoft Excel is a basic calculation that can use the SUM function. What if you want to add those values but only if they meet certain conditions? This is when the SUMIF function comes in….
Underlining seems like a simple enough task in Microsoft Word, but many times there’s more involved. You can underline words, spaces, words with spaces, and words without spaces. We’ll show you several ways to use underline i…
If you’re using Microsoft Excel for statistical data, you may need to find the range for a data set. Here we’ll explain a simple way to calculate range in Excel using formulas.
When you have a large sheet full of data, using the Google Sheets filter and sort features can help you find what you need. If you use color to make data pop, you can filter or sort using that color.
Calculating an average is one of the basic equations you might need in your spreadsheet. Google Sheets offers a few different ways to average numbers or cells.
Are you creating a Google Doc and have a PDF that you want to include? While there isn’t a straightforward way to insert a PDF in Google Docs, we have a couple of workarounds you can try.
If you use conditional formatting in Microsoft Excel to automatically format cells that match criteria, you may want to apply the same rule to another part of your sheet or workbook. Instead of creating a new rule, just copy …
Many things are easy and obvious on Apple devices. But every so often you come across something that isn’t. If you want to mark all your emails as read on iPhone, iPad, and Mac, and clear those indicators, here’s how….