Calculating percentage is one of those things that make many people cringe. But if showing a percent in your spreadsheet is beneficial, we’ll show you a few easy ways to calculate a percentage and format it in Google Sheets….
If you’re a fan of using Markdown to format your documents, you’ll be glad to know you can use it in Google Docs. By turning on a simple setting, Docs recognizes Markdown so you can type, format, and keep going….
Counting the number of distinct values in a spreadsheet is valuable in many situations. Whether it’s customer names, product numbers, or dates, one simple function can help you count unique values in Google Sheets….
The Status Bar in Microsoft Excel allows you to quickly see the average, sum, or count of selected cells. But what’s better than viewing those values is being able to use them. Here’s how copy directly from the Status Bar….
A QR code is convenient for capturing information with a mobile device camera. You can scan a code to visit a website and get contact details. To make sharing simple, here’s how to create a QR code in Google Sheets….
Typing text in a Google Sheets cell is simple. But what if you want to edit that text to include more and apply it to multiple cells? Using a couple of different methods, you can add text using a formula….
If you want to move to a different slide or section in your presentation, you can easily add a link on your slide. But by using a Section or Slide Zoom in PowerPoint, you can make that move look professional….
Adding values in Google Sheets is easy enough to do using the SUM function. But what if you only want to add numbers that meet certain criteria? Using SUMIF in a Google Sheets formula, you can add the exact values you want….
An attractive image or company watermark can make a nice background for your presentation. But if you want to remove that background and use your own or none at all, you have two ways to do it in Microsoft PowerPoint….
Entering data in your spreadsheet is the basic principle behind using Excel. From adding the current date and time to looking up values to changing the letter case of your text, some functions can help you tremendously wit…
When you insert checkboxes in a spreadsheet, you may want to get a total count of those checked or unchecked. With a simple function and formula, you can tally your checkboxes in Google Sheets.
When you use Google Forms for surveys and other types of forms, viewing responses is important. If you have a document in Google Docs or Slides where you want to share those responses, you can simply embed the response chart….
When you want a list of customers, email addresses, product IDs, or something similar where each one is distinct, Excel has a function to help. We’ll show you how to use this function to list unique values and text….
Because of its functions and features, Excel is a great application for budgeting along with managing your money. If you already use it for finances, make your spreadsheet even more effective by calculating loan elements like…
While the VLOOKUP function is good for finding values in Excel, it has its limitations. With a combination of the INDEX and MATCH functions instead, you can look up values in any location or direction in your spreadsheet….
If you’re holding an event where you want participants to wear name tags, you can make them easily in Microsoft Word. We’ll show you two ways to create name tags using Word’s label feature and a free template….
Summarizing your document can be helpful to your readers. You can give a brief overview and call out important points. You don’t have to include this in your content because you can add a document summary in Google Docs….
You may have to print a two-sided booklet or simply want to save paper by printing on both sides. You can print double-sided in Microsoft Word on Windows and Mac whether you have a duplex printer or not….
Not every image in your slideshow has to be a plain rectangle or square. You might want to spruce up the presentation by giving your picture some shape. You can easily crop an image into a shape in Google Slides….
Functions in Excel aren’t just for numbers and calculations. You can use functions when working with text too. Here are several helpful Microsoft Excel text functions.
Headers and footers are useful tools for including information like the date, company name, or creator. This allows you to add extra details without distracting from your slideshow’s content. Here’s how to add a header or foo…
If you insert dates or times in your Google Sheet, you aren’t stuck with the default date formats. You can use the word for a month instead of a number or add seconds to the time by creating custom formats….
When you use images in your document, you might want to keep them together. This allows you to move them as a group and resize that group to fit your document better. Here’s how to group images in Google Docs….
Creating a table of contents in PowerPoint is one way to summarize your slideshow and move to certain slides easily. But another way that makes your presentation more dynamic is using a Summary Zoom slide….
By using comments in Microsoft Word, you can make notes to others or even yourself. But you may want to hide the comments so you can focus on the document’s content or delete those that no longer apply, here’s how….