Conditional formatting in Excel allows you to format cells based on the values in the cells. The built-in formatting settings and Conditional Formatting are made to format cells based on the value in the cell itself. But what if you want to apply conditional formatting to a cell based on the value in some other ... Read more from Online Excel Tips – Blog – Trump Excel https://ift.tt/clxRsCt ..read more

Excel is an amazing spreadsheet tool, but there are some things that drive me crazy. One such thing is when you need to copy and paste data into a column with filtered rows. Excel would paste this data into the visible cells as well as the hidden cells that have been filtered out. In most ... Read more from Online Excel Tips – Blog – Trump Excel https://ift.tt/lzg9hCK ..read more

When you’re working with the data set that has hidden rows, and you select and copy the cells in this dataset, it is going to copy the visible cells as well as the hidden cells. That’s the default behavior in Excel. But what if you only want to copy the visible cells (and not the ... Read more from Online Excel Tips – Blog – Trump Excel https://ift.tt/WCFRHg5 ..read more

Excel has the SUMIF and SUMIFS functions that allow you to add a range of cells based on one or more criteria. And sometimes, you may want to get the sum of cells based on partial match in the dataset. For example, suppose I have a dataset as shown below and I want to get ... Read more from Online Excel Tips – Blog – Trump Excel https://ift.tt/8OES6cq ..read more

Excel add-ins are helpful when you want to enhance the functionalities in Excel and do things not available by default. Sometimes, you may even have to install and use third-party add-ins. While add-ins are useful, you may want to remove them when you’re done using it. Or, sometimes, it may interfere with the proper functioning ... Read more from Online Excel Tips – Blog – Trump Excel https://ift.tt/IhWSTe7 ..read more

Among the many awesome features in Excel, Name Box doesn’t get talked about enough. While it looks like a simple name box (just like its name says), there are some cool things you can do with it. In this article, I will cover everything you need to know about Name Box in Excel and some ... Read more from Online Excel Tips – Blog – Trump Excel https://ift.tt/ZY7asjh ..read more

When doing data entry work in Excel, you may want to prevent entering duplicate entries in a column or a range of cells. Thankfully, there is a feature in Excel that allows you to do precisely this – and it’s called Data Validation. In this article, I will show you how to prevent duplicate entries ... Read more from Online Excel Tips – Blog – Trump Excel https://ift.tt/6J4Y1js ..read more

Conditional Formatting allows you to add a visual layer to your dataset and make it easier to understand. You can use it to quickly highlight cells that satisfy the specified conditions (such as highlighting cells with the top 3 values or highlighting all cells that contain the word ‘Excel’, etc.) But sometimes Conditional Formatting may ... Read more from Online Excel Tips – Blog – Trump Excel https://ift.tt/BeWm8d9 ..read more

Most of my work involves getting data from various sources, such as databases, webpages, or other people. In most cases, the first step is to clean the data and make it usable for my analysis. Sometimes, I get datasets that have an additional character in the end that I want to remove. Thanks to some ... Read more from Online Excel Tips – Blog – Trump Excel https://ift.tt/oVPiGJ7 ..read more

There are multiple ways to calculate the square of a number in Excel. You can use the in-built POWER function or the Caret operator (^). Let me show you how to quickly calculate the square of a number in Excel. Using the POWER Function POWER function allows you to get the square, cube, or any ... Read more from Online Excel Tips – Blog – Trump Excel https://ift.tt/7zonEWa ..read more