In this course the student will learn how to convert rows and columns of data into a table, and then use an Excel Table to manage that data independently from the data in other rows and columns on the worksheet. Table features include: sorting and filtering; formatting table data; inserting and deleting table rows and columns; using a calculated column; and displaying and calculating table data totals. Pivot Tables are another powerful tool that can be used to summarize thousands of rows of data in a matter of seconds. You can then change your analysis on the fly by simply moving data from one area of the pivot table to another area. You can group, sort, and filter pivot table data, perform calculations within the pivot table, and add and remove subtotals and grand totals with ease. And finally, you can create charts that can be filtered on the fly just like the pivot table.
