How to Use IFERROR Function in Excel
Here’s everything you need to know about what the IFERROR function is and how to use it to handle errors in Excel.
Microsoft Excel
109 posts
![How to Calculate Percent Change in Excel [Formula]](/content/images/size/w600/wordpress/2021/07/allthings.how-how-to-calculate-percent-change-in-excel-formula-percentage-change.png)
How to Count Unique Values in Excel
Here are the different methods and formulas for counting Unique and Distinct values in Excel (with Examples).
How to Use Excel Search Function
Learn how to use the SEARCH function to find the position of a text string or character as well as extract a specific substring in Excel.
5 Best Excel Shortcuts Mugs For the Excel Nerd
Mainstream gifts are so last year. Quirk up the gifting scene with this mainstream item repurposed with a niche idea for the perfect Excel nerd!
How to Use Index Function in Excel
Learn how to use the INDEX function as well as the INDEX and MATCH combo function in Excel (with Examples).
How to Clear Formatting in Excel
Remove formatting from specific cells, blank cells, or the entire worksheet in Excel with this step-by-step guide.
How to Total a Column in Excel
You can sum a column with a single click, the AutoSum feature, SUM function, filter feature, and by converting a dataset into a table.
How to Move a Row in Excel
You can move Rows or Columns using the mouse drag, cut and paste/insert cells, or the data sort feature in Excel.
What is #SPILL Error in Excel and How to Fix it?
This article will help you understand all the causes of #SPILL errors as well as the solutions to fix them in Excel 365.
How to Calculate Probability in Excel
This article explains how you can calculate probability in Excel using the PROB function with several examples.
How to Spell Check in Excel
You can check for spelling errors in a single cell, multiple cells, entire worksheet, multiple worksheets, or the entire workbook of Excel.
How to Select Non Adjacent Cells in Excel
Learn to select non-adjacent/non-continuous cells or ranges of cells using five different methods in Microsoft Excel.
How to Fix #NAME Error in Excel
This post covers everything you need to know about finding, fixing and preventing the #NAME? errors in Excel.
How to Calculate Percent Change in Excel [Formula]
This post shows you how to calculate percentage change between numbers, columns, rows as well as percentage increase and decrease in Excel.
How to Add Leading Zeros in Excel
This tutorial covers the different methods to add or keep leading zeros as well as remove leading zeros in Excel.