Tag: Formula

Excel Formula Formatting Quick Tip Learn the best Excel Formula Formatting technique so that you can quickly edit them in the future! You will use...

In a  recent Friday Challenge, you were tasked with creating a formula that would work out for a non-contiguous (not connected) range that ignored...

In a previous Friday’s challenge, I presented the following user request. Here was the question again and what you would have seen in the download...

Alright, this challenge was posted by a fan in on my Youtube Channel.  It was posted for this video: “Splitting Cell Text and Numbers...

Okay, I posted this Excel Chart Challenge on Friday.  How did you do?  I am sure your solution is better than mine.  This was...

Okay, apologies again .  I have been so swamped with my Go-Live project this week that I have been too tired to finish the...

Frequently I have to take other data sets and make sense of them.  Sometimes there is very little sense of the data, but every...

Yesterday I posted a quick tutorial on protecting your Excel Dashboard Charts by using Array Formulas. You can check out that posting here: Protecting Your Excel...

Recently during a Project that was using Salesforce.com, I created a custom report and then exported the results to Excel.  This report looked and...

The Awesome Mr. Excel has started a VLOOKUP week.  Much like Shark Week, all the Excel sites around the web are posting VLOOKUP learning...