Calendar and Events

<< Wednesday, September 13, 2017 >>

Wednesday, September 13, 2017

Microsoft Excel PivotTables and PivotCharts (BETEC009)

Course | September 13 | 9-11:30 a.m. |  UCSB SSMS 1303

 Keith Samsell

 Human Resources

"This course details the process by which large data sets are organized, formatted, summarized, and interactively manipulated using Tables, PivotTables, and PivotCharts.

Learning Objectives

* 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 >

Microsoft Excel Database and Lookup Functions (BETEC024)

Course | September 13 | 1:30-4 p.m. |  UCSB SSMS 1302

 Keith Samsell

 Human Resources

"Course Description
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.

Learning Objectives
* Understand the differences between Ranges and Tables.
* Review the...   More >