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).
Microsoft Excel
105 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 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.
How to Use Less Than or Equal to Operator in Excel
You can use the ‘less than or equal to (<=)’ operator with text, date, and number as well as with Excel functions to compare values in Excel.
How to Convert an Excel File to Google Sheets
You can convert Excel files to Google Sheets by importing an Excel file, by opening it in Google Drive, or while uploading to Google Drive.
How to Use Excel Match Function
You can use the Excel MATCH function to find the relative position of a specific value in a range of cells or an array.
How to Add in Excel
You can add numbers, cells, ranges, columns, and rows in Excel using formulas, functions, AutoSum feature, and using Paste Special feature.