Microsoft Excel

Tag
87Articles
Microsoft Excel Logo

How to Use Quick Analysis Tool in Excel

Use the Quick Analysis Tool in Excel to quickly analyze and visualize your data with charts, tables, sparklines, formatting, etc.

Microsoft Excel

How to Calculate Standard Deviation in Excel

Be a pro and use this guide to calculate Standard Deviation in Excel in a jiffy.

Microsoft Excel Logo

How to Use Descriptive Statistics in Excel

Calculate descriptive statistics for your data using the Data Analysis tool as well as Formulas in Excel.

Excel Formula

How to Display Cell Formulas in Excel

If you need to print a worksheet with formulas or keep track of the formulas, then learn how to show formulas in Excel instead of the values.

Keyboard Arrow Keys

How to Fix Arrow Keys Not Working In Excel Problem

If your arrow keys are not functioning within Excel, you can use the tips in this troubleshooting guide to solve the issue.

Rotate Text

How to Rotate Text in Excel

Learn how to rotate text clockwise, counterclockwise, vertical, up, down, or by a specific degree of angle in Excel.

Highlight Alternate Rows Excel

How to Highlight Every Other Row in Excel

Learn how to highlight every other row or column using conditional formatting, built-in table styles, formulas, and VBA macro in Excel.

Recover Excel File

How to Recover an Unsaved Excel File

Easily recover or restore unsaved excel files with these simple methods.

Microsoft Excel Logo

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 Logo

How to Count Unique Values in Excel

Learn the different methods and formulas for counting Unique and Distinct values in Excel (with Examples).

Spreadsheet

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.

Excel Mug

5 Best Excel Shortcuts Mugs For the Excel Nerd

Wondering what a “Spreadsheet-kind-of-person” would like? Here are 5 options!

Excel Function

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).

Excel Sheet

How to Clear Formatting in Excel

Remove formatting from specific cells, blank cells, or the entire worksheet in Excel with this guide.

Microsoft Excel Logo

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.

Excel Spreadsheet

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.

Microsoft 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.

Probability

How to Calculate Probability in Excel

This article explains how you can calculate probability in Excel using the PROB function with several examples.

Spell Check

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.

Excel Sheet

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.

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.

Percentage Change

How to Calculate Percent Change in Excel [Formula]

This tutorial shows you how to calculate percentage change between numbers, columns, rows as well as percentage increase and decrease in Excel.

Microsoft Excel Logo

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.

Microsoft Excel Logo

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.