## How to calculate Standard Deviation in Excel

Standard Deviation is the measure of the dispersion of the dataset. Standard Deviation shows the range of how much the data deviates from the mean of the dataset. Calculating the Standard Deviation of a given dataset has proved to be tedious and time-consuming. Excel has automated calculating the Standard Deviation of a given dataset. In

## How to select Every Third Row in Excel

Sometimes, you may need to select or highlight the nth Row of your dataset. Doing so manually can be tedious and time-consuming. Thankfully, Excel has in-built tools and features that can be used to achieve this task. In this article, we shall discuss quick and easy ways that can be used to select the third

## How to Filter Cells that have Duplicate Text Strings in Excel

Sometimes, you may duplicate texts/words while working on an Excel Worksheet. In the case of a worksheet with a large dataset, it may pose a significant challenge to identify the duplicate strings manually. However, Microsoft Excel is equipped with numerous tools that can be used for duplicate Text strings. In this post, we shall discuss

## How to fix #value error in Excel

The #value error is an error in Excel that indicates the formula used is incorrect. The error commonly occurs when the value type is not one of the arguments of the formula. To new users, locating and finding the cause of the #value error may be challenging and time-consuming. This article will discuss the scenarios

## How to delete Drop Down list in Excel

Drop Down is a drop-like list containing several options from which the user selects one item. It eases the process of selecting and choosing options for a given query. Sometimes you may wish to edit or delete the added drop-down button. To delete Drop Down list. A] Using a data validation tool Steps: 1. Open

## How to sort by color in Excel

Sorting is one of the common data analysis practices that is performed on any dataset. Dataset sorting allows users to conclude and visualize the data quickly. Microsoft Excel has sorting features that help user to analyze the dataset. In this article, we will discuss ways of sorting Excel datasets by color. To sort Excel datasets

## How to sort Worksheets using VBA in Excel â€“ Alphabetically

Sometimes, you may be working on a workbook with too many worksheets. This may lead to a clutter of worksheets in the workbook if there is no proper management of the Worksheets. Therefore, there is a need to manage and sort the worksheets alphabetically. However, no built-in tool or feature can be used to sort

## How to convert Time to Decimal numbers in Excel (Hours, minutes, and seconds)

Sometimes, you may need to store Time in Excel cells in decimal formats. Converting Time to decimal numbers is one of the most straightforward tasks in Excel. Several methods are used in converting Time to decimal numbers. This article will discuss common ways of converting Time to decimal number format. Using Format Cell Tool Steps:

## Excel How to Remove Table Formatting

Excel is built by default with many styles and features. In some cases, we don't need these styles and want to work on excel without them. This feature enables you to keep work more attractive and easier to read. How to remove table formatting in excel Here is what we need to do to remove

## How to Find Outliers in Excel

An outlier is a data point beyond the other data points in the data set. When you have outlier data, it can skew your data, leading to incorrect inference. There are several ways to find out an outlier in excel. By sorting the data The quickest way to identify outlier us with the small databases