Don't-Miss Business Software Stories

microsoft excel logo primary

Meet DATEDIF(), Excel’s secret Date & Time function that's still handy

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 it. Here's how.

microsoft excel logo primary

Excel Date and Time functions: WEEKNUM, ISOWEEKNUM, WORKDAY, WORKDAY.INTL

Bookkeepers, project managers, HR departments and more use the Excel Date & Time functions WEEKNUM, ISOWEEKNUM, WORKDAY, WORKDAY.INTL to calculate time. Here's how.

microsoft excel logo primary

Excel tips: 6 slick shortcuts, handy functions and random-number generators

You can't have too many Excel tips. These cover some handy shortcuts, and useful functions for calculation payments or generating random numbers.

microsoft excel logo primary

Excel formula tips: How to troubleshoot by tracing dependents and precedents

In Excel, when you need to debug a complex web of formulas, you need to trace dependent and precedent formulas. Here's how they work.

microsoft excel logo primary

Excel 2016 charts: How to use the new Pareto, Histogram, and Waterfall formats

Excel 2016's many new features include six new chart types. Here we cover Histogram, Pareto, and Waterfall, which cover statistical, trend, and other relationships.