

Category Archives for "Excel Tips"

11 Highlight Rows Based on a Cell Value in Excel (Conditional Formatting)

All rows where name is Bob are highlighted

Conditional Formatting allows you to format a cell (or a range of cells) based on the value in it. But sometimes, instead of just getting the cell highlighted, you may want to highlight the entire row (or column) based on the value in one cell. To give you an example, below I have a dataset where I […]

3 How to Make a Histogram in Excel (Step-by-Step Guide)

A histogram is a common data analysis tool in the business world. It’s a column chart that shows the frequency of the occurrence of a variable in the specified range. According to Investopedia, a Histogram is a graphical representation, similar to a bar chart in structure, that organizes a group of data points into user-specified ranges. The […]

15 How to Compare Two Columns in Excel (for matches & differences)

Compare Lists in Excel - matches are shown as TRUE

The one query that I get a lot is – ‘how to compare two columns in Excel?’. This can be done in many different ways, and the method to use will depend on the data structure and what the user wants from it. For example, you may want to compare two columns and find or […]

17 How to Create a Data Entry Form in Excel (Step-by-step Guide)

Excel has many useful features when it comes to data entry. And one such feature is Data Entry Form. Why Do You Need to Know About Data Entry Forms? Maybe you don’t! But if data entry is a part of your daily work, I recommend you check out this feature and see how it can […]

4 Excel Sparklines – A Complete Guide with Examples

Sparklines feature was introduced in Excel 2010. In this article, you’ll learn all about Excel Sparklines and see some useful examples of it. What are Sparklines? Sparklines are tiny charts that reside in a cell in Excel. These charts are used to show a trend over time or the variation in the dataset. You can […]

13 Find the Last Occurrence of a Lookup Value a List in Excel

In this tutorial, you’ll learn how to find the last occurrence of an item in a list using Excel formulas. Recently, I was working on setting the agenda for a meeting. I had a list in Excel where I had a list of people and the dates on which they acted as […]

8 100+ Excel Interview Questions & Answers To Make You Job Ready

Excel Questions for Job Interview - Cover

Microsoft applications such as Word, Excel, PowerPoint are used in almost every large organization as well as by millions of small businesses, freelancers, and entrepreneurs. For something that is so popular, it makes sense to have a decent knowledge on how to use these applications efficiently. In some job roles, a major part of the work […]

« Previous 1 2 3 4 … 33 Next »