Using Excel Functions Effectively 2017-09-18T12:02:04+00:00

Project Description

Loading...
Welkin Course Codes : SEF0,SEF3

Course Features

This course is specially designed to help you master Microsoft Word and Excel as a business tool to

  • Summarizing data with advanced criteria
  • Using Excel functions to process different types of data: numeric, text, date, time and Boolean
  • Use financial functions to process investment and accounting data

in an effective and professional manner.

Key function features:

  • Information Functions
  • Database Functions
  • Text Functions
  • Lookup and Reference Functions
  • Statistical Functions
  • Date and Time Functions
  • Financial Functions
  • and more…

Learn from the Experts

Get Professional Recognition

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 with the course Business Analysis with Microsoft Excel.

Course Fee

$960

Course Duration

6 Hours

Course Prerequisites

Course participants should be at least 18 years old and have an education level of Form 5 or above.

Title of Award

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

Schedule & Online Enrolment
Enquiry/Booking
Using Excel 2010/2007 Functions Effectively
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
SEF0-17121K
 Mongkok
 Cantonese / PC
11/12~11/12
0930-1230
1400-1700
6 hrs/
2 sessions
MON960.00
SEF0-6A16K
 Mongkok
 Cantonese / PC
16/12~30/12
1000-13006 hrs/
2 sessions
SAT960.00
SEF0-18011K
 Mongkok
 Cantonese / PC
9/1~9/1
0930-1230
1400-1700
6 hrs/
2 sessions
TUE960.00
SEF0-18021C
 Central
 Cantonese / PC
22/2~22/2
0930-1230
1400-1700
6 hrs/
2 sessions
THU960.00
SEF0-18031K
 Mongkok
 Cantonese / PC
6/3~6/3
0930-1230
1400-1700
6 hrs/
2 sessions
TUE960.00
SEF0-18041C
 Central
 Cantonese / PC
13/4~13/4
0930-1230
1400-1700
6 hrs/
2 sessions
FRI960.00
SEF0-18051K
 Mongkok
 Cantonese / PC
31/5~31/5
0930-1230
1400-1700
6 hrs/
2 sessions
THU960.00
SEF0-18061C
 Central
 Cantonese / PC
6/6~6/6
0930-1230
1400-1700
6 hrs/
2 sessions
WED960.00
SEF0-18071K
 Mongkok
 Cantonese / PC
6/7~6/7
0930-1230
1400-1700
6 hrs/
2 sessions
FRI960.00
SEF0-18081C
 Central
 Cantonese / PC
10/8~10/8
0930-1230
1400-1700
6 hrs/
2 sessions
FRI960.00
SEF0-18091K
 Mongkok
 Cantonese / PC
20/9~20/9
0930-1230
1400-1700
6 hrs/
2 sessions
THU960.00
SEF0-18101C
 Central
 Cantonese / PC
3/10~3/10
0930-1230
1400-1700
6 hrs/
2 sessions
WED960.00
SEF0-18111K
 Mongkok
 Cantonese / PC
7/11~7/11
0930-1230
1400-1700
6 hrs/
2 sessions
WED960.00
SEF0-18121C
 Central
 Cantonese / PC
17/12~17/12
0930-1230
1400-1700
6 hrs/
2 sessions
MON960.00
Using Excel 2010/2007 Functions Effectively
Complete your Enrol
How to enrol/pay online

Using Excel 2013 Functions Effectively
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
SEF3-17111K
 Mongkok
 Cantonese / PC
22/11~22/11
0930-1230
1400-1700
6 hrs/
2 sessions
WED960.00
SEF3-12C4C
 Central
 Cantonese / PC
4/12~5/12
1900-22006 hrs/
2 sessions
MON, TUE960.00
SEF3-6A32K
 Mongkok
 Cantonese / PC
9/12~16/12
1000-13006 hrs/
2 sessions
SAT960.00
SEF3-17121C
 Central
 Cantonese / PC
21/12~21/12
0930-1230
1400-1700
6 hrs/
2 sessions
THU960.00
SEF3-45C4K
 Mongkok
 Cantonese / PC
