## How to use INDEX and MATCH function

Index function can be used to get a reference of cell from an Array for required or matching value. It’s basic use require three parameters. We’re going to describe the function with example. Step#1: We’re going to use the following list in excel to use the index function: Index function’s structure is: = INDEX(array, rownum,[columnnum]) […]

## Define and use names in formulas – Excel

In this tutorial. We’re going to set the Range names for the cells in worksheet. Let’s have a look on the worksheet we’ll be using. In this worksheet, we’ll change the price of wines from US Dollars to British Pounds, Euros and Japanese Yen. We’ll be using currency conversion rates in a table so the […]

## Excel Data Validation Messages for Users

To make your worksheet more efficient and user friendly, it’s better to inform the user of the worksheet rules before they intent to enter the value. In this tutorial, we are going to use data entry input messages to provide the better user experience. Following is the worksheet we are going to use Data validation […]

## Protecting Worksheets in Excel 2013

Protecting Worksheets in Excel 2013 Sometimes you may require to protect your important worksheets from misuse & theft. in this post, you are going to learn how to protect your Worksheet in Excel 2013 from unauthorized access. There are variety of ways in Excel 2013 to protect an Excel sheet. These are the available options: […]

## Using Transpose Tool in Excel 2013

Using Transpose Tool in Excel 2013 In this Post I am gonna show you how you can use transpose Tool to convert rows into columns! Do you Know? In Excel 2013,  you can use the same transpose function that appeared in Excel 2010 to rotate tables or change rows & columns. Using Transpose tables you […]

## Sharing Workbooks in Excel 2013 & Onedrive

Sharing Workbooks in Excel 2013 Excel 2013 makes it really easy to share workbooks using OneDrive, which we discussed in Earlier Sections. In order to share any workbook in Excel 2013, it must first be saved to your OneDrive (See How to Save onto OneDrive Section). Here’s How to Share a Workbook: Simply click the tab that says, “File” to access the backstage view, and […]

## Saving an Workbook in Excel 2013

Saving an Workbook in Excel 2013 When you create & work on a new workbook in Excel 2013, you’ll should to know how to steps to save your work & workbook so that you can access it & edit it later. There are many different ways to save a workbook in Excel 2013. In previous versions of Microsoft Excel […]

## Worksheet Views & Using Templates in Excel 2013

Worksheet Views in Excel 2013 Excel 2013 has different types of viewing options that allows you to change how your workbook appears. You Can Choose from Options like, Normal view, Page Layout view & Page Break view. These Views are very useful. Here’s How to change the worksheet views: Locate “worksheet view command” in the bottom-right corner of your […]