Advanced Working with Spreadsheet (Data Analysis and Reporting)
2:15 pm to 5:15 pm
Computer Barn C (Rm.4578, Lift 27-28)

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 conditional formatting. They will familiar with using sorting and filtering and creating a summary report by using Pivot tables.

When
2:15 pm to 5:15 pm
Where
Computer Barn C (Rm.4578, Lift 27-28)
Recommended For
Administration and other staff who are interested
Language
Cantonese
More Information

- Sort data in a range or table
- Advanced Filter
- Import Data
- Consolidate Data from Multiple Worksheets in a Single Worksheet
- Data Validation
- Working with PivotTables

Speakers / Performers:
Instructor from Welkin
Organizer
Information Technology Services Center
Registration

Please click here

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