January 13, 2010 – 12:50 am
Password protect an Excel file
November 13, 2009 – 12:00 am
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 […]
November 5, 2009 – 12:16 am
Convert a Number with Currency in Excel into a Spelled/Written Word for use in Mail Merge
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.
October 13, 2009 – 12:30 am
Fix stretchy pictures in Microsoft Excel.
September 29, 2009 – 12:08 am
Have you ever needed to sort a list in a certain order vs. alphabetical or numerical? Believe it or not, you can do this in Excel … you just need to create a custom list first.
For this example, I want to sort my regions in the below order vs. alphabetical:
Step 1 is to create a […]
September 22, 2009 – 12:28 am
Formula to count unique data in a list in Microsoft Excel
Category Archives: 
BlogoSquare