Excel Tips, Shortcuts, and Hacks to Streamline Spreadsheets Like a Pro

Excel Tips, Shortcuts, and Hacks to Streamline Spreadsheets Like a Pro

There are plenty of tools—both hardware and software—that are essential to your every day work life. If you’re like many people, Microsoft Excel is probably one of those essential tools. But even with everything you know about Excel, are you truly taking advantage of...
Conditional Formatting with Excel

Conditional Formatting with Excel

This is a guest post from Greg Matoka with the Excelgrm blog. Pop quiz: Look at the table below in Figure CF- 1 and identify all the salespersons whose monthly sales were one standard deviation above average for that month. You have 2 seconds to answer. Sorry, times...
How To: Create Mailing Labels Using Excel and Word

How To: Create Mailing Labels Using Excel and Word

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

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

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

How to Hide Grid Lines in Google Spreadsheets

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

Combine data in two different cells into one in Excel

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