# Category: Microsoft Office

#### How to check if a cell is blank or empty in Excel

In this blog post, we’ll delve into a fundamental aspect of Excel usage—checking if a cell is blank or empty. Why Check for Blank Cells? Before we dive into the…

#### Cleaning text with trim() and proper() in Excel

We often import data, including text, from different sources into Excel. Sometimes this text requires some cleaning such as removing spaces and adding consistency to the text. This post demonstrates…

#### Mean, Median, and Mode in Excel

In Microsoft Excel, you can easily calculate the mean, median, and mode for a set of data using built-in functions. Let’s break down how you can do each: Mean: To…

#### How to count cells in Excel

This tutorial shows how to count cells in Excel using various formulas effectively. Excel offers four distinct functions for cell counting, each catering to specific scenarios: COUNT(), COUNTA(), COUNTBLANK(), and…

#### How to see all formulas on a Worksheet

This post shows you how to visualize all formulas on an Excel sheet at once. To see all formulas on a worksheet, go to Formulas > Show Formulas or simply…

#### How to transpose data in Excel

The following steps show how to transpose data in Excel. Transposition refers to switching between rows and columns. See the three step process below: 1 – copy a dataset 2…

#### Counting cells in Excel

Excel provides 4 different functions to count cells: count(), counta(), countblank(), countif() Counts cells in the range which hold a value. Empty cells and cells containing formulas are not counted.…

#### How to write nested if statements in Excel

This post shows how to write nested if statements in Excel To write a nested if statement, write other if statements in place of true or false statements. For example:=if(A3=A4,if(B3=B4,”True”,”False”),”False”)…

#### How to merge and unmerge cells in Excel

In this post, you will learn how to merge and unmerge cells in Excel. Select cells and then click on Home tab in the menu followed by Merge and Center…

#### How to concatenate cells in Excel

This post shows how to concatenate cells in Excel. concatenate() function concatenates cells=concatenate(A1,A2) Suppose we have the following data: The & operator can be used to concatenate cells. The following…