Microsoft Excel for Advanced Users (2010/2013/2016) 2017-09-15T13:56:43+00:00

Project Description

Loading...
 Welkin Course Codes: SE0A, SX3A, SX6A

Course Features

This course is specially designed to help you master Microsoft Excel as a business tool to perform a variety of advanced tasks:

  • Advanced Excel functions to consolidate data to meet business criteria
  • Preparing reports using grouping and consolidation techniques
  • Advanced Data presentation using conditional formatting and charts
  • Allowing users to input correct data using validation rules
  • Protecting documents with passwords

Course topics include:

  • Logical Functions
  • Lookup Functions
  • Database Functions
  • Cell Formatting
  • Conditional Formatting
  • Pivot Tables/PivotChart
  • Sorting and Filtering Data
  • Tracking and Reviewing Changes
  • Data Validation
  • Auditing
  • Macros
  • Passwords & Security Issues
  • and more…

Learn from the Experts

Get Professional Recognition

mos-certificate

Certify your Excel skills with the Microsoft Office Specialist Excel certification. The certification is not a requirement for course completion but we highly recommend you to get your skills professionally recognized.

Remark: The course fee does not include the certification exam.

Further Study

After completing this course you may further develop your knowledge and skills with the course Data Analysis with Microsoft Excel.

Course Fee

$960

Course Duration

6 Hours

Course Prerequisites

Course participants are expected to have foundation skills in Microsoft Excel.

Title of Award

Upon successful completion of the course, students will receive a Certificate of Achievement for the course.

Schedule & Online Enrolment
Enquiry/Booking
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
SE0A-6A25K
 Mongkok
 Cantonese / PC
25/11~2/12
1000-13006 hrs/
2 sessions
SAT960.00
SE0A-17121K
 Mongkok
 Cantonese / PC
1/12~1/12
0930-1230
1400-1700
6 hrs/
2 sessions
FRI960.00
SE0A-6A9C
 Central
 Cantonese / PC
9/12~16/12
1000-13006 hrs/
2 sessions
SAT960.00
SE0A-35C13E
 Central
 English / PC
13/12~15/12
1900-22006 hrs/
2 sessions
WED, FRI960.00
SE0A-18011C
 Central
 Cantonese / PC
12/1~12/1
0930-1230
1400-1700
6 hrs/
2 sessions
FRI960.00
SE0A-18021K
 Mongkok
 Cantonese / PC
21/2~21/2
0930-1230
1400-1700
6 hrs/
2 sessions
WED960.00
SE0A-18031C
 Central
 Cantonese / PC
29/3~29/3
0930-1230
1400-1700
6 hrs/
2 sessions
THU960.00
SE0A-18041K
 Mongkok
 Cantonese / PC
24/4~24/4
0930-1230
1400-1700
6 hrs/
2 sessions
TUE960.00
SE0A-18051C
 Central
 Cantonese / PC
25/5~25/5
0930-1230
1400-1700
6 hrs/
2 sessions
FRI960.00
SE0A-18061K
 Mongkok
 Cantonese / PC
29/6~29/6
0930-1230
1400-1700
6 hrs/
2 sessions
FRI960.00
SE0A-18071C
 Central
 Cantonese / PC
27/7~27/7
0930-1230
1400-1700
6 hrs/
2 sessions
FRI960.00
SE0A-18081K
 Mongkok
 Cantonese / PC
30/8~30/8
0930-1230
1400-1700
6 hrs/
2 sessions
THU960.00
SE0A-18091C
 Central
 Cantonese / PC
21/9~21/9
0930-1230
1400-1700
6 hrs/
2 sessions
FRI960.00
SE0A-18101K
 Mongkok
 Cantonese / PC
30/10~30/10
0930-1230
1400-1700
6 hrs/
2 sessions
TUE960.00
SE0A-18111C
 Central
 Cantonese / PC
30/11~30/11
0930-1230
1400-1700
6 hrs/
2 sessions
FRI960.00
SE0A-18121K
 Mongkok
 Cantonese / PC
28/12~28/12
0930-1230
1400-1700
6 hrs/
2 sessions
FRI960.00
Microsoft Excel 2010 for Advanced Users
Complete your Enrol
How to enrol/pay online
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
SX3A-12C4K
 Mongkok
 Cantonese / PC
4/12~5/12
1900-22006 hrs/
2 sessions
MON, TUE960.00
SX3A-13C11E
 Central
 English / PC
