Excel Formula tips and tricks to make you a champion in Excel. A lot can be done when you know the right Formula hack.
When we calculate a simple average of a given set of values, the assumption is that all the values carry an equal weight or importance. For example, if you appear for exams and all the exams carry a similar weight, then the average of your total marks would also be the weighted average of your …
A lot of times, we need to work with text data in Excel. It could be Names, Address, Email ids, or other kinds of text strings. Often, there is a need to combine cells in Excel that contain the text data. Your data could be in adjacent cells (rows/columns), or it could be far off …
Excel has a set of TEXT Functions that can do wonders. You can do all kinds of text slice and dice operations using these functions. One of the common tasks for people working with text data is to extract a substring in Excel (i.e., get psrt of the text from a cell). Unfortunately, there is …
Leading and trailing spaces in Excel often leads to a lot of frustration. I can’t think of a situation where you may need these extra spaces, but it often finds its way into the excel spreadsheets. There are many ways you can end up with these extra spaces – for example, as a part of …
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 …
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 …
Counting is one of the most common tasks people do in Excel. It’s one of the metric that is often used to summarize the data. For example, count sales done by Bob, or sales more than 500K or quantity of Product X sold. Excel has a variety of count functions, and in most cases, these …
Four years ago, I was sharing an apartment with 3 of my friends. At the end of every month, we would sit together, jog our memory to remember expense details, and use a calculator to get each person’s share. And we used to get it wrong every time. Today I am here with a Shared …
©trumpexcel.com – Free Online Excel Training
