There are plenty of fonts to choose from these days. You’ve got the fonts pre-loaded on your device, plus a huge selection available online. Which font should you use? Let’s start with the fonts you shouldn’t use….
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.
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 …
You can perform basic mathematical operations in Excel, including multiplication. You can multiply numbers in a single cell, from several different cells, or even an entire column. There’s no MULTIPLY function in Excel, so w…
Excel makes it easy to perform basic math operations, which includes division. You can divide numbers in a single cell, from multiple cells, or even entire columns. Since there’s no DIVIDE function in Excel, you’ll need to us…
It’s easy to make a PDF file but editing one requires special tools. If you’re looking to add or remove text, insert images, or make any other changes to your PDF files, here are your editing options.
Using Microsoft Excel’s AutoFit feature, you can ensure that your content in your cells is always fully visible (without being cut off). Here’s how to use this option for specific rows and columns, and for your entire workshe…
It’s easy to improve the appearance of your Microsoft PowerPoint slideshow by including an attractive background. You might use a color, gradient, or pattern, or insert an image. Another way to make your background appealing …
If you’re participating in a group or one-on-one chat in Microsoft Teams that you no longer want to be a part of, you can delete it. There are some limitations to deleting Teams chats, though, as we’ll outline below….
If you have a lengthy presentation, keeping it organized is important. One way to do this in Microsoft PowerPoint is to use sections. We’ll show you what they are and how you can make use of them.
Using slicers, you can filter data and always see what’s being filtered in your Microsoft Excel spreadsheets. You can add a slicer for each field you want to filter, and we’ll show you how to do that.
Drop-down lists in Excel make for a simplified way to enter data, but sometimes you may need to edit that list. You can add or delete items from your drop-down list regardless of how you created it.
Whether you’re sending an Apple Numbers file to a Microsoft Excel user or are on the receiving end of a Numbers workbook you need to open as an XLSX file, we’ll show you three ways to convert Numbers to Excel….
Managing a spreadsheet is about more than just the data in it. You may want to add a title or apply shading to alternate rows. Another basic part of formatting an Excel spreadsheet is to add or remove columns and rows….
With a linked table of contents in Microsoft PowerPoint, you or your collaborators can jump to a particular slide or custom show in your presentation. You can also insert an unlinked table of contents for an overview of the s…
Microsoft Excel provides you with gridlines on each spreadsheet in a workbook by default. However, the gridlines might be too faint on your screen. If you’d like to make the gridlines darker in Excel, we’ll show you how….
Some tasks for taking care of data in Excel are intuitive, like inserting currency. Then there are others that are not, like combining columns. We’ll show you a few different ways to merge two columns in Microsoft Excel….
Looking for a tool to track items for yourself or your small business? A version of Microsoft Lists is opening up to everyone outside of the Microsoft 365 umbrella. All you need is a Microsoft account and something to manage…
Are you managing a small project or tasked with creating a timeline for one? Without extensive tools like a Gantt chart or expensive software like Microsoft Project, you can create a simple project timeline right in Microsoft…
The next time you download a Microsoft Office file, you’ll have one less thing to worry about, as Microsoft is blocking Visual Basic for Applications (VBA) macros by default in downloaded files.
In your Microsoft PowerPoint presentations, you can change your slides’ background to a picture, solid color fill, gradient fill, texture fill, and even pattern fill. You can apply a custom background to all or select slides …
Have you ever accidentally moved an item in your slide and then had to spend time putting it where it was? In Microsoft PowerPoint, you can lock an object in position. This prevents those mistaken moves and wasted time….