headermask image

Business Tools Blog

Monthly Archives: November 2009

Bring out your inner rock star!

By week we use business tools, but on the weekends we can be anything we want to be - even a rockstar!
Have you ever wanted to play the guitar, but expensive lessons were out of reach? Check out Gibson’s free lessons at http://www.gibson.com/en-us/Lifestyle/Lessons/
The lesson will be even more fun if you have a Gibson Les […]

All is not Lost! How to find lost files

How to find lost files in the OLK file

I have an iTunes song and need to convert it to a wav format

I have an iTunes song and need to convert it to a wav format

Have you used Google Scholar?

Google Scholar was launched in November 2004, but few seem to know that it’s out there.   If you used Google Scholar before, you might be pleasantly surprised. (Google claims that many bugs have been resolved)  Use Advanced Scholar Search for the best results.  Google explains:
What is Google Scholar?
Google Scholar provides a simple way to […]

Mail Merge Toggle Information for Dates

This is a guest blog from Cybelle Simoneau a valued member of Zayo Bandwidth’s legal team.
I found this helpful info online in case you ever need it.  For a date to appear “normal”  you use    \@ “MMMM d, yyyy”
Formatting dates:
1. right click on the field name e.g. > - see pop-up menu.
2. click on the […]

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

Avoid the Facebook FarmVille Scam, and warn your kids

Avoid the Facebook FarmVille Scam, and warn your kids

Generate Sales Leads with Marketing Lists

Generate Sales Leads with Marketing Lists

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.