Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

These shortcuts work perfectly when you need to use Excel's CHOOSE function to select data based on criteria or apply formatting to specific ranges.

Select cells E3:L16. Go to Data, click the dropdown arrow next to What-if Analysis within the Forecast group, and choose Data Table. The Data Table window will open, asking for inputs into Row input ...

Whether you’re accessing data from internal sources or purchasing data from vendors, due diligence is essential to ensure your findings aren’t skewed or incomplete.