headermask image

Business Tools Blog

category archive listing Category Archives: Excel

Wes’s suggestion on how to get rid of the Excel Ribbon

Unfortunately the author didn’t use spell check, but this is a super easy way to get rid of the Excel Ribbon.  (Maybe there is hope for a few un-named Zayo-ites who are still holding onto Microsoft Office 2003.
Get Rid of the Ribbon

With Microsoft 2007 my Excel links to PowerPoint keep breaking

With Microsoft 2007 my Excel links to PowerPoint keep breaking

Ribbon Hero - a Game that helps you learn Microsoft 2007 & 2010

Ribbon Hero - a Game that helps you learn Microsoft 2007 & 2010

How to Password Protect an Excel File

Password protect an Excel file

Unhide All Hidden Sheets in Excel with one Mouse Click

Unhide multiple Microsoft Excel worksheets with a simple macro

Beginning of the Month Function in Excel

Yesterday Ting Liu, Finance Lead at Zayo Bandwidth, asked if Excel had a function to calculate the first day of the month.  Great question …
A prior post showed how to use the EOMONTH function.  EOMONTH returns the last day of the month.
You can also use EOMONTH, to calculate the first day of the month.

=EOMONTH(A1,-1)+1
In the […]

Convert a Number with Currency in Excel into a Spelled/Written Word for use in Mail Merge

Convert a Number with Currency in Excel into a Spelled/Written Word for use in Mail Merge

Manage and Delete Multiple Names in Excel Workbooks

Manage Names in Excel.

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