Office Guide

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

Beauty of Mixed Cell references in Excel

Mixed cell references in Excel is an important type of cell references. By default we can use relative cell address or reference with in a formula. Mixed cell references is combination of relative and absolution cell references. Using mixed cell reference either your column label absolute and row number is relative or row number is absolute while column label is relative. You can easily switch between relative to absolute or mixed cell reference by manually or using F4 function key. Read More

Filter data by background color or conditional formatting

During working on the Excel sheet you have to fill multiple colors in any column to set the criteria as per your need. You can apply different background colors or conditional formatting on large worksheet data as per your need. Excel allows you to quickly filter data by background color or conditional formatting in active worksheet. Read More

How to Get Classic PivotTable Layout in Excel

All we know that PivotTable plays an important role for creating different MIS reports in Excel. There are different classic PivotTable layout in Excel different versions. If you have latest version of Excel then you will get lot of different layouts and feature during creating the PivotTable in Excel. PivotTable in Excel provide different inbuilt formats and designs which gives a stylish look of your table. Read More

How to Create Group Worksheets in Excel

Group worksheets in Excel is an important utility which allows you to open, make editing in multiple worksheets at the same time. Sometime we need to type data, apply formatting, moving or copying the data and many more things. But when you do this job on a single sheet it could not be possible. But after creating the group worksheets in Excel you can easily do all these jobs which is applicable on all active worksheets. Read More

How to use Advance Backward VLookup in Reverse Order in Excel

All we know VLookup function is used for search values from left to right side in given array or table. But sometime we need to lookup any value in reverse order. In that situation you need to know how to use advance backward VLookup in reverse order in Excel? In this guide we have to discuss solution to use reverse VLookup in Excel. Read More

Reverse VLookup in Excel with VLookup Function

Most of the person don’t known about the reverse VLookup in Excel. All we know very well VLookup is an important lookup function which search the value from left to right in given array or table. But sometime you need to lookup the value in reverse order that means right to left. It is not so easy to search the required value in reverse order. But there is no need to worry this guide helps you to know how to use reverse VLookup in Excel with the VLookup function. Read More

10 Important Microsoft Excel Tips and Tricks

Microsoft Excel Tips and tricks are too much popular around the world. If you want to become an Excel expert then you must have to no all given important commands. These command helps you to quickly solve your complex task which not only reduce the working time but increase your knowledge also. Excel has wide variety of functions and commands in different versions. If you have latest version of Excel then you can take benefit of different commands. Read More

How to using logical AND function in Excel

If you want to compare different cells data or values then you must have to know how to using logical functions in Excel. Logical AND function in Excel is one of the most important and useful function of excel. If you have more than one criteria in that case you have to use logical AND function in Excel sheet to get the correct result. Read More