How-To
How to Find Circular References in Microsoft Excel
There’s no point going around in circles with your data. In Excel, any attempt to create a loop with your...
Microsoft Excel
How-To
Name Box in Excel: All You Need to Know
Not many Excel users name their cells, constant values, or formulas inside the worksheet. However, there’s a purpose to Excel...
How-To
How to Remove Unwanted Spaces from Excel Spreadsheets
When you import data into Microsoft Excel or have more than one person working on a sheet, you can easily...
How-To
How to Unhide the First Column or Row in Excel Worksheets
Hiding cells in Microsoft Excel is handy when you want to focus on a certain portion of your spreadsheet. However,...
How-To
How to Use the Square Root (SQRT) Function in Excel
Square Root is a common yet very useful mathematical function found in Excel. Here is a quick look at its...
How-To
How to Freeze Rows and Columns in Excel
Freezing certain rows and columns can help you reference key values while working on other parts of your Excel spreadsheet....
How-To
How to Count Colored Cells in Excel Sheets
Colored cells in Microsoft Excel can help you organize data, track changes, and make it easier to read. For example,...
How-To
How to Calculate Standard Error in Excel
Microsoft Excel is an excellent tool for storing and analyzing data. It offers a wide range of statistical tools and...
How-To
How to Add or Subtract Dates in Excel
Whether you’re tracking project timelines, managing financial data, or planning events, the ability to add or subtract dates in Excel...
How-To
How to Print Excel Worksheets with Gridlines
Because they don’t print by default, we’ll show you how to print Excel worksheets with gridlines using both the desktop...
How-To
How to Create a Waterfall Chart in Microsoft Excel
The easiest way to visually review information that shows gains or losses over time is to use a waterfall chart....
How-To
How to Create a Heat Map in Excel
If you have data that you want to display graphically, but a chart isn’t quite right, try a heat map....
How-To
How to Use Power Query to Edit Text in Microsoft Excel
There’s more than one way to make text edits in Microsoft Excel. From changing letter case to adding a prefix,...
How-To
How to Add and Customize Borders in Microsoft Excel
One of the best ways to display your data with emphasis or clarity is to add borders in Excel. You...
How-To
How to Start a New Line of Text in Microsoft Excel Cells
Microsoft Excel often requires more than just numbers and brief text entries. At times, you may need to fit detailed...
How-To
How to Add or Remove a Secondary Axis in Microsoft Excel Charts
When you have a chart with mixed data types or a dataset that varies broadly between series, consider using a...
How-To
How to Share or Save Excel Workbooks Without Formulas
Want to share a Microsoft Excel worksheet without including formulas, comments, and other cell attributes? This tutorial highlights two ways...
How-To
How to Use the FILTER Function in Microsoft Excel
The FILTER function in Microsoft Excel is one of the most crucial functions to master. Without it, you will have...
How-To
How to Fix #NUM! Errors in Microsoft Excel
Understanding and resolving #NUM errors in Excel is more than a troubleshooting task; it’s an essential skill for anyone working...
How-To
How to Use the Quick Analysis Tool in Microsoft Excel
The Quick Analysis Tool transforms the way you handle data analysis in Excel. This Microsoft Excel feature gives you easy...
How-To
How to Use and Customise the Status Bar in Microsoft Excel
Excel’s status bar is one of the hidden gems (and an unsung hero) that makes it the default spreadsheet software...
How-To
How to Fix #VALUE! Error in Microsoft Excel
If you’re often working with formulas in Microsoft Excel, you’ve probably encountered the #VALUE error. This error can be really...
How-To
How to Combine First and Last Name in Microsoft Excel
Typically you combine first and last names in Microsoft Excel using different cells and columns. But what if you need...
How-To
How to Bolden Lines in Microsoft Excel
If you want to learn how to bolden lines in Excel, we’ll show you how to add bold border lines,...
How-To
How to View Excel Files Version History (And Restore Previous Versions)
Did you know that you can view and restore previous versions of workbooks using the version history in Excel? From...
