Microsoft Excel is an incredibly capable and complex spreadsheet program. If you’re just getting your feet wet, these tips will help you get started on making a spreadsheet and writing a formula. Once ...

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

Constants: This is the fastest way to audit a spreadsheet for errors. It finds every cell that contains a manually typed ...

Software packages for charting data often offer menus; i.e., lists of charts that are available. Excel offers a menu; Tableau has Show Me! Elementary statistics and graphing books offer recipes; i.e., ...

DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000, which is the only version that explains how this function works.