Advanced Working with Spreadsheet (Data Analysis and Reporting)
2:15 pm - 5:15 pm
Online via Zoom

Excel is commonly used in data analysis and reporting, but few people can use it truly effectively.  For example, many may know how to perform simple sorting or filtering, but most are at a loss to do it to meet specific criteria. After the course, candidates could understand the usage of flash fill. They will familiar with using sorting and filtering and creating a summary report by using Pivot tables.

2:15 pm - 5:15 pm
Online via Zoom
Recommended For
Administration and other staff who are interested
More Information

1. Using Flash Fill
2. Split Text into Different Columns with the Convert Text to Columns Wizard
3. Using Sorting
4. Filtering Data Using Complex Criteria
5. Using PivotTable
6. Use Slicers to Filter Data in PivotTable

Speakers / Performers:
Instructor from Welkin
Information Technology Services Center

Please click here

Post an event
Campus organizations are invited to add their events to the calendar.