Want to remove all the blank rows from your dataset? If so, Microsoft Excel offers both automatic and manual methods to let you clear the blank rows and shift your data up. Here’s how to use those ways….
For quick access to a cell, document, or webpage, you can insert hyperlinks in your Excel spreadsheet. Just paste in a hyperlink, give it a readable label, and click to follow the link. Here are a few ways to insert hyperlink…
Using Quick Steps in Microsoft Outlook, you can click a button to run one or more automated actions on an email you select. While Outlook gives you some handy premade Quick Steps, you may want to create your own….
Microsoft Excel offers hundreds of functions. So, there’s bound to be at least a handful you don’t know exist. These unique functions have specific purposes that you’ll be thrilled to learn about and use….
Excel offers its own built-in linking feature in the toolbar. But the HYPERLINK function lets you do more, like a link to a workbook on your company intranet, shared server, another drive, or even a bookmark in a Word documen…
If you’ve never spent time using Microsoft Excel, it can feel a bit overwhelming at first. We’ll teach you the basic tasks you need to know to use this popular spreadsheet application.
Microsoft Excel offers a built-in filter feature along with the option to use an advanced filter. But if you want to filter by multiple criteria and even sort the results, check out the FILTER function in Excel….
Don’t have a health tracker that you can strap on like a Fitbit or even an Apple Watch? You can still effectively log fitness, nutrition, diet, blood sugar, and other health details using an app you probably have on your comp…
Amid all the CES news, Microsoft is also pushing some helpful updates for its Microsoft 365 suite of programs. Excel’s Automate tab is now finally available on the desktop versions of the beloved spreadsheet app….
If you have a chart where you’re plotting different types of data or the values vary, consider adding a second axis for easier viewing. We’ll show you how to painlessly create a two-axis chart in Excel….
It’s easy to sort data in Excel alphabetically or numerically. But maybe you want to sort based on color, formatting, or a list like months of the year. We’ll show you different ways to sort data in Excel….
While Microsoft Excel offers a built-in feature for filtering data, you may have a large number of items in your sheet or need a more complex filter. Here, we’ll explain how to create an advanced filter in Excel….
When you make a graph in Excel, you may want to include the source data with it. By adding a data table, which takes just a few steps, you can provide extra details or further explain your visual.
When you have a spreadsheet packed with data, finding the number you need can be tedious. Yet, whether you’re looking for the lowest product sales amount or the highest test score, Excel’s SMALL and LARGE functions can help…
When you create an Excel chart that contains a ton of data, it can be difficult to decipher it all at a glance. One helpful way to point out information is using data labels for a series of data points. We’ll show you how to …
Unhiding all the rows in a Microsoft Excel spreadsheet is as easy as pressing a keyboard shortcut or using a button on the ribbon. We’ll show you how.
When you use Excel on the web, do you notice that your workbook takes a long time to load? Microsoft seeks to help you solve this problem with Check Performance. Here’s how it works.
Microsoft Excel is full of useful features, including those for performing calculations. If there comes a time when you need to multiply two columns in Excel, there are various methods for doing so. We’ll show you how to mult…
When you want to test your data and receive a simple True or False result, the IS functions in Excel are just what you need. You can check for blank cells, errors, text, numbers, references, and more quickly and easily….
No matter what you use Excel for, whether business financials or a personal budget, the tool’s data analysis features can help you make sense of your data. Here are several Excel features for data analysis and how they can he…
If you want to share data from Excel without sharing the Excel file, you can export a selection of cells or the entire workbook as a PDF. The result is a super handy document you can share any way you want….
If you use Excel to create a checklist, you may want to count the number of checked or unchecked boxes. With a simple formula, you can tally them in a cell that adjusts as more boxes are marked or unmarked….
While Microsoft Excel offers a built-in tool for sorting your data, you may prefer the flexibility of a function and formula. We’ll show you how to use the Excel SORT function with helpful examples.
Obtaining subtotals for groups of related items is easy in Microsoft Excel. In fact, you have two ways to do this. You can either use the SUBTOTAL function or the Subtotal feature, whichever works best. We’ll show you how….
Do you see something unusual in your Excel spreadsheet? Wondering how the change may have happened? Whether you’re working with others or alone on an Excel sheet, there’s a simple way to see the changes that take place….