11/12~13/12
1900-22006 hrs/
2 sessions
MON, WED960.00
SX3A-17121C
 Central
 Cantonese / PC
12/12~12/12
0930-1230
1400-1700
6 hrs/
2 sessions
TUE960.00
SX3A-35C13C
 Central
 Cantonese / PC
13/12~15/12
1900-22006 hrs/
2 sessions
WED, FRI960.00
SX3A-6A35K
 Mongkok
 Cantonese / PC
6/1~13/1
1000-13006 hrs/
2 sessions
SAT960.00
SX3A-6D20C
 Central
 Cantonese / PC
20/1~20/1
1000-1300
1400-1700
6 hrs/
2 sessions
SAT960.00
SX3A-6A20E
 Central
 English / PC
20/1~27/1
1000-13006 hrs/
2 sessions
SAT960.00
SX3A-18011K
 Mongkok
 Cantonese / PC
26/1~26/1
0930-1230
1400-1700
6 hrs/
2 sessions
FRI960.00
SX3A-12C12K
 Mongkok
 Cantonese / PC
12/2~13/2
1900-22006 hrs/
2 sessions
MON, TUE960.00
SX3A-45C22C
 Central
 Cantonese / PC
22/2~23/2
1900-22006 hrs/
2 sessions
THU, FRI960.00
SX3A-18021C
 Central
 Cantonese / PC
27/2~27/2
0930-1230
1400-1700
6 hrs/
2 sessions
TUE960.00
SX3A-45C78E
 Central
 English / PC
8/3~9/3
1900-22006 hrs/
2 sessions
THU, FRI960.00
SX3A-18031K
 Mongkok
 Cantonese / PC
13/3~13/3
0930-1230
1400-1700
6 hrs/
2 sessions
TUE960.00
SX3A-24C20K
 Mongkok
 Cantonese / PC
20/3~22/3
1900-22006 hrs/
2 sessions
TUE, THU960.00
SX3A-34C28C
 Central
 Cantonese / PC
28/3~29/3
1900-22006 hrs/
2 sessions
WED, THU960.00
SX3A-18041C
 Central
 Cantonese / PC
13/4~13/4
0930-1230
1400-1700
6 hrs/
2 sessions
FRI960.00
SX3A-6A94E
 Central
 English / PC
14/4~21/4
1000-13006 hrs/
2 sessions
SAT960.00
SX3A-51C20E
 Central
 English / PC
20/4~23/4
1900-22006 hrs/
2 sessions
MON, FRI960.00
SX3A-13C30K
 Mongkok
 Cantonese / PC
30/4~3/5
1900-22006 hrs/
2 sessions
MON, THU960.00
SX3A-35C2K
 Mongkok
 Cantonese / PC
2/5~4/5
1900-22006 hrs/
2 sessions
WED, FRI960.00
SX3A-6A12C
 Central
 Cantonese / PC
12/5~19/5
1000-13006 hrs/
2 sessions
SAT960.00
SX3A-18051K
 Mongkok
 Cantonese / PC
16/5~16/5
0930-1230
1400-1700
6 hrs/
2 sessions
WED960.00
SX3A-6A19C
 Central
 Cantonese / PC
19/5~26/5
1000-13006 hrs/
2 sessions
SAT960.00
SX3A-12C82E
 Central
 English / PC
21/5~28/5
1900-22006 hrs/
2 sessions
MON960.00
SX3A-6A34E
 Central
 English / PC
2/6~9/6
1000-13006 hrs/
2 sessions
SAT960.00
SX3A-12C11K
 Mongkok
 Cantonese / PC
11/6~12/6
1900-22006 hrs/
2 sessions
MON, TUE960.00
SX3A-6A36K
 Mongkok
 Cantonese / PC
16/6~23/6
1000-13006 hrs/
2 sessions
SAT960.00
SX3A-18061C
 Central
 Cantonese / PC
25/6~25/6
0930-1230
1400-1700
6 hrs/
2 sessions
MON960.00
SX3A-45C32C
 Central
 Cantonese / PC
28/6~29/6
1900-22006 hrs/
2 sessions
THU, FRI960.00
SX3A-6A39E
 Central
 English / PC
30/6~7/7
1000-13006 hrs/
2 sessions
SAT960.00
SX3A-18071K
 Mongkok
 Cantonese / PC
