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

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

VLookup Week at ExcelDashboardTemplates.com

The Awesome Mr. Excel has started a VLOOKUP week.  Much like Shark Week, all the Excel sites around the web are posting VLOOKUP learning...
Want to Receive the Next Post?
Join My Newsletter
Give it a try, you can unsubscribe anytime.
Privacy Policy
Subscribe Now!   (Privacy Policy)

Stay Connected!

Get the latest post emailed straight to your inbox!