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
-
Archives
Category Archives: ExcelUnfortunately 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
Ribbon Hero - a Game that helps you learn Microsoft 2007 & 2010
Unhide multiple Microsoft Excel worksheets with a simple macro
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
Manage Names in Excel.
Two Macros to Help with Named Ranges in Excel
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 […]