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-51C6C
 Central
 Cantonese / PC
6/10~9/10
1900-22006 hrs/
2 sessions
MON, FRI960.00
SEF0-17101K
 Mongkok
 Cantonese / PC
10/10~10/10
0930-1230
1400-1700
6 hrs/
2 sessions
TUE960.00
SEF0-12C30K
 Mongkok
 Cantonese / PC
30/10~31/10
1900-22006 hrs/
2 sessions
MON, TUE960.00
SEF0-17111C
 Central
 Cantonese / PC
9/11~9/11
0930-1230
1400-1700
6 hrs/
2 sessions
THU960.00
SEF0-13C20C
 Central
 Cantonese / PC
20/11~22/11
1900-22006 hrs/
2 sessions
MON, WED960.00
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
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-6A21C
 Central
 Cantonese / PC
7/10~14/10
1000-13006 hrs/
2 sessions
SAT960.00
SEF3-17101C
 Central
 Cantonese / PC
31/10~31/10
0930-1230
1400-1700
6 hrs/
2 sessions
TUE960.00
SEF3-6A33C
 Central
 Cantonese / PC
4/11~11/11
1000-13006 hrs/
2 sessions
SAT960.00
SEF3-13C6K
 Mongkok
 Cantonese / PC
6/11~8/11
1900-22006 hrs/
2 sessions
MON, WED960.00
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-13C32C
 Central
 Cantonese / PC
5/2~7/2
1900-22006 hrs/
2 sessions
MON, WED960.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
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