Data Analysis with Microsoft Excel (2010/2013/2016) 2017-09-15T14:05:55+00:00

Project Description

Loading...
Welkin Course Codes: DAS0, DAS3, DAS6

Course Features

Take advantage of Excel’s powerful data analysis features to help you improve work productivity. Learn useful skills to organise, analyse and summarise data in a more effective way.

  • AutoFilter
  • Subtotals
  • Key functions
  • PivotTable/PivotChart
  • Conditional formatting

By the end of the course you will be able to perform data analysis using Excel’s popular features.

  • Qualified and experienced instructor
  • Easy-to-follow, step-by-step instruction
  • Daytime, evening and weekend classes

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 in financial analysis with the CEF-approved course Financial Modeling with Excel VBA.

Course Fee

$960

Course Duration

6 Hours

Course Prerequisites

Course participants are expected to have basic knowledge Microsoft Excel.

Title of Award

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

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

 

 

COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
DAS3-17111C
 Central
 Cantonese / PC
23/11~23/11
0930-1230
1400-1700
6 hrs/
2 sessions
THU960.00
DAS3-13C18C
 Central
 Cantonese / PC
18/12~20/12
1900-22006 hrs/
2 sessions
MON, WED960.00
DAS3-17121K
 Mongkok
 Cantonese / PC
19/12~19/12
0930-1230
1400-1700
6 hrs/
2 sessions
TUE960.00
DAS3-45C28K
 Mongkok
 Cantonese / PC
28/12~29/12
1900-22006 hrs/
2 sessions
THU, FRI960.00
DAS3-18011K
 Mongkok
 Cantonese / PC
18/1~18/1
0930-1230
1400-1700
6 hrs/
2 sessions
THU960.00
DAS3-18021C
 Central
 Cantonese / PC
2/2~2/2
0930-1230
1400-1700
6 hrs/
2 sessions
FRI960.00
DAS3-12C5C
 Central
 Cantonese / PC
5/2~6/2
1900-22006 hrs/
2 sessions
MON, TUE960.00
DAS3-23C13K
 Mongkok
 Cantonese / PC
13/2~14/2
1900-22006 hrs/
2 sessions
TUE, WED960.00
DAS3-6A17C
 Central
 Cantonese / PC
17/3~24/3
1000-13006 hrs/
2 sessions
SAT960.00
DAS3-13C19K
 Mongkok
 Cantonese / PC
19/3~21/3
1900-22006 hrs/
2 sessions
MON, WED960.00
DAS3-18031K
 Mongkok
 Cantonese / PC
27/3~27/3
0930-1230
1400-1700
6 hrs/
2 sessions
TUE960.00
DAS3-18041C
 Central
 Cantonese / PC
10/4~10/4
0930-1230
1400-1700
6 hrs/
2 sessions
TUE960.00
DAS3-35C2C
 Central
 Cantonese / PC
2/5~4/5
1900-22006 hrs/
2 sessions
WED, FRI960.00
DAS3-6A5K
 Mongkok
 Cantonese / PC
5/5~12/5
1000-13006 hrs/
2 sessions
SAT960.00
DAS3-18051K
 Mongkok
 Cantonese / PC
24/5~24/5
0930-1230
1400-1700
6 hrs/
2 sessions
THU960.00
DAS3-24C32C
 Central
 Cantonese / PC
19/6~21/6
1900-22006 hrs/
2 sessions
TUE, THU960.00
DAS3-35C20K
 Mongkok
 Cantonese / PC
20/6~22/6
1900-22006 hrs/
2 sessions
WED, FRI960.00
DAS3-18061C
 Central
 Cantonese / PC
26/6~26/6
0930-1230
1400-1700
6 hrs/
2 sessions
TUE960.00
DAS3-18071K
 Mongkok
 Cantonese / PC
26/7~26/7
0930-1230
1400-1700
6 hrs/
2 sessions
THU960.00
DAS3-18081C
 Central
 Cantonese / PC
28/8~28/8
0930-1230
1400-1700
6 hrs/
2 sessions
TUE960.00
DAS3-18091K
 Mongkok
 Cantonese / PC
19/9~19/9
0930-1230
1400-1700
6 hrs/
2 sessions
WED960.00
DAS3-18101C
 Central
 Cantonese / PC
31/10~31/10
0930-1230
1400-1700
6 hrs/
2 sessions
WED960.00
DAS3-18111K
 Mongkok
 Cantonese / PC
27/11~27/11
0930-1230
1400-1700
6 hrs/
2 sessions
TUE960.00
DAS3-18121C
 Central
 Cantonese / PC
3/12~3/12
0930-1230
1400-1700
6 hrs/
2 sessions
MON960.00
Data Analysis with Microsoft Excel 2013
Complete your Enrol
How to enrol/pay online

 

 

COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
DAS6-12C27C
 Central
 Cantonese / PC
27/11~28/11
1900-22006 hrs/
2 sessions
MON, TUE960.00
DAS6-6A6K
 Mongkok
 Cantonese / PC
6/1~13/1
1000-13006 hrs/
2 sessions
SAT960.00
DAS6-13C8C
 Central
 Cantonese / PC
