Wednesday, September 13, 2017
Course | September 13 | 9-11:30 a.m. | UCSB SSMS 1303
"This course details the process by which large data sets are organized, formatted, summarized, and interactively manipulated using Tables, PivotTables, and PivotCharts.
* Convert data ranges into Tables to organize and analyze values using single and multi-field sorts, filters, and totals.
* Create Structured Reference Calculations using formulas and functions within... More >
Course | September 13 | 1:30-4 p.m. | UCSB SSMS 1302
This course details a family of related Excel features and function calculations commonly used in conjunction with large data Ranges or Tables. Emphasis is placed on proper use cases and syntax, and introduces alternative methods to view flat file data on a record-by-record basis.
* Understand the differences between Ranges and Tables.
* Review the... More >