How-To
How to Copy and Paste Formulas in Microsoft Excel
Along with the powerful formula features available in Microsoft Excel is the ability to reuse formulas without having to retype...
Microsoft Excel
How-To
How to Count Characters in Microsoft Excel Cells
Counting characters in an Excel cell is a lot easier than you might think. With a few simple formulas, you...
How-To
How to Add Minutes to Time in Microsoft Excel
If you want to add minutes to a time notation in Microsoft Excel, there are several ways to do it,...
How-To
How to Copy Cell Formatting in Microsoft Excel
Formatting your Excel worksheet is an important step in making your work presentable. Microsoft Excel offers you several ways to...
How-To
How to Alternate Row and Column Colors in Microsoft Excel
Alternating the colors of rows and columns in Excel, also known as banding, is one way to make the document...
How-To
How to Mail Merge from Excel to Microsoft Word
If you want to create a mail merge from Excel to Word, there’s more involved than simply connecting a worksheet....
How-To
How to Find External Links in Microsoft Excel Workbooks
Finding links and external references in a Microsoft Excel workbook isn’t as easy as you’d expect. To find all workbook...
How-To
How to Convert Dates to Numbers in Microsoft Excel
When you use dates in your Microsoft Excel workbooks, there may be a time when you want the serial numbers...
How-To
How to Indent Cells in Microsoft Excel
If you’re trying to figure out how to indent cells in Excel, you’ve come to the right place. Want to...
How-To
How to Show Dates as Days of the Week in Microsoft Excel
When you’re tracking data in Microsoft Excel, you can take advantage of the built-in date formatting. However, you may want...
How-To
How to Strikethrough in Microsoft Excel
The strikethrough option in Microsoft Excel is a great way to mark tasks as completed or show edits you’ve made....
How-To
How to Fix or Correct the #SPILL Error in Microsoft Excel
If you use Microsoft Excel, you may have encountered the #SPILL error. This error occurs when a formula returns multiple...
How-To
How to Create a Calibration Graph/Curve in Microsoft Excel
Primarily used in analytical chemistry, a calibration curve, sometimes called a standard or reliability curve, is used to compare samples...
How-To
How to Calculate the Difference Between Two Times in Microsoft Excel
When you work on something like a timesheet in Microsoft Excel, you may need to get the difference between times....
How-To
How to Add a Total Row to a Microsoft Excel Worksheet
Whether you’re a seasoned Excel user or just starting to explore the powerful world of spreadsheets, knowing how to calculate...
How-To
How to Anchor Cells in Microsoft Excel
One feature that’s easy to overlook but is incredibly important for accurate calculations is “anchoring.” If you’ve ever copied an...
How-To
How to Delete a Spreadsheet in Microsoft Excel
Everyone who works with Microsoft Excel workbooks will have to delete a spreadsheet (also known as worksheet) sooner or later....
How-To
What Is “Hard Coding” in Microsoft Excel?
Hard coding sounds like a complex programming concept, but it’s a fundamental concept in Microsoft Excel. Let’s learn what it...
How-To
How to Move Rows in Microsoft Excel
Are there times you decide to rearrange the data in your worksheet after you add it? If so, you can...
How-To
How to Calculate Mean Squared Error (MSE) in Microsoft Excel
In statistics, the mean squared error (MSE) is an important metric that measures the amount of error in a statistical...
How-To
How to Delete or Remove a Table in Microsoft Excel
After you create a table in Microsoft Excel, you may decide that your spreadsheet looks better without it. You can...
How-To
How to Create a Bell Curve Chart in Microsoft Excel
Graphs and Excel charts are a great way to visualize complex datasets, and Bell curves are no exception. They let...
How-To
How to Calculate a Loan in Microsoft Excel (Templates and Formulas)
Are you considering buying a house? Did you just purchase a car? Are you close to college graduation? Real estate,...
How-To
Can’t Type in Microsoft Excel? 6 Fixes to Try
If you use Microsoft Excel frequently, you might have run into the error where you can’t type anything into an...
How-To
How to Fix Microsoft Excel Can’t Insert New Cells Error
Microsoft Excel is the go-to application for managing and analyzing massive datasets (especially numerical ones). Occasionally, however, you may encounter...
