November 3, 2009 – 12:19 am
Two Macros to Help with Named Ranges in Excel
November 2, 2009 – 12:15 am
Rachelle Haid is a valued member of Zayo Bandwidth’s team. She is an Excel wiz and has the following tip for linking to Pivot tables, without having a strange pivot table named range show up in your formula:
Linking to a cell in pivot table so you don’t get the get pivot in your cell, check […]
October 21, 2009 – 12:15 am
Step by Step instructions on how to manipulate dates in Excel.
September 22, 2009 – 12:28 am
Formula to count unique data in a list in Microsoft Excel
September 15, 2009 – 12:28 am
Wes’s Excel tutorial recommendation
Add Patterns to Charts with this Free 2007 Excel Addin
Wes Kimmey sent this along, and we thought you’d enjoy.
THE YEAR 1909
What a difference a century makes!
Here are some statistics for the Year 1909 :
************ ********* ********* ******
The average life expectancy was 47 years.
Only 14 percent of the homes had a bathtub.
Only 8 percent of the homes had a telephone.
There were only 8,000 cars and only […]
Crocs 2/3 off Sale and Free Donuts
Question from Rachelle Haid
This month we installed service to a customer who has a volume discount. This installation caused them to meet a threshold where they will get a larger discount on every active service that they have with us. Should we count the increased discount in net installs.
Answer:
Since we define net installs as the change […]
XL-Logic’s Explode Macro simplifies auditing formulas in Microsoft Excel.