Office

Starting a New Line within the same Excel Cell has puzzled many Excel users. You will find below the wrong and the right way to Start New Line in Excel […]

The INDEX and MATCH Function in Excel can be used in combination to Lookup values much faster than VLOOKUP. You will find below the steps to use the combined INDEX […]

The VLOOKUP Function in Excel allows you to lookup an item located in one column and find its corresponding value from another column. VLOOKUP Function in Excel VLOOKUP is a […]

In case you are familiar with SUMIF Function in Microsoft Excel, you might also be interested in Excel SUMIFS Function, which can be used to sum up a list of […]

This tutorial explains the use of SUMIF Function in Excel to count the total number of items meeting a particular Criteria. SUMIF Function in Excel As mentioned above, the SUMIF […]

Sometimes you may want to create two Pivot tables in single Excel worksheet to report data in two different ways. You will find below the steps to create Two Pivot […]

If there are multiple worksheets in an Excel Workbook, you may want to hide few worksheets to reduce the clutter or for other reasons. You will find below the steps […]

After Creating Pivot Table and using it to create reports, you may want to delete it. You will find below the steps to delete Pivot Table in Excel in three […]

The default setting in Excel Pivot Tables is to show blank cells when there is no applicable data for a row or column label. You will find below the steps […]

Sometimes you may find the need to hide zero values in your data and show cells with zero values as blank cells. You will find below different methods to Hide […]

Sometimes the presence of zeros in Excel data field can make histograms and other type of graphs look inaccurate. You will find below the steps to replace zeros with blank, […]

Here is how to Insert Picture into Excel Cell, in case you come across the need to insert company logo or product pictures into Excel. Insert Picture Into Excel Cell […]