

Category Archives for "Excel Tips"

18 8 Ways to Reduce Excel File Size (that actually work)

Excel workbooks have been known to become painfully slow and heavy as more data/formulas/images are added to it. Sometimes, it’s easy to get rid of the extra flab and keep the excel file size in check, and sometimes, it isn’t. And since Excel is not a web-based tool, most of us work and collaborate by […]

4 How to Move Rows and Columns in Excel (The Best and Fastest Way)

Sometimes when working with data in Excel, you may have a need to move rows and columns in the dataset. For example, in the below dataset, I want to quickly move the highlighted row to the top. Now, are you thinking of copying this row, inserting the copied row where you want it, and then […]

16 Search and Highlight Data Using Conditional Formatting

Video – Search and Highlight Data Using Conditional Formatting If you work with large datasets, there can be a need to create a search functionality that allows you to quickly highlight cells/rows for the searched term. While there is no direct way to do this in Excel, you can create a search functionality using Conditional […]

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

All rows where name is Bob are highlighted

Watch Video – Highlight Rows based on Cell Values in Excel In case you prefer reading written instruction instead, below is the tutorial. 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 […]

4 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 […]

26 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 […]

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

Watch the Video on Using Data Entry Forms in Excel Below is a detailed written tutorial about Excel Data Entry form in case you prefer reading over watching a vidoe. Excel has many useful features when it comes to data entry. And one such feature is the Data Entry Form. Why Do You Need to […]

« Previous 1 2 3 4 5 … 35 Next »