Category Archives: Rachelle HaidRachelle 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 […]
Step by Step instructions on how to manipulate dates in Excel.
Formula to count unique data in a list in Microsoft Excel
Add Patterns to Charts with this Free 2007 Excel Addin
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 […]
Question from Rachelle Haid
We have a large order volume from a single customer this month. Some of these orders are adds and some are drops. The customer has a porting clause in their Service Agreement. Should I count the adds as new sales and the drops as disconnects, or should I net the amounts and only […]
© 2007 Business Tools Blog. Powered by Wordpress wearing MyJournal Hypereal by 
BlogoSquare
There are currently 604 posts extending over categories with loads upto 440 comments with valid XHTML and CSS.
