How to Remove Blank Rows in Excel
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….
3 Ways to Insert Hyperlinks in Microsoft Excel
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…
Save Time in Outlook With These 6 Custom Quick Step Examples
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….
11 Little-Known Excel Functions That Are Very Useful
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….
6 Uses for the HYPERLINK Function in Microsoft Excel
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…
Excel for Beginners: The 6 Most Important Tasks to Know
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.
How to Use the FILTER Function in Microsoft Excel
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 Wearable? Track Your Health 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…
Microsoft Excel’s Automation Tab Is Now on Mac and Windows
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….
How to Add or Remove a Secondary Axis in an Excel Chart
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….
7 Ways to Sort Data in Microsoft 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….
How to Use an Advanced Filter in Microsoft 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….
How to Use a Data Table in a Microsoft Excel Chart
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.
How to Find the Smallest or Largest Number in Microsoft Excel
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…
How to Add and Customize Data Labels in Microsoft Excel Charts
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 …
How to Unhide All Rows in Excel
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.
How to Optimize Workbook Performance in Excel for the Web
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.
How to Multiply Columns in Microsoft Excel
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…
How to Use the IS Functions in Microsoft Excel
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….
7 Excel Data Analysis Features You Have to Try
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…
How to Export a Cell Range or Excel Workbook as a PDF
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….
How to Count Checkboxes in Microsoft Excel
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….
How to Use the Microsoft Excel SORT Function
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.
How to Use the SUBTOTAL Function in Microsoft Excel
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….
How to Show Changes in Microsoft Excel on Desktop
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….
