Category: Excel tips


Excel Problems, Fixes and Webinars

Did you get hit by the disappearing Excel add-in affliction recently? After a long couple of weeks, that frustrating Excel problem is finally solved. After spending countless hours on that issue (details below), I...

Numbers Change to Dates in Excel 2

Numbers Change to Dates in Excel

Have you ever copied football scores, such as 3-2, and pasted them into Excel, where they magically transform into dates? It’s certainly annoying when a nice list of numbers change to dates in Excel,...

Excel Roundup 0

Excel Roundup 20160321

In this week’s roundup, Data Analysis, Power BI, combining functions, and more Excel tips. NOTE: There won’t be an Excel Roundup next week (March 28th), due to the Easter Monday holiday.

Excel Roundup 0

Excel Roundup 20160314

Happy Pi Day! In this week’s roundup, troubleshoot large Excel files, free webinars, reporting tips, and much more.

Excel Roundup 0

Excel Roundup 20160229

Happy Leap Year Day! According to my calculations, the next time that Leap Year Day falls on a Monday will be in 2044. By then, Excel will be 58 years old. Do you think...

How to Split Date and Time in Excel 6

How to Split Date and Time in Excel

If you download data into Excel, one column might have a combined date and time value. If you’re going to create reports from that data, it’s usually easier if you have the date and...

Excel Valentine Cards 3

Excel Valentine Cards 2016

If you dread going into a crowded greeting card store this weekend, to shop for a Valentine’s Day Card – you’re in luck! You can make a card in Excel instead, and I’ll show...