Blog

Formula Errors in Excel

If you are a person who use Excel a lot, you might have encountered with these Error Codes like #DIV/0!, #NAME?, #N/A, etc. Each of these error codes tell us something. It gives us information on how to troubleshoot an incorrect formula. Following are the most common Error codes in Excel and this blog post…

VLOOKUP from Two or more Tables

The VLOOKUP function in Excel is designed to search for a ‘Lookup Value’ in the first column of the specified Table and return the corresponding Value against the first matching Value. But what if there are two tables, one of which has the possible matching value? A single VLOOKUP function can’t lookup into two different…

TEXTSPLIT and 13 New Functions in Excel

In this blog post, we will have quick look on the 14 New Functions added to Excel on the 3rd week of March 2022. They are TEXTSPLIT, TEXTAFTER, TEXTBEFORE, VSTACK, HSTACK, TOROW, TOCOL, WRAPROWS, WRAPCOLS, TAKE, DROP, CHOOSEROWS, CHOOSECOLS, and EXPAND The first 3 of these new functions TEXTSPLIT, TEXTAFTER, TEXTBEFORE are designed for manipulating…

How to find the Most Repeated Text or Number in Excel

This blog post is about different ways to find the ‘Most Repeated Number or Text’ in a data set. Formula to find the most repeated Number The MODE function in Excel is designed to return the most repeated number from a numeric dataset. An example with vertical data ranges. Another example with a 2 dimensional…

How to create a Gantt Chart in Excel

Gantt Chart is a horizontal bar chart used for project management and can visually represent a ‘Project Plan’ over ‘Time’. Gantt Charts can be used for scheduling Construction projects, Software development, Research & Design, etc., In this blog post, I will show you how to create a Gantt Chart using Microsoft Excel. Following is the…

How to Round Time in Excel

This Excel Tutorial is about rounding Time Up, Down and to Nearest 15, 30 or 60 minutes. Round Time Up The CEILING function in Excel will round a number up to the nearest multiple of a given number. This logic can be used to round time ‘up’ to the nearest multiple of given Minutes or…

How to import Text files into Excel

This blog post is about 4 different methods to import Text files into an Excel Worksheet. Open dialog To open a Text file stored in a specific location of your computer, go to the File tab of the Excel Ribbon > Open > Browse Open dialog will be activated. Use this dialog to locate the…

How to Add the Developer tab to Excel Ribbon

Microsoft Excel has a VBA interface and options related to that Programming interface are arranged in the Developer tab. But when you install Excel for the first time, you may not see the Developer tab in the Excel Ribbon. In this blog post, I will show you how to add the Developer tab or any…

Convert a PDF file into Word document

Converting a PDF file into Word document is surprisingly easy. And this feature is available in Word 2013 and all later versions of Microsoft Word. To convert a PDF file into a Word document, Open Microsoft Word > go to the File tab > Open > Browse The Open dialog will be activated > Use…

Picture Lookup in Excel

Until now, Excel doesn’t have a lookup function that is designed to return a picture or pictures. That means there is no straight forward method for Picture Lookup in Excel. In this Excel tip tutorial, I will show you how to do Picture Lookup using the existing features in Excel. I have the list of…