Project Description


Welkin Course Code: PET6, PET0

Course Features

Microsoft Excel is widely used amongst all expertise. Most users have some basic understanding of Excel, but may need a hand when it comes to the operating the special features. There are many functions and tips which users can benefit from to achieve better results in their Excel practice. This course is suitable for general users to participate, where classes go through practical use and focuses on a variety of Excel tips, application skills and troubleshooting.

  • Workbook and worksheet management
  • Hacking Excel’s built-in features
  • Hacking Pivot Table
  • Naming Hacks
  • Hack formulas and functions
This course would let you be more productive and effective in Microsoft Excel, and it is a good preparation for those taking the Microsoft Office Specialist certification.
  • Qualified and experienced instructors
  • Weekdays and weekend classes available

Learn from the Experts

Get Your Skills Certified

Certify your Excel skills with 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 in Microsoft Excel with the CEF reimbursable course Business Analysis with Microsoft Excel.

Course Fee


Course Duration

6 Hours

Course Prerequisites

Course participants should have a basic knowledge of Microsoft Excel.

Title of Award

Upon successful completion of the course, students will receive a certificate of achievement.

Sign up for your course by clicking the Enrol button and proceed to Checkout to finish course registration.

Practical Excel Tips for Office Professionals 2016
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名
PET6-19101KCantonese / PC / MongKok28-Oct28-OctMON0930-1230;1400-17006 hours / 2 sessions20191028


PET6-19111CCantonese / PC / Central18-Nov18-NovMON0930-1230;1400-17006 hours / 2 sessions20191118


PET6-19121CCantonese / PC / Central20-Dec20-DecFRI0930-1230;1400-17006 hours / 2 sessions20191220


Practical Excel Tips for Office Professionals 2010
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名

Practical Excel Tips for Office Professionals is a 6-hour course designed for those who have some background knowledge in Excel. The course focuses on the advanced features of Excel with the purpose to enhance work productivity and effectiveness.

  1. Reducing Workbook and Worksheet Frustration
    • Create a Personal View of Your Workbooks
    • Enter Data into Multiple Worksheets Simultaneously
    • Customize the Templates Dialog and Default Workbook
    • Lock and Protect Cells Containing Formulas
    • Find Duplicate Data using Conditional Formatting
    • Outsmart Excel’s Relative Reference Handler
    • Remove Phantom Workbook Links
  2. Hacking Excel’s Built-in Features
    • Validate Data Based on a List on Another Worksheet
    • Control Conditional Formatting with Checkboxes
    • Count or Sum Cells That Meet Conditional Formatting Criteria
    • Highlight Every Other Row or Column
    • Create 3D Effects in Tables or Cells
    • Turn Conditional Formatting and Data Validation On and Off with a Checkbox
    • Support Multiple Lists in a ComboBox
    • Force Data Validation to Reference a List on Another Worksheet
    • Use Replace… to Remove Unwanted Characters
    • Convert Text Numbers to Real Numbers
    • Customize Cell Comments
    • Random Sorting
    • Manipulate Data with the Advanced Filter
    • Create Custom Number Formats
    • Create Custom Lists
    • Boldface Excel Subtotals
    • Convert Excel Formulas and Functions to Values
    • Automatically Add Data to a Validation List
  1. Naming Hacks
    • Address Data by Name
    • Use the Same Name for Ranges on Different Worksheets
    • Create Custom Functions Using Names
    • Identify Named Ranges on a Worksheet
  2. Hacking PivotTables
    • PivotTables: A Hack in Themselves
    • Share PivotTables but Not Their Data
    • Move PivotTable Grand Totals
  3. Hacking Formulas and Functions
    • Add Descriptive Text to Your Formulas
    • Move Relative Formulas Without Changing References
    • Compare Two Excel Ranges
    • Fill All Blank Cells in a List
    • Make Your Formulas Increment by Rows When You Copy Across Columns
    • Convert Dates to Excel Formatted Dates
    • Sum or Counting Cells While Avoiding Error Values
    • Count Only One Instance of Each Entry in a List
    • Sum Every Second, Third, or nth Row or Cell
    • Find the nth Occurrence of a Value
    • Make the Excel Subtotal Function Dynamic
    • Use the VLOOKUP Function Across Multiple Tables
  1. You can enrol this course by our online system, or call (852) 3605 3322 for reservation.

You may also be interested