Select Page

## How to do a wildcard search in Excel

Excel’s Find and Replace feature is a versatile tool that can help you find specific values in your workbook. You can capitalize on this feature by using wildcard characters to find values that share a similar pattern. If you know how your search value starts...

## How to delete blank rows in Excel using Power Query

Getting rid of blank rows in your data can be cumbersome, especially when working with large data sets. To add to your problems, Excel uses blanks as limits for ranges when you add tables or sort data, or try to use shortcuts. There are various methods to do this, but...

## How to use the Go To feature to make Excel delete blank rows

Blank rows are a common problem especially when it is gathered by importing or inexperienced user entry. They can be hard to get rid of, and Excel uses blanks as limits of ranges when you use features like adding a table, sorting or filtering. In this article,...

## How to remove blank rows in Excel using sorting

Blank rows can be a not so small nuisance in data collection applications. In addition to making data management harder, an unorganized data set filled with blanks can mess with your calculations. Furthermore, Excel uses blanks as limits of ranges when you add a...

## How to remove blank rows in Excel using filters

Blank rows can be a not so small nuisance in data collection applications. In addition to making data management harder, an unorganized data set filled with blanks can mess with your calculations. Furthermore, Excel uses blanks as limits of ranges when you add a...

## How to calculate standard deviation in Excel

One of the fundamental operations of statistical analysis is calculating the standard deviation of a data set. In this article, we’re going to show you how to calculate standard deviation in Excel using the STDEV.S and STDEV.P functions. Syntax =STDEV.S( array...

## How to calculate mean in Excel

Calculating the mean of numbers is one of staples of statistical analysis processes. In this article, we’re going to show you how to calculate mean in Excel using the AVERAGE formula. Syntax =AVERAGE( array of numbers ) Steps Begin by creating the formula...

## How to create a multi-level Excel lookup

VLOOKUP, HLOOKUP or their predecessor LOOKUP are Excel’s most famous lookup functions. However, these functions can search a value only in a single dimension, meaning that you can’t search horizontally and vertically. Unfortunately, there are no formulas...

## How to stop excel from changing numbers to dates

Excel changes some numbers or strings to dates to be “user-friendly” and ease the date entering process. However, Excel does so without actually asking you, and ironically, there is no option to turn this off. In this article, we’re going to show you...