CTHR - ADVANCED EXCEL COURSE

ADVANCED EXCEL COURSE

DATE & TIME (Expired)

2 Apr 2024 (Tue) - 9 Apr 2024 (Tue)
12:00 AM

PRICE

HKD 1,480

ORGANISER

Computer Academy

LOCATION

Room 603 Dominion Centre, 43-59 Queen's Road East Wanchai, Hong Kong

DESCRIPTION

The advanced Excel training course targets intermediate Excel users they want to use Excel to analyze , calculate , manage data and prepare management reports.

The course covers a wide range of spreadsheet features including advanced search, consolidating multiple worksheets, database functions, lookup functions, what-if analysis, scenario analysis and data protection. With all these features, students can streamline the repetitive workflow and save a lot of time in their work.

The course is supplemented with lots of real world examples and the adoption of small class size teaching approach can further enhance the overall learning experience of our students.

Naming cells and ranges
Database
Advanced data sorting and subtotal
Using database functions
Managing documents with workbooks
Consolidation with several worksheets
Data table
Lookup table
Document protection
File linking
Filter and advanced filter
Building A Pivottable
Manipulating Your Pivottable
Conditional format
Data validation
What-If Analysis
Inserting a hyperlink to a workbook
Creating and using Macros

For more details and registration, please click here.