19/7~19/7
0930-1230
1400-1700
6 hrs/
2 sessions
THU960.00
SX3A-45C33K
 Mongkok
 Cantonese / PC
26/7~27/7
1900-22006 hrs/
2 sessions
THU, FRI960.00
SX3A-13C32C
 Central
 Cantonese / PC
6/8~8/8
1900-22006 hrs/
2 sessions
MON, WED960.00
SX3A-24C32E
 Central
 English / PC
14/8~16/8
1900-22006 hrs/
2 sessions
TUE, THU960.00
SX3A-18081C
 Central
 Cantonese / PC
15/8~15/8
0930-1230
1400-1700
6 hrs/
2 sessions
WED960.00
SX3A-6A8K
 Mongkok
 Cantonese / PC
8/9~15/9
1000-13006 hrs/
2 sessions
SAT960.00
SX3A-35C32C
 Central
 Cantonese / PC
19/9~21/9
1900-22006 hrs/
2 sessions
WED, FRI960.00
SX3A-18091K
 Mongkok
 Cantonese / PC
26/9~26/9
0930-1230
1400-1700
6 hrs/
2 sessions
WED960.00
SX3A-45C33E
 Central
 English / PC
27/9~28/9
1900-22006 hrs/
2 sessions
THU, FRI960.00
SX3A-18101C
 Central
 Cantonese / PC
24/10~24/10
0930-1230
1400-1700
6 hrs/
2 sessions
WED960.00
SX3A-18111K
 Mongkok
 Cantonese / PC
26/11~26/11
0930-1230
1400-1700
6 hrs/
2 sessions
MON960.00
SX3A-18121C
 Central
 Cantonese / PC
19/12~19/12
0930-1230
1400-1700
6 hrs/
2 sessions
WED960.00
Microsoft Excel 2013 for Advanced Users
Complete your Enrol
How to enrol/pay online
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
SX6A-6A2E
 Central
 English / PC
2/12~9/12
1000-13006 hrs/
2 sessions
SAT960.00
SX6A-6A2K
 Mongkok
 Cantonese / PC
2/12~9/12
1000-13006 hrs/
2 sessions
SAT960.00
SX6A-51C8E
 Central
 English / PC
8/12~11/12
1900-22006 hrs/
2 sessions
MON, FRI960.00
SX6A-13C11C
 Central
 Cantonese / PC
11/12~13/12
1900-22006 hrs/
2 sessions
MON, WED960.00
SX6A-6D6C
 Central
 Cantonese / PC
6/1~6/1
1000-1300
1400-1700
6 hrs/
2 sessions
SAT960.00
SX6A-45C11K
 Mongkok
 Cantonese / PC
11/1~12/1
1900-22006 hrs/
2 sessions
THU, FRI960.00
SX6A-6A20E
 Central
 English / PC
20/1~27/1
1000-13006 hrs/
2 sessions
SAT960.00
SX6A-12C12C
 Central
 Cantonese / PC
12/2~13/2
1900-22006 hrs/
2 sessions
MON, TUE960.00
SX6A-6D24K
 Mongkok
 Cantonese / PC
24/2~24/2
1000-1300
1400-1700
6 hrs/
2 sessions
SAT960.00
SX6A-45C1E
 Central
 English / PC
1/3~2/3
1900-22006 hrs/
2 sessions
THU, FRI960.00
SX6A-6A17C
 Central
 Cantonese / PC
17/3~24/3
1000-13006 hrs/
2 sessions
SAT960.00
SX6A-34C28K
 Mongkok
 Cantonese / PC
28/3~29/3
1900-22006 hrs/
2 sessions
WED, THU960.00
SX6A-6A21E
 Central
 English / PC
21/4~28/4
1000-13006 hrs/
2 sessions
SAT960.00
SX6A-51C32C
 Central
 Cantonese / PC
4/5~7/5
1900-22006 hrs/
2 sessions
MON, FRI960.00
SX6A-6A32K
 Mongkok
 Cantonese / PC
12/5~19/5
1000-13006 hrs/
2 sessions
SAT960.00
SX6A-12C11E
 Central
 English / PC
11/6~12/6
1900-22006 hrs/
2 sessions
MON, TUE960.00
SX6A-35C20C
 Central
 Cantonese / PC
20/6~22/6
1900-22006 hrs/
2 sessions
WED, FRI960.00
SX6A-45C28K
 Mongkok
 Cantonese / PC
