VLOOKUP Here, I have a list of exam grades and the scores required for each grade (let's call this table 1). I also have a table containing students' scores (table 2 from this point).

Figure E The SharePoint list contains the same records as the Excel table. You will have full access to the data and the structure. Those you share the list with can view and edit the data.

There are a few ways to count the number of items in an Excel list, depending on the data you have. One way is using the COUNTIF function.

Excel tables provide superior tools for working with data in list form. If you want to sum columns of data automatically so that the totals show only the sum of visible cells (for example), Excel ...

Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns. When you need to expand the table layout, apply the Home ...

To create the PivotTable, click somewhere in the list of data, choose the Insert tab, and click PivotTable. Excel will automatically select the area containing the data, including the headings.