Still using Excel for your data analysis? Learn how to leverage Python so you can work with larger datasets and automate repetitive tasks.

It is very easy to dissect the contents of a cell in Excel using the functions LEFT, MID, and RIGHT. All three functions are easy to learn.

DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000. It's fallen off current Excel menus, but you can still use ...