8/1~10/1
1900-22006 hrs/
2 sessions
MON, WED960.00
DAS6-45C22K
 Mongkok
 Cantonese / PC
22/2~23/2
1900-22006 hrs/
2 sessions
THU, FRI960.00
DAS6-6A24C
 Central
 Cantonese / PC
24/2~3/3
1000-13006 hrs/
2 sessions
SAT960.00
DAS6-34C28K
 Mongkok
 Cantonese / PC
28/3~29/3
1900-22006 hrs/
2 sessions
WED, THU960.00
DAS6-24C10C
 Central
 Cantonese / PC
10/4~12/4
1900-22006 hrs/
2 sessions
TUE, THU960.00
DAS6-6A12K
 Mongkok
 Cantonese / PC
12/5~19/5
1000-13006 hrs/
2 sessions
SAT960.00
DAS6-6A32C
 Central
 Cantonese / PC
26/5~2/6
1000-13006 hrs/
2 sessions
SAT960.00
DAS6-13C25K
 Mongkok
 Cantonese / PC
25/6~27/6
1900-22006 hrs/
2 sessions
MON, WED960.00
Data Analysis with Microsoft Excel 2016
Complete your Enrol
How to enrol/pay online

Microsoft Excel is the most widely used spreadsheet application for PCs. It is also a convenient and powerful tool for data analysis in the business world as well as in different fields. This short but practical course focuses on the data analysis function of Excel. You will learn a variety of skills including data and list management, relevant functions, pivot tables and pivot charts, conditional formatting, etc.

  1. Database and List Management
    • Using the Excel Database Features
    • Sorting Data within a Database
    • Using AutoFilter
    • Specifying Conditions for AutoFilter
    • Using Custom AutoFilter
    • Removing AutoFilter
    • Removing Duplicates

     

  2. Summarizing Data
    • Creating Subtotals
    • Creating Subtotals by Using Different Functions
    • Removing Subtotals
    • Consolidating Data
    • Using the SUMIF Function
    • Creating Scenarios
    • Applying Scenario
    • Editing Scenario
    • Deleting Scenario

     

  3. Using Database Functions
    • Introducing Database Functions
    • Find the Sum of Specific Records using Paste Function
    • Find The Average Of Specific Records

     

  4. Using LOOKUP Functions
    • Using VLOOKUP to Find Data
    • Limit the VLOOKUP Value for Exact Match
    • Using the Closest Match for the VLOOKUP Value
    • Using Index & Match Functions
  1. Using Statistical Functions
    • MEDIAN
    • MODE
    • GROWTH
    • LARGE
    • SMALL
    • RANK

     

  2. Using Logical Functions
    • IF
    • AND
    • OR

     

  3. PivotTable and PivotChart Report
    • Creating a PivotTable
    • Rearranging Fields in a PivotTable
    • Explaining the Report Layout Options
    • Using the Report Filters Feature
    • Refreshing a PivotTable
    • Sorting Items on the PivotTable
    • Hiding and Showing Fields
    • Grouping and Ungrouping Data
    • Formatting a PivotTable
    • Creating Interactive PivotTables for the Web
    • Creating PivotChart Report

     

  4. Using Conditional Formatting
    • Applying and Editing Conditional Formatting
    • Deleting Conditional Formatting
  1. Use AutoFilter to filter your data
    • Filter a range of data
    • Remove a filter
    • Filtering data by icon set

     

  2. Inserting subtotals in a list of data in a worksheet
    • Inserting subtotals
    • Removing subtotals
    • SUMIF

     

  3. Database Functions
    • DSUM
    • DAVERAGE
    • DCOUNT & DCOUNTA
    • DMAX & DMIN

     

  4. 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
    • Lookup function
  1. Statistical Functions
    • MEDIAN
    • MODE
    • LARGE
    • SMALL
    • RANK

     

  2. Logical function
  3. Using PivotTables / PivotChart to analyze & present your data
    • Creating a PivotTable or PivotChart
    • Changing the format of your PivotTable report
    • Showing PivotTable details
    • Calculating PivotTable values
    • Changing or updating PivotTable data

     

  4. Applying Conditional Formatting
    • Adding, changing, conditional formats
    • Clearing conditional formats
    • Apply conditional formatting to quickly analyse data
  1. Use AutoFilter to filter your data
    • Filter a range of data
    • Remove a filter
    • Filtering data by icon set

     

  2. Inserting subtotals in a list of data in a worksheet
    • Inserting subtotals
    • Removing subtotals
    • SUMIF

     

  3. Database Functions
    • DSUM
    • DAVERAGE
    • DCOUNT & DCOUNTA
    • DMAX & DMIN

     

  4. 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
    • Lookup function
  1. Statistical Functions
    • MEDIAN
    • MODE
    • LARGE
    • SMALL
    • RANK

     

  2. Logical function
  3. Using PivotTables / PivotChart to analyze & present your data
    • Creating a PivotTable or PivotChart
    • Changing the format of your PivotTable report
    • Showing PivotTable details
    • Calculating PivotTable values
    • Changing or updating PivotTable data

     

  4. Applying Conditional Formatting
    • Adding, changing, conditional formats
    • Clearing conditional formats

Apply conditional formatting to quickly analyse data

  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