From the category archives:

Excel Tips & How-To

How to Move Data in One Row in Excel to One Column

by Michelle MangenMarch 11, 2010 Excel Tips & How-To

A great question came to me today from @SupportMyOffice (Thanks, Jennifer, for making me smarter today!)
Question: I have a bunch of data in one row in Excel and I want to move that data into one column. Is there a one step way to do it?
My first answer: I don’t know! With a  quick Google [...]

Read the full article →

How to Hide Grid Lines in Google Spreadsheets

by Michelle MangenJanuary 27, 2010 Excel Tips & How-To

Google Spreadsheets Tip
I’m not a huge fan of Google Documents, particularly their spreadsheets (yes, I am old school with Microsoft) but when you are working in a virtual capacity they definitely get a win for multiple people being able to make changes simultaneously.
Yesterday I was fine-tuning a sheet that a client had created, knowing the [...]

Read the full article →

Combine data in two different cells into one in Excel

by Michelle MangenNovember 23, 2009 Excel Tips & How-To

Combining two different cells in Excel to have all info in one cell
This Excel formula is really handy, especially if you have a first and last name in two different cells and want to combine them into just one cell so instead of:

Column A=First Name

Column B=Last Name

You will now have Column C=First name and last [...]

Read the full article →

Excel Tip: How to easily find and delete duplicate data

by Michelle MangenNovember 2, 2009 Excel Tips & How-To

Have you been looking for an easy way to find duplicates in Excel?
There are many different formulas and avenues you can take to find duplicate data in Excel. This particular function is my favorite because your list does not have to be in any particular sorted order.
Using this function can save you hours of time, [...]

Read the full article →

Importing contacts from Excel into Outlook

by Michelle MangenOctober 27, 2009 Excel Tips & How-To

If you are in a business that attends a lot of trade shows or you simply have kept all of your Contacts in Excel in the past. There is a quick and efficient way to import all contacts from Excel into Outlook so that you don’t have to manually re-type all of them. Maybe you [...]

Read the full article →

← Previous Entries