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

Course Fee

$1100

Course Duration

6 Hours

Course Prerequisites

Course participants are expected to have 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.

Data Analysis with Microsoft Excel 2016
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名
DAS6-19091KCantonese / PC / MongKok27-Sep27-SepFRI0930-1230;1400-17006 hours / 2 sessions20190927

$1,100Enrol

DAS6-19101CCantonese / PC / Central09-Oct09-OctWED0930-1230;1400-17006 hours / 2 sessions20191009

$1,100Enrol

DAS6-19111KCantonese / PC / MongKok22-Nov22-NovFRI0930-1230;1400-17006 hours / 2 sessions20191122

$1,100Enrol

DAS6-19121CCantonese / PC / Central18-Dec18-DecWED0930-1230;1400-17006 hours / 2 sessions20191218

$1,100Enrol

DAS6-45C28CCantonese / PC / Central10/1011/10THU,FRI1900-22006 hours / 2 sessions20191010

$1,100Enrol

DAS6-6A37CCantonese / PC / Central23/1130/11SAT1000-13006 hours / 2 sessions20191123

$1,100Enrol

DAS6-51C11KCantonese / PC / MongKok27/1230/12FRI,MON1900-22006 hours / 2 sessions20191227

$1,100Enrol

DAS6-51C12KCantonese / PC / MongKok01/1104/11FRI,MON1900-22006 hours / 2 sessions20191101

$1,100Enrol

DAS6-35C22CCantonese / PC / Central15/0117/01WED,FRI1900-22006 hours / 2 sessions20200115

$1,100Enrol

DAS6-6A25KCantonese / PC / MongKok15/0222/02SAT1000-13006 hours / 2 sessions20200215

$1,100Enrol

DAS6-6A38CCantonese / PC / Central07/0314/03SAT1000-13006 hours / 2 sessions20200307

$1,100Enrol

DAS6-13C26KCantonese / PC / MongKok06/0408/04MON,WED1900-22006 hours / 2 sessions20200406

$1,100Enrol

DAS6-23C1CCantonese / PC / Central28/0429/04TUE,WED1900-22006 hours / 2 sessions20200428

$1,100Enrol

DAS6-6A26KCantonese / PC / MongKok23/0530/05SAT1000-13006 hours / 2 sessions20200523

$1,100Enrol

DAS6-35C23CCantonese / PC / Central17/0619/06WED,FRI1900-22006 hours / 2 sessions20200617

$1,100Enrol

DAS6-6A39CCantonese / PC / Central27/0604/07SAT1000-13006 hours / 2 sessions20200627

$1,100Enrol

Data Analysis with Microsoft Excel 2013
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名
DAS3-19101CCantonese / PC / Central31-Oct31-OctTHU0930-1230;1400-17006 hours / 2 sessions20191031

$1,100Enrol

DAS3-19111KCantonese / PC / MongKok06-Nov06-NovWED0930-1230;1400-17006 hours / 2 sessions20191106

$1,100Enrol

DAS3-19121CCantonese / PC / Central03-Dec03-DecTUE0930-1230;1400-17006 hours / 2 sessions20191203

$1,100Enrol

DAS3-24C17KCantonese / PC / MongKok08/1010/10TUE,THU1900-22006 hours / 2 sessions20191008

$1,100Enrol

DAS3-12C27CCantonese / PC / Central21/1022/10MON,TUE1900-22006 hours / 2 sessions20191021

$1,100Enrol

DAS3-51C31KCantonese / PC / MongKok22/1125/11FRI,MON1900-22006 hours / 2 sessions20191122

$1,100Enrol

DAS3-6A37CCantonese / PC / Central07/1214/12SAT1000-13006 hours / 2 sessions20191207

$1,100Enrol

DAS3-6A37KCantonese / PC / MongKok11/0118/01SAT1000-13006 hours / 2 sessions20200111

$1,100Enrol

DAS3-45C33CCantonese / PC / Central30/0131/01THU,FRI1900-22006 hours / 2 sessions20200130

$1,100Enrol

DAS3-12C34KCantonese / PC / MongKok02/0303/03MON,TUE1900-22006 hours / 2 sessions20200302

$1,100Enrol

DAS3-6A38CCantonese / PC / Central14/0321/03SAT1000-13006 hours / 2 sessions20200314

$1,100Enrol

DAS3-12C28CCantonese / PC / Central04/0505/05MON,TUE1900-22006 hours / 2 sessions20200504

$1,100Enrol

DAS3-45C68KCantonese / PC / MongKok14/0515/05THU,FRI1900-22006 hours / 2 sessions20200514

$1,100Enrol

DAS3-51C23CCantonese / PC / Central19/0622/06FRI,MON1900-22006 hours / 2 sessions20200619

$1,100Enrol

DAS3-6A38KCantonese / PC / MongKok27/0604/07SAT1000-13006 hours / 2 sessions20200627

$1,100Enrol

Data Analysis with Microsoft Excel 2010
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名
DAS0-19101KCantonese / PC / MongKok18-Oct18-OctFRI0930-1230;1400-17006 hours / 2 sessions20191018

$1,100Enrol

DAS0-19111CCantonese / PC / Central13-Nov13-NovWED0930-1230;1400-17006 hours / 2 sessions20191113

$1,100Enrol

DAS0-19121KCantonese / PC / MongKok20-Dec20-DecFRI0930-1230;1400-17006 hours / 2 sessions20191220

$1,100Enrol

DAS0-6A33KCantonese / PC / MongKok09/1116/11SAT1000-13006 hours / 2 sessions20191109

$1,100Enrol

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. 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. 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. You can enrol this course by our online system, or call (852) 3605 3322 for reservation.

You may also be interested in