Apps 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.
Apps How to Count Unique Values in Excel Here are the different methods and formulas for counting Unique and Distinct values in Excel (with Examples).
Apps 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.
Microsoft 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!
Apps 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).
Apps 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.
Apps 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.
Apps 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.
Apps 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.
Apps How to Calculate Probability in Excel This article explains how you can calculate probability in Excel using the PROB function with several examples.
Apps 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.
Apps 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.
