Hello, it is time for some more #formulafridayfun. Today I want to share with you how to highlight all cells containing a formula. It is a question a colleague asked me this week. It was a great question!. How can I see at a glance by changing the colours of the cells, my cells that contain formulas?. That would be a handy Excel tip, especially if you have a large worksheet and need to know at a glance. I found a really easy way to achieve this with a few clicks. Follow the instructions … [Read more...]
Find The Last Value In An Excel Column.
Hello, Excellers. Welcome back to another #Excel #FormulaFriday blog post in my Excel 2021 series. Today I will answer a question that was left on one of my YouTube Videos. The question left was the same multiple times. How do I find the last value in an Excel column?. My video actually walks you through how to find the last value in an Excel row using the Index and Count Function. I have put a link below that video. https://youtu.be/n6odmvo0srY So, here is how to find the last … [Read more...]
Using F9 To Evaluate An Excel Formula
Hello, Excellers. Welcome back to another #Excel #FormulaFriday blog post in my 2021 Excel series. This blog post in response to a question asked by a subscriber. They wanted to 'see' the different parts of their Excel formula. Or in their words how to understand how each part of the formula is calculated. So, this is exactly the same as debugging an excel formula. There is a great way to do this in Excel. It's simple, by using the F9 … [Read more...]
Understand And Debug Excel Formula Errors.
Hello Excellers. Welcome back to another #FormulaFriday #Excel blog post in my 2021 Excel series. We all get them from time to time those Excel formula errors that annoy us and drive us nuts. They also indicate to us that something is not working. So, it useful to know. Here is my guide to the main errors we seem to get and what exactly they mean. Once we understand these formula errors we can avoid them or put them right. Excel Formula Errors. The … [Read more...]
Show Value And Percent In Same Report- No Formulas!
Hello, Excellers. Welcome back to one of the last #FormulaFriday Excel blog posts of 2020. Often you will need to display a value as well as percent in the same report. So, more formula (or no formula in this blog post) fun. Today I will show you how to avoid using formulas to do this! Yes, that is right it's not formula Friday really. We go back to one of the best tools in our Excel took kit, the Pivot Table. So, let's quickly build a Pivot Table using a sample data set. A … [Read more...]
- 1
- 2
- 3
- …
- 33
- Next Page »
Recommended Excel Resources
