Project Description

Loading...

Welkin Course Codes : SEFF, SEF0, SEF3

Course Features

Microsoft Excel offers a large variety of useful functions that can significantly improve work effectiveness, productivity and results. Many users cannot take full advantage of Excel 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.

  • Use functions to summarize data with advanced criteria
  • Use functions to process different types of data: numeric, text, date, time and Boolean
  • Use financial functions to process investment and accounting data
Topics include:
  • 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 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 course Business Analysis with Microsoft Excel.

Course Fee

$1100

Course Duration

6 Hours

Course Prerequisites

Participants are expected to have a basic knowledge of Microsoft Excel.

Title of Award

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

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

Using Excel Functions Effectively
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名
SEFF-19091KCantonese / PC / MongKok10-Sep10-SepTUE0930-1230;1400-17006 hours / 2 sessions20190910

$1,100Enrol

SEFF-35C11CCantonese / PC / Central11-Sep18-SepWED1900-22006 hours / 2 sessions20190911

$1,100Enrol

SEFF-19092CCantonese / PC / Central24-Sep24-SepTUE0930-1230;1400-17006 hours / 2 sessions20190924

$1,100Enrol

SEFF-45C26KCantonese / PC / MongKok26-Sep27-SepTHU,FRI1900-22006 hours / 2 sessions20190926

$1,100Enrol

SEFF-19101KCantonese / PC / MongKok16-Oct16-OctWED0930-1230;1400-17006 hours / 2 sessions20191016

$1,100Enrol

SEFF-19102CCantonese / PC / Central25-Oct25-OctFRI0930-1230;1400-17006 hours / 2 sessions20191025

$1,100Enrol

SEFF-19111KCantonese / PC / MongKok08-Nov08-NovFRI0930-1230;1400-17006 hours / 2 sessions20191108

$1,100Enrol

SEFF-19112CCantonese / PC / Central25-Nov25-NovMON0930-1230;1400-17006 hours / 2 sessions20191125

$1,100Enrol

SEFF-19121KCantonese / PC / MongKok10-Dec10-DecTUE0930-1230;1400-17006 hours / 2 sessions20191210

$1,100Enrol

SEFF-19122CCantonese / PC / Central20-Dec20-DecFRI0930-1230;1400-17006 hours / 2 sessions20191220

$1,100Enrol

SEFF-6A36CCantonese / PC / Central26/1002/11SAT1000-13006 hours / 2 sessions20191026

$1,100Enrol

SEFF-6A36KCantonese / PC / MongKok09/1116/11SAT1000-13006 hours / 2 sessions20191109

$1,100Enrol

SEFF-45C26CCantonese / PC / Central12/1213/12THU,FRI1900-22006 hours / 2 sessions20191212

$1,100Enrol

SEFF-51C1KCantonese / PC / MongKok27/1230/12FRI,MON1900-22006 hours / 2 sessions20191227

$1,100Enrol

Microsoft Excel offers a large variety of useful functions that can significantly improve work effectiveness, productivity and results. Many users cannot take full advantage of Excel 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. 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. 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. You can enrol this course by our online system, or call (852) 3605 3322 for reservation.

You may also be interested in