Quantcast
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

0
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

4
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

4
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

0
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

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

4
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

0
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
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link