Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
I am a huge fan of the Matrix movie series. It an amazing piece of work of its time and one of my favorites science fiction movie series. If you have seen Matrix, there is no way you wouldn’t remember the falling code sequence. I thought of creating this in Excel, but someone beat me …
Excel is more than a data entry tool. But if you only talk about data entry in Excel, it’s a damn good one. Using the data validation, you can enable data entry in cell(s) based on a predefined condition. Conditional Data Entry in Excel Using Data Validation Here are a few examples of conditional data …
You start your day. Plan some tasks. Write it down somewhere and start working on it. When it’s way past your work time, you think about that to-do list (stare at it if you have it written) and curse the world for not having enough time in the day. Sounds familiar? If you are nodding …
What comes to your mind when you see text with a strikethrough in Excel (something as shown below)? In most cases, it means that the task or activity has been completed and has been checked off. Those who work with Microsoft Word use this extensively, and there is a strikethrough icon right there in the …
Watch Video – Start a New Line in a Cell in Excel (Shortcut + Formula) In this Excel tutorial, I will show you how to start a new line in an Excel cell. You can start a new line in the same cell in Excel by using: Start a New Line in Excel Cell – …
Excel has many functions where a user needs to specify a single or multiple criteria to get the result. For example, if you want to count cells based on multiple criteria, you can use the COUNTIF or COUNTIFS functions in Excel. This tutorial covers various ways of using a single or multiple criteria in COUNTIF …
I was never into sports. I tried my hands at a number of sports, but I was always below average in most of it (you got to give me some credit for trying at least). In 2010, my roommate got me addicted to watching football. We would keenly follow all the matches in English Premier League and …
When creating a drop-down list in Excel, it takes a range of cells as input and shows it as a list. There is not much you can do with how your list looks in the drop-down. For example, you can not give a background color or change font color, font type, font size, etc. Despite …
Wouldn’t it be great if there was a function that could count colored cells in Excel? Sadly, there isn’t any inbuilt function to do this. BUT.. It can easily be done. How to Count Colored Cells in Excel In this tutorial, I will show you three ways to count colored cells in Excel (with and without …
©trumpexcel.com – Free Online Excel Training
