Here’s a quick guided tour to the Excel 2007 interface: The Microsoft Office button. The big button on the upper left-hand corner of the screen replaces the old File menu from previous versions ...

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.

4. =CONCATENATE This is another keeper if you import a lot of data into Excel. This formula joins (or merges) the contents of two or more fields/cells into one.

Excel's main function is to interlink cells, through the use of formulas, so that the formula cell changes when data is inputted into linked cells. The best way to store information in spreadshee ...