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…
Using the Python program discussed here, we can ‘add or delete Text’, ‘insert Formulas’ and ‘modify the Formatting’ across thousands of Excel Workbooks in a computer Folder. Install Python and openpyxl To write and execute this program, you need Python, along with the openpyxl library. Those who doesn’t have Python installed on their computer, check…
This blog post is about a Python Program that can quickly consolidate data from all Excel workbooks in computer folder. Regardless of whether you have 100, 500, or even thousands of Excel files stored in a folder, this program can easily extract the data and present it in a single Worksheet. To use this program,…
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…
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…
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…
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…
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…
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…
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…
This blog post is about converting a Word file into a Password protected PDF file. Go to the File tab in the Word Ribbon > Export > Click on Create PDF/XPS The Publish as PDF or XPS dialog will be activated. Click on the Options… button to activate the Options dialog. Mark the checkbox against…
