Your Excel formulas cheat sheet: 22 tips for calculations and common tasks. Max Productivity By JD Sartain, Dec 29, 2019 11:06 pm PST. dmasaoka@idgcommunications.com.

This cheat sheet gets you up to speed on the features that have been introduced or changed in Microsoft 365’s Excel for Windows desktop client over the past few years.

If you need a refresher, see our Excel 2010 cheat sheet. As in Excel 2013, the Ribbon in Excel 2016 and 2019 has a flattened look that’s cleaner and less cluttered than in Excel 2010 and 2007.

Applying the GAAP to Excel is as simple as using the GAAP categories and formulas to calculate such accounting categories as inventory, taxation, profit and depreciation. Create a balance sheet ...