Excel Tips

We're splitting up
It’s a bad day in spreadsheet land when you have to split your data into columns before you start analyzing. But Excel’s got a new function called TEXTSPLIT that makes splitting...
We're splitting up
It’s a bad day in spreadsheet land when you have to split your data into columns before you start analyzing. But Excel’s got a new function called TEXTSPLIT that makes splitting...

Excel can read minds…kinda
Entering data into Excel can be a mind-numbing task, especially when you have a set list that you have to enter again and again…and again. What if I told you...
Excel can read minds…kinda
Entering data into Excel can be a mind-numbing task, especially when you have a set list that you have to enter again and again…and again. What if I told you...

Let Excel do the work for you
POV: Your boss ordered a sales report that visualizes specific cuts of data in an easy-to-interpret way by the end of week. No big deal! But now it’s lunchtime on...
Let Excel do the work for you
POV: Your boss ordered a sales report that visualizes specific cuts of data in an easy-to-interpret way by the end of week. No big deal! But now it’s lunchtime on...

Sometimes life calls for a Pivot(Table)
Got a convoluted budget sheet? Excel’s PivotTable tool can clean it up in a snap as it filters, sorts, and groups your data. You can get a list of expenses on...
Sometimes life calls for a Pivot(Table)
Got a convoluted budget sheet? Excel’s PivotTable tool can clean it up in a snap as it filters, sorts, and groups your data. You can get a list of expenses on...

Excel's secret function
Who doesn’t love juicy office gossip? Well, do I have a secret to tell you about dates. It’s DATEDIF, Excel’s best-kept secret that calculates the time between two dates. (It’s...
Excel's secret function
Who doesn’t love juicy office gossip? Well, do I have a secret to tell you about dates. It’s DATEDIF, Excel’s best-kept secret that calculates the time between two dates. (It’s...

No mice here
What’s worse than not being able to see your data? Having to manually adjust each individual column width in the column header, that’s what. Thankfully there’s a shortcut for that—and...
No mice here
What’s worse than not being able to see your data? Having to manually adjust each individual column width in the column header, that’s what. Thankfully there’s a shortcut for that—and...