From the category archives:

Excel Tips & How-To

How To: Create Mailing Labels Using Excel and Word

by Michelle MangenDecember 10, 2011 Excel Tips & How-To
I haven’t done an Excel tutorial in a really long time. I used to create one from every “how do you do this in Excel” request that I got on Twitter, via email or Facebook. A Twitter friend asked yesterday and this is actually really helpful for those who are sending out holiday cards or [...]

Read the full article →

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

by Michelle MangenMarch 11, 2010 Excel Tips & How-To
How to move data in Excel from Rows to Columns 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 [...]

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, [...]

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

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

Read the full article →

← Previous Entries