Training Materials for Administrative Staff (Self-Learning Videos)
ITSC arranges training workshops and seminars throughout the year to keep staff up to date on technology trends, computing awareness, productivity tools and updates on the University’s information and communication technology environment and services.
Available To
Staff
Getting Started
To get access the past training materials, including presentation materials, training guides and videos below.
Microsoft Excel
- Data Analysis and Reporting
| Title | Conducted By | Training Material | Video |
| Data Analysis and Reporting | Welkin Systems | Outline | N/A |
|
Flash Fill |
Welkin Systems | XLSX | |
| Text to Columns | Welkin Systems | XLSX | Video |
| Sorting | Welkin Systems | XLSX | Video |
| Auto Filter | Welkin Systems | XLSX | Video |
| Advanced Filter | Welkin Systems | XLSX | Video |
| Remove Duplicates | Welkin Systems | XLSX | Video |
| Subtotal | Welkin Systems | XLSX | Video |
| PivotTable | Welkin Systems | XLSX | Video |
| PivotTable Slicers | Welkin Systems | XLSX | Video |
Microsoft Excel
- Formula and Functions
| Title | Conducted By | Training Material | Video |
| Formula and Functions | Welkin Systems | Outline | N/A |
| Use Of Built-In Functions | Welkin Systems | XLSX | N/A |
| Structure of a Function | Welkin Systems | As above | |
| Relative and Absolute Reference | Welkin Systems | As above | Video |
| Math and Trig Category | Welkin Systems | As above | Video |
| Statistical Category | Welkin Systems | As above | Video |
| Logical Category | Welkin Systems | As above | Video |
| Date and Time Category | Welkin Systems | As above | Video |
| Lookup and Reference Category | Welkin Systems | As above | Video |
| Database Category | Welkin Systems | As above | Video |
| Formula Auditing | Welkin Systems | XLSX | Video |
| Create or Delete a Macro | Welkin Systems | Video |
Microsoft Excel
- Data Management and Skill Enhancement
| Title | Conducted By | Training Material | Video |
| Data Management and Skill Enhancement | Welkin Systems | Outline | N/A |
|
Data Touchup |
Welkin Systems | ||
| Data Sharing | Welkin Systems | XLSX | Video |
| Advanced Chart Formatting | Welkin Systems | XLSX | Video |
| Using Conditional Formatting | Welkin Systems | XLSX | Video |
| Connect External Data to Your Workbook | Welkin Systems | Video | |
| Skill Enhancement | Welkin Systems | Outline | N/A |
| Shortcut Keys | Welkin Systems | XLSX | Video |
| Setup Popup Alerts for Invalid Data | Welkin Systems | XLSX | Video |
| Consolidate Data Multiple Worksheets in a Single Worksheet | Welkin Systems | Video | |
|
Track Changes in a Shared Workbook |
Welkin Systems | XLSX | Video |
| Using a Shared Workbook to Collaborate | Welkin Systems | Video | |
| Protecting Workbooks and Worksheets | Welkin Systems | Video |
Microsoft PowerPoint
- Advanced Presentation Preparation
| Title | Conducted By | Training Material | Video |
| Advanced Presentation Preparation | Welkin Systems | Outline | N/A |
|
Using Slide Master |
Welkin Systems | HKUST-logo Sample1 Sample2 Sample3 Quiz |
|
| Working with Charts | Welkin Systems | Excel Sample Quiz.pptx Quiz.xlsx |
Video 1 Video 2 |
| Using SmartArt to Create Organization Chart | Welkin Systems | Quiz | Video |
| Using Video and Audio | Welkin Systems | Sample 1 Sample Video Sample Audio Quiz |
Video 1 Video 2 |
| Slide Transitions | Welkin Systems | Sample 1 Quiz |
Video |
| Applying an Animation Effect | Welkin Systems | Sample 1 Quiz |
Video 1 Video 2 |
| Screen Recording | Welkin Systems | Video |
Microsoft Word
- Content Management
| Title | Conducted By | Training Material | Video |
| Content Management | Welkin Systems | Outline | N/A |
|
Automatic Table Layout Control |
Welkin Systems | DOCX Sales Summary Quiz |
|
| Use of Hyperlink | Welkin Systems | Sample 1 Sample 2 Quiz |
Video |
| Using Mail Merge | Welkin Systems | Clients | Video 1 Video 2 |
| Using Macro | Welkin Systems | Quiz Welkin-logo |
|
| Track changes | Welkin Systems | Solar System Quiz |
Video |
Microsoft Word
- Document Setup
| Title | Conducted By | Training Material | Video |
| Document Setup | Welkin Systems | Outline | N/A |
|
Using Styles |
Welkin Systems | Sample 1 Quiz |
|
| Manage Breaks & Paper Settings | Welkin Systems | Sample 1 Quiz |
Video 1 Video 2 |
| Headers and Footers | Welkin Systems | Sample 1 HKUST-Logo Quiz |
Video 1 Video 2 |
| Using Bookmark & Cross-Reference | Welkin Systems | Sample 1 Quiz |
Video |
| Create a Table of Contents | Welkin Systems | Sample 1 Quiz |
Video |
