These four overlooked Excel features completely changed how I design spreadsheets.

We all know that Excel can make some gorgeous charts and graphs, but if you are like 30 Rock's Liz Lemon and don't know your scatter plot from your triangle graph ("I don't know. It sounded real!"), ...

Transition from user to developer through consistent notation, table-based architecture, global constants, and ...

TLDR: Microsoft Excel won’t be a mystery anymore with the expert-led training found in The Complete Excel Pro Tips Certification Bundle, now under $20. “Facts are stubborn things, but statistics are ...

Microsoft Excel is an extremely powerful tool for organizing, analyzing, and manipulating data. But it's only as useful as its user is knowledgeable in how to use it. Few of us are true Excel experts ...

If you have to send the same worksheet to a number of people every week, it probably takes you quite awhile to prepare the e-mail. If you have to do this for a number of reports, it can take even ...

Use Excel’s built-in features to simplify data entry Your email has been sent Entering data into a worksheet can be time-consuming, and mistakes often find their way in -- but with the right tools, ...