Python Program to Edit Excel Files

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…

Python Program to Read Excel Files

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,…

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…

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…