Deleting empty rows in Excel Spreadsheet containing a large amount of data can be time consuming. You will find below an easy and faster way to Hide or Delete Empty […]
Excel
How to Use Microsoft Excel on Chromebook
Being a Windows program, Microsoft Excel is not natively supported on Chromebooks. However, you will be pleased to know that it is possible to use Microsoft Excel on Chromebook. Use […]
How to Start New Line in Excel Cell
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 […]
How to Use INDEX MATCH Function 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 […]
How to Use VLOOKUP Function in Excel
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 […]
How to Use Excel SUMIFS Function
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 […]
How to Use SUMIF Function in Excel
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 […]
How to Create Two Pivot Tables in Single Worksheet
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 […]
How to Hide And Unhide Sheets in Excel
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 […]
How to Delete Pivot Table in Excel
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 […]