Office Guide

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

Autosave Excel file using code to protect file

Lot of time many peoples facing these issue like computer crashes, power goes out, accidentally close any file without saving and many more. In that situation you may lost of your working data, and you need to know how to autosave Excel file. There are lot of ways to auto save Excel file either using Autosave feature or using the code. Read More

Lookup Multiple Fields of Data with Excel VLOOKUP

With the combination of Excel VLOOKUP function with the Column, Column and array function you can easily create a lookup formula which allows you to quickly lookup multiple fields of data with Excel VLookup function. Excel VLookup function with array or column function easily return multiple values from a single row of a database or array of table. Read More

How to use LEFT Function with Find Function

Sometime we need to extract few characters of a string with the help of Left function. In this guide we have to discuss how to use Left function with Find function to extract the worlds. Excel allows you to use a user defined function to split a text string as per your need. To quickly split text string at specific character then you must have to know how to use Left function with Find function. Read More

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

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