Category: Excel tips

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