Although you don't have to format your data as an Excel table, doing so will make life easier if you add more rows or columns, and Excel generally reads data formatted as a table ...

Just as Excel can perform basic data analysis functions, it has a surprising number of data visualization tools ... SUM requires more manipulation. Three PivotTables on the right sum up the ...

Excel workbooks are the next step after you ... in the database functions and the capacity to calculate spreadsheets three-dimensionally. This means you can calculate columns (down), rows ...