## Excel String Functions: LEFT, RIGHT, MID, LEN and FIND

Need to retrieve specific characters from a string in Excel? If so, in this guide, I’ll show you how to use the Excel string functions to obtain your desired characters within a string. Specifically, I will use examples to illustrate how to apply the following Excel string functions: Excel String Functions Used Description of Operation LEFT Retrieve …

## Repeat Specific Rows on Every Printed Page in Excel 2010

Do you need to repeat specific rows on every page when printing in Excel? If so, in this post, I’ll show you how to select specific rows to be displayed on every printed page in Excel 2010. To start, let’s take an example where you store a list of 60 employees in Excel. This list contains the: …

## Highlight Cells Rules under Conditional Formatting in Excel

Highlight Cells Rules is a useful functionality in Excel. In this post, I’ll show you how to use the Highlight Cells Rules under Conditional Formatting in Excel. You can use Highlight Cells Rules to automatically highlight the cells that meet your defined rules. Let’s look at an example to better understand how you can benefit from using …

## How to use the IF function in Excel 2010

The IF function is a useful operation that you can perform in Excel. In this post’ I’ll show you how to use the IF function in Excel 2010. Structure of the IF function in Excel 2010 The IF function in Excel has the following structure: IF (logical_test, [value_if_true], [value_if_false]) Where: • logical_test is the logic …

## How to Add, Subtract, Divide and Multiply in Excel

There are different arithmetic functions that you can execute in Excel. In this short guide, I’ll show you how to add, subtract, divide and multiply in Excel. Before we start, let’s look at the symbols that represent the basic arithmetic functions in Excel: The ‘+’ symbol is used to add/sum values The ‘-‘ symbol is used to …

## How to use VLOOKUP in Excel 2010

VLOOKUP is a powerful function in Excel that can save you a lot of time in managing your data… In this post, I’ll show you how to use VLOOKUP in Excel 2010. Why use the VLOOKUP function in Excel? VLOOKUP can help you connect/associate data that exists in two (or more) separate tables. To illustrate, …

## 3 Ways to obtain the Max Value in Excel 2010

There are different ways in which you can obtain the Max value in Excel, given a set of values… In this post, I’ll show you the following 3 ways that you can use in order to obtain the Max value in Excel 2010: (1) Using the MAX formula (2) Using the AutoSum under the ‘Home’ tab (3) …

## How to Create a Pie Chart in Excel (with example)

Need to create a pie chart in Excel? If so, I’ll show you the steps to create a pie chart using a simple example. By the end of this short guide, you’ll be able to create the following chart: Steps to Create a Pie Chart in Excel Step 1: Gather the data for the pie …

## 4 Ways to Sum Values in Excel 2010

There are different ways to sum values in Excel. In this post, I will show you 4 ways to sum values in Excel 2010 using the following methods: (1) Sum values within a single cell (2) Sum values in multiple cells (3) Sum values using AutoSum (4) Sum values using the ‘Insert Function’ Sum values …

## How to Create a Column Chart in MS Excel 2010

Need to create a Column Chart in MS Excel? There is an easy way to do it in Excel. In this post, I’ll show you how to create a Column chart in MS Excel 2010. But before we begin, you’ll need a data-set that will be presented in your Column Chart. I created the following …