Practical Excel Tips for Office Professionals 2010 2018-01-11T14:36:32+00:00

Project Description

Loading...
Welkin Course Code: 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
  • Easy-to-follow, step-by-step hands-on learning approach
  • Weekdays and weekend classes available

Learn from the Experts

Get Your Skills Certified

mos-certificate

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

$960

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.

Schedule & Online Enrolment
Enquiry/Booking
Practical Excel Tips for Office Professionals 2010
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
PET0-6A3K
 Mongkok
 Cantonese / PC
3/2~10/2
1000-13006 hrs/
2 sessions
SAT960.00
PET0-18021K
 Mongkok
 Cantonese / PC
9/2~9/2
0930-1230
1400-1700
6 hrs/
2 sessions
FRI960.00
PET0-51C23C
 Central
 Cantonese / PC
23/2~26/2
1900-22006 hrs/
2 sessions
MON, FRI960.00
PET0-45C15K
 Mongkok
 Cantonese / PC
15/3~16/3
1900-22006 hrs/
2 sessions
THU, FRI960.00
PET0-18031C
 Central
 Cantonese / PC
23/3~23/3
0930-1230
1400-1700
6 hrs/
2 sessions
FRI960.00
PET0-6A14C
 Central
 Cantonese / PC
7/4~7/4
1000-1300
1400-1700
6 hrs/
2 sessions
SAT960.00
PET0-18041C
 Central
 Cantonese / PC
9/4~9/4
0930-1230
1400-1700
6 hrs/
2 sessions
MON960.00
PET0-6A5K
 Mongkok
 Cantonese / PC
5/5~12/5
1000-13006 hrs/
2 sessions
SAT960.00
PET0-18051K
 Mongkok
 Cantonese / PC
21/5~21/5
0930-1230
1400-1700
6 hrs/
2 sessions
MON960.00
PET0-12C4C
 Central
 Cantonese / PC
4/6~5/6
1900-22006 hrs/
2 sessions
MON, TUE960.00
PET0-24C19K
 Mongkok
 Cantonese / PC
19/6~21/6
1900-22006 hrs/
2 sessions
TUE, THU960.00
PET0-18061K
 Mongkok
 Cantonese / PC
21/6~21/6
0930-1230
1400-1700
6 hrs/
2 sessions
THU960.00
PET0-18071C
 Central
 Cantonese / PC
16/7~16/7
0930-1230
1400-1700
6 hrs/
2 sessions
MON960.00
PET0-51C20C
 Central
 Cantonese / PC
20/7~23/7
1900-22006 hrs/
2 sessions
MON, FRI960.00
PET0-12C6K
 Mongkok
 Cantonese / PC
6/8~7/8
1900-22006 hrs/
2 sessions
MON, TUE960.00
PET0-18081C
 Central
 Cantonese / PC
7/8~7/8
0930-1230
1400-1700
6 hrs/
2 sessions
TUE960.00
PET0-18091K
 Mongkok
 Cantonese / PC
5/9~5/9
0930-1230
1400-1700
6 hrs/
2 sessions
WED960.00
PET0-6A8C
 Central
 Cantonese / PC
8/9~15/9
1000-13006 hrs/
2 sessions
SAT960.00
PET0-45C20K
 Mongkok
 Cantonese / PC
20/9~21/9
1900-22006 hrs/
2 sessions
THU, FRI960.00
PET0-18101K
 Mongkok
 Cantonese / PC
31/10~31/10
0930-1230
1400-1700
6 hrs/
2 sessions
WED960.00
PET0-18111C
 Central
 Cantonese / PC
2/11~2/11
0930-1230
1400-1700
6 hrs/
2 sessions
FRI960.00
PET0-18121C
 Central
 Cantonese / PC
10/12~10/12
0930-1230
1400-1700
6 hrs/
2 sessions
MON960.00
Practical Excel Tips for Office Professionals 2010
Complete your Enrolment
How to enrol/pay online

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. 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