Home Tags Formula

Tag: Formula

Excel Formula Formatting Quick Tip

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...

Friday Challenge – AverageIf NOT Blank or NOT Zero with Negative Values for Non-Contiguous...

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...

Test Your Excel Knowledge

Ever wondered how much knowledge you have of Excel? Well now is the time to find out . I have created a quick quiz that you...

How-to Make a Dynamic Hotel Ballroom Occupancy Chart

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...

Friday Challenge – Splitting Up Email Address Text with Excel Formulas

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

How-to Eliminate Statistical Outliers in an Excel Line Chart

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

Friday Challenge – Eliminating outliers in and Excel Chart

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

Getting to Know Excel Text Fuctions and Functions

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

Removing Array Formulas Around Your Excel Charts and Dashboards

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...

What to Do When Formulas Don’t Work from an Exported Salesforce.com Report or CSV...

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...

Popular Posts

How-to Easily Create a Stacked Clustered Column Chart in Excel

Create a Stacked Clustered Column Chart in Excel There is one type of chart that is always requested, however, Excel doesn’t offer this type of...
Want to Receive the Next Post?
Join My Newsletter
Give it a try, you can unsubscribe anytime.
Privacy Policy
We Know You Better!
Subscribe To Our Newsletter
Be the first to get latest updates and
exclusive content straight to your email inbox.
Yes, I want to receive updates
No Thanks!
Subscribe Now!   (Privacy Policy)

Stay Connected!

Get the latest post emailed straight to your inbox!