headermask image

Business Tools Blog

category archive listing Category Archives: Guest Bloggers

Two Macros to Help with Named Ranges in Excel

Two Macros to Help with Named Ranges in Excel

Timesaving Tip for Linking to Pivot Tables

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 […]

Rachelle’s Excel tip - Date Arithmetic

Step by Step instructions on how to manipulate dates in Excel.

Count unique data in a range, exclude duplicates in Microsoft Excel

Formula to count unique data in a list in Microsoft Excel

Wes’s Excel tutorial recommendation

Wes’s Excel tutorial recommendation

Excel 2007, Add Patterns to Charts with this Addin

Add Patterns to Charts with this Free 2007 Excel Addin

The Year 1909

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

Crocs 2/3 off Sale and Free Donuts

Should Changes in Volume Discounts be counted in Net Installs?

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 […]

Free Microsoft Excel Add-in Simplifies Formula Auditing - EXPLODE

XL-Logic’s Explode Macro simplifies auditing formulas in Microsoft Excel.