Conditional formatting based on another cell can help you create an interactive spreadsheet. For example, you can customize it to highlight all the sales in a data range that exceed your target file. Also, you can set a class mean score to a cell and use conditional formatting to highlight all students that scored below […]
Conditional Formatting Based on another cell Read More »
Excel is an excellent tool for counting odd or even numbers. It has inbuilt formulas and features that can differentiate between an even and an odd number. Therefore, if you struggle to sum or count odd numbers or even numbers, only this guide is for you. Count odd numbers only using the MOD function MOD
How to Count Odd or Even Numbers only in Excel Read More »
There many types of graphs you can use to present ways in Excel. One of the little-used charts is the Gauge Chart, commonly referred to as the speedometer chart. In this tutorial, I will guide you on how to create a Gauge Chart in Excel easily. What is a Gauge Chart? A Gauge chart uses
How to Create a Gauge Chart in Excel: SPEEDOMETER Read More »
Excel files are mostly created and opened using Microsoft Excel. However, sometimes you may need to open Excel files without Excel. Maybe someone sent you an XLS or XLSX file that you need to read, and you don’t have the Microsoft Office suite. Don’t worry, as there are many ways to get around this. 1.
How to open Excel files without Excel: 8 Easy Ways 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 »