4/1~5/1
1900-22006 hrs/
2 sessions
THU, FRI960.00
SEF3-6A13C
 Central
 Cantonese / PC
13/1~20/1
1000-13006 hrs/
2 sessions
SAT960.00
SEF3-18011C
 Central
 Cantonese / PC
19/1~19/1
0930-1230
1400-1700
6 hrs/
2 sessions
FRI960.00
SEF3-13C32C
 Central
 Cantonese / PC
5/2~7/2
1900-22006 hrs/
2 sessions
MON, WED960.00
SEF3-18021K
 Mongkok
 Cantonese / PC
8/2~8/2
0930-1230
1400-1700
6 hrs/
2 sessions
THU960.00
SEF3-6D10K
 Mongkok
 Cantonese / PC
10/2~10/2
1000-1300
1400-1700
6 hrs/
2 sessions
SAT960.00
SEF3-24C6K
 Mongkok
 Cantonese / PC
6/3~8/3
1900-22006 hrs/
2 sessions
TUE, THU960.00
SEF3-6A17C
 Central
 Cantonese / PC
17/3~24/3
1000-13006 hrs/
2 sessions
SAT960.00
SEF3-18031C
 Central
 Cantonese / PC
22/3~22/3
0930-1230
1400-1700
6 hrs/
2 sessions
THU960.00
SEF3-18041K
 Mongkok
 Cantonese / PC
23/4~23/4
0930-1230
1400-1700
6 hrs/
2 sessions
MON960.00
SEF3-13C32K
 Mongkok
 Cantonese / PC
23/4~25/4
1900-22006 hrs/
2 sessions
MON, WED960.00
SEF3-45C3C
 Central
 Cantonese / PC
3/5~4/5
1900-22006 hrs/
2 sessions
THU, FRI960.00
SEF3-18051C
 Central
 Cantonese / PC
10/5~10/5
0930-1230
1400-1700
6 hrs/
2 sessions
THU960.00
SEF3-6A33K
 Mongkok
 Cantonese / PC
9/6~16/6
1000-13006 hrs/
2 sessions
SAT960.00
SEF3-6A16C
 Central
 Cantonese / PC
16/6~23/6
1000-13006 hrs/
2 sessions
SAT960.00
SEF3-35C27K
 Mongkok
 Cantonese / PC
27/6~29/6
1900-22006 hrs/
2 sessions
WED, FRI960.00
SEF3-18061K
 Mongkok
 Cantonese / PC
28/6~28/6
0930-1230
1400-1700
6 hrs/
2 sessions
THU960.00
SEF3-18071C
 Central
 Cantonese / PC
24/7~24/7
0930-1230
1400-1700
6 hrs/
2 sessions
TUE960.00
SEF3-51C27C
 Central
 Cantonese / PC
27/7~30/7
1900-22006 hrs/
2 sessions
MON, FRI960.00
SEF3-12C6K
 Mongkok
 Cantonese / PC
6/8~7/8
1900-22006 hrs/
2 sessions
MON, TUE960.00
SEF3-6A34K
 Mongkok
 Cantonese / PC
11/8~18/8
1000-13006 hrs/
2 sessions
SAT960.00
SEF3-18081K
 Mongkok
 Cantonese / PC
21/8~21/8
0930-1230
1400-1700
6 hrs/
2 sessions
TUE960.00
SEF3-18091C
 Central
 Cantonese / PC
3/9~3/9
0930-1230
1400-1700
6 hrs/
2 sessions
MON960.00
SEF3-6A8C
 Central
 Cantonese / PC
8/9~15/9
1000-13006 hrs/
2 sessions
SAT960.00
SEF3-6A22K
 Mongkok
 Cantonese / PC
22/9~29/9
1000-13006 hrs/
2 sessions
SAT960.00
SEF3-45C27K
 Mongkok
 Cantonese / PC
27/9~28/9
1900-22006 hrs/
2 sessions
THU, FRI960.00
SEF3-18101K
 Mongkok
 Cantonese / PC
12/10~12/10
0930-1230
1400-1700
6 hrs/
2 sessions
FRI960.00
SEF3-18111C
 Central
 Cantonese / PC
