Hello, Excellers welcome to today's #formulafriday blog post. Today let's look at using conditional formatting formula to change Excel cell text colour when a formula is replaced with a value. In particular, a value that user has manually typed into a cell. As well as a great way to visualise data, conditional formatting can also be used in a lot of scenarios where visually identifying changes to cells are required. In this example today, it is the replacement of a formula in a cell with a … [Read more...]

## Formula Friday- Increase Or Decrease A Number By A Percentage In Excel

Hello, Excellers it is yet another week has gone by which means it's time for Formula Friday Excel tip. Let's take a look at percentages today and specifically increasing or decreasing a number by a set percentage. If you need to increase a number by a certain percentage, you can use a simple formula. The formula is- multiply the number times the per cent + 1. Similarly, if we want to decrease a number by a certain percentage, you can use the equally simple formula multiply the number times … [Read more...]

## Using TRIMMEAN IN Excel To Ignore Outliers – Formula Friday

Hello, Excellers welcome to another #formulafriday blog post with yet another an awesome Excel tip. No - one likes to be ignored right?....wrong?...let you decide that one, but I was asked recently about calculating an average of a data set which was being skewed by some very rogue or outlying looking values in the range and data. Today we are going use TRIMMEAN to Ignore Outliers.. The values could have been extracted or input incorrectly, but it did affect the average of the data set. … [Read more...]

## Identify New Customers With Conditional Formatting Using A Formula – Formula Friday

Hello Excellers and welcome back for aonther#formulafriday. Today I want to share how to highlight new entries into an Excel list within a specified time period. So, your boss has asked you send on a list weekly of new customers, and highlight them. This method will allow you to just send the list and Excel will do the hard work. Excel will automatically highlight the previous 7 days new entries or sign-ups. We can easily achieve this with some clever Conditional Formatting. And of course, … [Read more...]

## Find The Maximum Value In Your Data Set WITHOUT a Formula

i Excellers and welcome back to another #formulafriday blog post. Today is a little different as we will not be using a formula. For this great Excel tip, we actually do not even need to type an equals sign or enter anything into a cell to calculate the maximum value in our data set. So I guess this is a #notaformulafriday blog post. Go figure!. Let's start with a data set a bit like my example below. We want to find the largest or the maximum value in the dataset. We could use a few … [Read more...]

- « Previous Page
- 1
- 2
- 3
- 4
- …
- 44
- Next Page »