# Office Guide

We offer office guides and easy step by step tutorials with images and videos that help you to do easy your work.

## How to switch or flip name in Excel

Sometime you need to flip the first and last name within the cell. Mostly peoples use cut and paste method to easily switch or flip name in Excel sheet. You can also use retyping method of reverse the first name and last name within cells. These are the simple ways to reordering the first and last name. Now, in this guide we’ll discuss another way which quickly allows you to switch or flip name in Excel sheet. Read More

## How to use DCOUNTA Function in Excel

DCOUNTA function is an important built-in-function of MS Excel. The DCOUNTA function is used to quickly counts non-blank cells within given database. DCOUNTA is a standard built-in-function which is located in Database category in Microsoft Excel. Read More

## How to link data between two or more workbook in Excel

Copying data from one workbook and paste to another workbook is an easy task. But copy and paste method doesn’t create a relationship between the source and target file data. You must have to know how could you link data between two or more workbook in Excel. You can easily establish, refresh, remove the link either between two or more workbook or worksheets as per your need. Read More

## VLookup to Get Sum, Average, Count, Maximum and Minimum value from Multiple Columns

In this guide, you will find a very helpful advanced VLookup formula which demonstrate how to use VLookup to Get Sum, Average, Count, Maximum and Minimum value from Multiple Columns. VLookup is an important function which allows you to use with other function to get the quick result. Read More

## How to use the Excel AVERAGEIF function

In this guide we have to discuss how could you easily calculate the arithmetic mean of different data types with the help of Excel AVERAGEIF function. The AVERAGEIF function in Excel is used to returns the average (arithmetic mean) of all the cells with in the range which meet the given criteria. Read More

## How to lookup images in Excel using Index Match function

Sometime we need to lookup images in Excel sheet. There are lot of Excel functions which allows you to lookup values in Excel sheet. But in case of lookup the image there is different procedure. In this guide we discuss how could you easily lookup images in Excel. Read More

## Excel DatedIF function Compare between two dates

The Excel DatedIF function allows you to quickly calculate the difference between given dates. You can easily calculate the difference between start and end date in years, months, days and many more. Read More

## How to use the Match function in Excel

he MATCH function in Excel allows you to quickly locate for a specified item in range of cells, and then returns the relative position of that item in the range. Match Excel Function is used to returns the relative position of an item in the given array or range of cells that match a specific value in specific order. You can easily use match function to get the result either in vertical or horizontal lookup array. Read More

## How to use IFNA with VLookup function

If any lookup values does not found in the list of array an error message #NA display in the resulted cells. If you want to remove an error value during lookup the value then you must know how to use IFNA with VLookup function. Sometimes when the data your are looking for is not found in the list, you will receive #N/A error message. Read More

## How to insert Excel Pivot Table Calculated Field or Calculated Item

Sometime we need to insert additional calculated filed or item in the active Excel Pivot Table. This guide helps you to show how to insert Excel Pivot Table calculated field or calculated item in active worksheet data. Pivot table is an important part which allows you get quickly get summary of large worksheet data. Read More