29/11~29/11
0930-1230
1400-1700
6 hrs/
2 sessions
THU960.00
SEF3-18121K
 Mongkok
 Cantonese / PC
13/12~13/12
0930-1230
1400-1700
6 hrs/
2 sessions
THU960.00
Using Excel 2013 Functions Effectively
Complete your Enrol
How to enrol/pay online

Microsoft Excel offers a large variety of useful functions that can significantly improve work effectiveness, productivity and results. However many users cannot take full advantage of Excel’s functions because they do not know what is available or they are not sure how to use them. This 6-hour course is designed to remedy this situation by introducing to you about 50 useful Excel functions with practical examples and hands-on practice.

In this course, you will learn:

  • Using Excel functions to process different types of data: numeric, text, date, time and Boolean
  • Summarizing data with advanced criteria
  • Using Lookup to link up data between data tables
  • Using IF statements effectively for decision-making, data validation and handling data in different ways based upon criteria
  • Using statistical functions to consolidate and forecast data
  • Use financial functions to process investment and accounting data
  • Handling formula errors

1. Introduction

  • Course Objectives
  • Course Contents

2. Information Functions

  • Overview
  • ISBLANK
  • ISNUMBER
  • ISERROR
  • IFERROR
  • TYPE


3. Database Functions

  • DSUM
  • DAVERAGE
  • DCOUNT & DCOUNTA
  • DMAX & DMIN


4. Text Functions

  • LEFT
  • RIGHT
  • MID
  • LEN
  • LOWER
  • SEARCH
  • REPLACE
  • UPPER
  • PROPER
  • SUBSTITUTE
  • TRIM


5. Lookup and Reference Functions

  • Using VLOOKUP to Find Data
  • Limit the VLOOKUP Value for Exact Match
  • Using the Closest Match for the VLOOKUP Value
  • HLOOKUP
  • INDEX
  • Match

6. Statistical Functions

  • MEDIAN
  • MODE
  • GROWTH
  • LARGE
  • SMALL
  • RANK


7. Financial Functions

  • PMT, IPMT & PPMT
  • PV
  • FV
  • DB
  • DDB


8. Other Functions

  • SUMPRODUCT
  • ABS
  • INT
  • ROUND
  • ROUNDUP
  • ROUNDDOWN
  • SUBTOTAL
  • TODAY
  • DAY
  • MONTH
  • YEAR
  • NETWORKDAYS
  • WEEKDAY
  • WORKDAY
  • IF
  • AND
  • OR
  • SUMIF
  • COUNTIF
  • AVERAGEIF
  • SUMIFS
  • AVERAGEIFS
  • COUNTIFS

1. Information Functions

  • Overview
  • ISBLANK
  • ISNUMBER
  • ISERROR
  • IFERROR
  • TYPE
  • SHEET
  • SHEETS

2. Logical Functions

  • IF
  • AND
  • OR

3. Database Functions

  • DSUM
  • DAVERAGE
  • DCOUNT & DCOUNTA
  • DMAX & DMIN

4. Text Functions

  • LEFT
  • RIGHT
  • MID
  • LEN
  • LOWER
  • SEARCH
  • REPLACE
  • UPPER
  • PROPER
  • SUBSTITUTE
  • TRIM

5. Lookup and Reference Functions

  • Using VLOOKUP to Find Data
  • Limit the VLOOKUP Value for
  • Exact Match
  • Using the Closest Match for the VLOOKUP Value
  • HLOOKUP
  • INDEX
  • Match

6. Statistical Functions

  • MEDIAN
  • MODE
  • LARGE
  • SMALL
  • RANK
  • COUNTIF
  • COUNTIFS
  • AVERAGEIF
  • AVERAGEIFS

7. Date and Time Functions

  • TODAY
  • DAY
  • MONTH
  • YEAR
  • NETWORKDAYS
  • WEEKDAY
  • WORKDAY

8. Financial Functions

  • PMT, IPMT & PPMT
  • PV
  • FV

9. Math & Trig Functions

  • SUMPRODUCT
  • ABS
  • INT
  • ROUND
  • ROUNDUP
  • ROUNDDOWN
  • SUBTOTAL
  • SUMIF
  • SUMIFS
  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