Excel helps to make work easier when dealing with data. You can use it to automate tasks that could otherwise consume many hours. For example, using Excel, you can rename hundreds to thousands of files in a folder. If you were to do it manually then this would take a day or two. But with […]
How to rename many files at once using Excel Read More »
While working in Excel, it’s common that you may need to count values, cells, rows and columns. It’s easy to count manually only when your spreadsheet contains minimal data. If you have a large data set and wish to count blank cells in Excel, then it can be a daunting task. Luckily, Excel comes with
How to count Blank cells in Excel Read More »
1 inch is equivalent to 2.54 centimeters. In other words, 1 centimeter is equivalent to 0.3937 inches. Knowing these values, you can easily create a calculator in Excel to help you convert centimeters to inches and vice versa. Methods to convert CM to Inches in Excel Let’s look at a few methods which you can
How to convert CM to inches in Microsoft Excel Read More »
One of the most annoying things in Excel is having blank rows. Especially when working with a large data set with hundreds of rows. Deleting the rows manually is not an option as it will consume a lot of time. Although Excel has no inbuilt feature, you can use some tricks to get it done
How to Delete Blank Rows in Excel: Easy Guide Read More »
Generative AI has taken over almost all industries by storm. ChatGPT, in particular, has become the fastest platform to cross over 100 million users. Excel is not left behind as people rush to apply it in their workplaces and schools to make work easier. In this article, you shall learn various ways you can use
How to use ChatGPT with Excel Read More »
When working with numbers, it’s very likely that you will need to calculate percentages. Besides, it’s an integral part of the finance, business, and education world. The percentage is also used in various careers such as Engineering, IT, and Surveying. What is percentage change? Before we dive into the tutorial, it’s important to understand the
How to Calculate Percentage Change in Excel Read More »
A countdown time can help you track time while working on spreadsheets. In this tutorial, I will guide you on how you can create a countdown timer in Any Excel cell. I will also teach you how to add interactive buttons to pause or resume the timer. Countdown days using the formula If you want
How to create a countdown Timer in Excel Read More »
VLOOKUP is one of the most used Excel functions. It helps to look up data in the same worksheet, different worksheet, or different workbook book easily. Most people are used to looking up values from the same Workbook but not separate Workbook. For this reason, I will guide you on how to VLOOKUP between two
How to VLOOKUP between two Excel Files Read More »
Do you have data full of duplicate values that you wish to clean? It can be annoying to have repeated values in your worksheet. Luckily, Excel has inbuilt features to handle just that. You can take advantage of these features to remove duplicates in Excel easily. In this guide, I will show you different methods
How to Find and Remove Duplicates in Excel: Simple Guide Read More »
Deleting subsequent rows is very easy as you just highlight, right-click then select delete. The challenge comes in when you want to delete every other row. It can take ages to highlight and delete every other row manually. However, there are a few ways you can achieve this efficiently. In this tutorial, I will show
How to Delete Every Other Row in Excel: Easy Guide Read More »