28/6~29/6
1900-22006 hrs/
2 sessions
THU, FRI960.00
SX6A-35C25E
 Central
 English / PC
25/7~27/7
1900-22006 hrs/
2 sessions
WED, FRI960.00
SX6A-6A4C
 Central
 Cantonese / PC
4/8~11/8
1000-13006 hrs/
2 sessions
SAT960.00
SX6A-51C10K
 Mongkok
 Cantonese / PC
10/8~13/8
1900-22006 hrs/
2 sessions
MON, FRI960.00
SX6A-6A8E
 Central
 English / PC
8/9~15/9
1000-13006 hrs/
2 sessions
SAT960.00
SX6A-45C20C
 Central
 Cantonese / PC
20/9~21/9
1900-22006 hrs/
2 sessions
THU, FRI960.00
SX6A-6A22K
 Mongkok
 Cantonese / PC
22/9~29/9
1000-13006 hrs/
2 sessions
SAT960.00
Microsoft Excel 2016 for Advanced Users
Complete your Enrol
How to enrol/pay online

Microsoft Excel for Advanced Users is a 6-hour course focusing on the advanced features of Excel such as data management, data analysis, macro, customization, data import/export, data protection, etc.

You will learn:

  • Advanced Excel functions to consolidate data to meet business criteria
  • Co-authoring documents by enabling document sharing and track changes
  • Searching and analyzing data with advanced criteria
  • Preparing reports by grouping and consolidation techniques
  • Advanced Data presentation by using conditional formatting and charts
  • Exchanging data between software by using plain text files
  • Allowing users to input correct data by applying validation rules
  • Protecting documents with passwords
  • An overview of task automation by using Macros
  1. Logical Functions
    • IF
    • AND
    • OR
  2. Lookup Functions
    • VLOOKUP
    • HLOOKUP
  3. Database Functions
    • DSUM
    • DMIN
    • DMAX
    • DCOUNT
    • DAVERAGE
  4. Cell Formatting
    • Applying styles to a range
    • Conditional formatting
  5. Pivot Tables.
    • Creating and using a pivot table
    • Filtering and sorting data within a pivot table
    • Automatically grouping data in a pivot table and renaming groups
    • Manually grouping data in a pivot table and renaming groups
  6. Input Tables
    • One-input data tables
    • Two-input data tables
  1. Importing Text Files
    • What is a delimited text file?
    • Importing a delimited text file
  2. Sorting and Filtering Data.
    • Sorting data by multiple columns at the same time
    • Applying a pre-installed custom sort
    • Creating a customized list and performing a custom sort
    • Using AutoFilter
    • Removing all AutoFilters from a worksheet
    • Advanced Filter Criteria
    • Sub-totalling
    • Removing subtotals
  3. Tracking and Reviewing Changes.
    • Enabling or disabling the ‘track changes’ feature
    • Sharing, comparing and merging worksheets
  4. Validating
    • Data validation – Whole number
    • Data validation – List
    • Data validation – Date
    • Customising a validation input message and error alert
    • Removing data validation
  5. Auditing
    • Tracing precedent cells
    • Tracing dependent cells
    • Showing all formulas in a worksheet, rather than the resulting values
    • Inserting and viewing comments
    • Editing and deleting comments
    • Showing and hiding comments
  6. Macros
    • Macro to change the page set-up
    • Macro to apply a custom number format
    • Macro to format a cell range
    • Macro to insert fields into the header or footer
    • Assigning a macro to a button on the Quick Access toolbar
    • Deleting macros
  7. Passwords & Security Issues
    • Adding ‘open’ password protection to a workbook.
    • Adding ‘modify’ password protection to a workbook.
    • Removing an ‘open’ password from a workbook.
    • Removing a ‘modify’ password from a workbook.
    • Password protecting cells and worksheets.
    • Hiding formulas.
    • Un-hiding formulas.
  1. Applying Conditional Formatting
    • Adding, changing, conditional formats
    • Clearing conditional formats4
    • Apply conditional formatting to quickly analyse data4
  2. Inserting subtotals in a list of data in a worksheet
    • Inserting subtotals
    • Removing subtotals
  3. Filter by using advanced criteria
    • Advanced Filter
    • Comparison operators
    • Advanced Filter – Criteria Examples
  4. Using PivotTables / PivotChart to analyze & present your data
    • Creating a PivotTable or PivotChart
    • Changing the format of your PivotTable report
    • Showing PivotTable details
    • Calculating PivotTable values
    • Changing or updating PivotTable data
  5. Creating a formula by using a function
    • About the syntax of functions
    • Creating a formula by using a function
    • Logical function
    • Lookup function
    • Database functions
  1. Importing Data
    • Importing a text file
    • Connecting external data to your workbook – From Web
  2. Data Validation
    • Overview of data validation
    • Adding data validation to a cell or range
    • Display an optional input message
    • Specify an optional alert or error message when invalid data is entered.
  3. Using a shared workbook to collaborate
    • Sharing a workbook
    • Stop sharing a workbook
    • Track changes in a shared workbook
  4. Password protect worksheet or workbook elements
    • Protecting your with passwords, permission, and other restrictions
    • Protecting worksheet elements
    • Removing protection from a workbook/ worksheet
  5. Macro
    • Recording a macro
    • Running a macro
    • Adding a macro button to the Quick Access Toolbar
    • Deleting a macro
  1. Using Conditional Formatting
    • Format all Cells by using Data Bars
    • Format all Cells by using an Icon Set
    • Format only Cells that contain Text, Number, or Date or Time Values
    • Format only Top or Bottom Ranked Values
    • Format only Values that are Above or Below Average
    • Format only Unique or Duplicate Values
    • Use a Formula to determine which Cells to Format
    • Apply Conditional Formatting by using Quick Analysis
    • Clear Conditional Formats
  2. Creating a Formula by using a Function
    • Creating a Formula by using a Function
    • Logical Function
    • Lookup Function
    • Database Functions
  3. Data Management
    • Analyze your Data instantly
    • Sort Data in an Excel Worksheet
    • Sort Data using a Custom List
    • Filter by using Advanced Criteria
    • Remove a Filter
    • Remove Duplicate Values
    • What is Subtotals
    • Insert Subtotals in a List of Data in a Worksheet
  4. Connect External Data to your Workbook
    • Importing Text Files
    • Using Text to Columns
  5. Working with PivotTables
    • Create a Recommended PivotTable
    • Create a PivotTable manually
    • Change the Data Layout of a PivotTable
    • Sorting Data in a PivotTable
    • Filter data in a PivotTable
    • Group or Ungroup Data in a PivotTable Report
    • Use the Field List to arrange Fields in a PivotTable
    • Update (Refresh) Data in a PivotTable
    • Create a PivotChart
  1. Consolidate Data from Multiple Worksheets in a Single Worksheet
    • Consolidate Data by Position
    • Consolidate Data by Category
    • Use a Formula to Consolidate Data
  2. Using a Shared Workbook to Collaborate
    • Sharing a Workbook
    • Merge Changes
    • Resolve Conflicting Changes in a Shared Workbook
    • Edit a Shared Workbook
    • Remove a User from a Shared Workbook
    • Stop Sharing a Workbook
    • Features a Shared Workbook doesn’t Support
  3. Track changes in a Shared Workbook
    • Overview of Change Tracking
    • Turn on Change Tracking for a Workbook
    • Highlight Changes as you work
    • View Tracked Changes
    • Accept and Reject Changes
    • View the History Worksheet
    • Changes that Excel does not Track or Highlight
    • Turn off Change Tracking for a Workbook
  4. Protecting Workbooks and Worksheets
    • Protect a Worksheet with or without a Password
    • Lock Cells to Protect them
    • Unlock Protected Cells
    • Hide and Protect Formulas
    • Protect a Workbook
    • Remove a Password from a Worksheet or Workbook
    • Change the Password for my Workbook or Worksheet
  5. Create or Delete a Macros
    • Record a Macro
    • Run an Excel Macro
    • Delete a Macro
  1. Proceed with on-line registration or send the completed enrolment form (download) to us together with a cheque (made payable to Welkin Compuer Training) for the program fee.
  2. CEF applicants have to complete the CEF Application Form (download) and send it to us for certification. They will then send the form to the Office of the Continuing Education Fund, Room 916, 9/F, Kwai Hing Government Offices, 166-174 Hing Fong Road, Kwai Chung, New Territories, together with a photocopy of their HKID Card before course commencement.
  3. Applicants will receive application results from the Office of the CEF within 14 working days.

 

You may also be interested in