Data Management with Microsoft Excel (2007/2010) 2017-09-15T14:18:08+00:00

Project Description

Loading...
 Welkin Course Code: DMM

Course Description

Excel is commonly used in data management, but few people can use it truly effectively. For example, many may know how to perform simple sorting or filtering, but most are at a loss to do it to meet specific criteria. Excel is highly capable than most users think. It can make good use of external data, run queries using specific functions, or extract useful data through Access Query. In this short course, you will learn how to get the most from Excel’s data management capabilities.

  • Smart Formatting Tricks
  • Grouping and Outlining Data
  • Lookup, Reference, and Information Functions
  • Advanced Formula Writing and Troubleshooting
  • Scenarios, Goal Seeking and Pivot Tables

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 data management with the course Microsoft Access for Beginners.

Course Fee

$960

Course Duration

6 Hours

Course Prerequisites

Course participants are expected to have basic computer skills.

Title of Award

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

Schedule & Online Enrolment
Enquiry/Booking
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
DMM0-6A7C
 Central
 Cantonese / PC
7/10~14/10
1000-13006 hrs/
2 sessions
SAT960.00
DMM0-51C13K
 Mongkok
 Cantonese / PC
13/10~16/10
1900-22006 hrs/
2 sessions
MON, FRI960.00
DMM0-12C20C
 Central
 Cantonese / PC
20/11~21/11
1900-22006 hrs/
2 sessions
MON, TUE960.00
DMM0-35C29K
 Mongkok
 Cantonese / PC
29/11~1/12
1900-22006 hrs/
2 sessions
WED, FRI960.00
DMM0-6A34C
 Central
 Cantonese / PC
13/1~20/1
1000-13006 hrs/
2 sessions
SAT960.00
DMM0-24C16K
 Mongkok
 Cantonese / PC
16/1~18/1
1900-22006 hrs/
2 sessions
TUE, THU960.00
DMM0-6A3K
 Mongkok
 Cantonese / PC
3/3~10/3
1000-13006 hrs/
2 sessions
SAT960.00
DMM0-45C8C
 Central
 Cantonese / PC
8/3~9/3
1900-22006 hrs/
2 sessions
THU, FRI960.00
Data Management with Microsoft Excel 2010
Complete your Enrol
How to enrol/pay online

Excel is commonly used in data management, but few people can use it truly effectively. For example, many may know how to perform simple sorting or filtering, but most are at a loss to do it to meet specific criteria. Excel is highly capable than most users think. It can make good use of external data, run queries using specific functions, or extract useful data through Access Query. In this short course, you will learn how to get the most from Excel’s data management capabilities.

  1. Smart Formatting Tricks
    • The Format Painter
    • Styles and Themes
    • Conditional Formatting
  2. Tables: List Management Made Easy
    • The Basics of Tables
    • Sorting and Filtering a Table
    • Dealing with Duplicate Rows
    • Performing Table Calculations
  3. Grouping and Outlining Data
    • Basic Data Grouping
    • Grouping Timesavers
  4. Lookup, Reference, and Information Functions
    • The Basic Lookup
    • Advanced Lookups
    • Information Functions
  5. Advanced Formula Writing and Troubleshooting
    • Conditions in Formulas
    • Descriptive Names for Cell References
    • Variable Data Tables
    • Controlling Recalculation
    • Solving Formula Errors
  6. Scenarios and Goal Seeking
    • Using Scenarios
    • Using Goal Seek
    • Solver
  7. PivotTables
    • Summary Tables Revisited
    • Building PivotTables
    • Multi-Layered PivotTables
    • Fine-Tuning PivotTable Calculations
    • Filtering a PivotTable
    • PivotCharts
  1. Smart Formatting Tricks
    • The Format Painter
    • Styles and Themes
    • Conditional Formatting
  2. Tables: List Management Made Easy
    • The Basics of Tables
    • Sorting and Filtering a Table
    • Dealing with Duplicate Rows
    • Performing Table Calculations
  3. Grouping and Outlining Data
    • Basic Data Grouping
    • Grouping Timesavers
  4. Lookup, Reference, and Information Functions
    • The Basic Lookup
    • Advanced Lookups
    • Information Functions
  5. Advanced Formula Writing and Troubleshooting
    • Conditions in Formulas
    • Descriptive Names for Cell References
    • Variable Data Tables
    • Controlling Recalculation
    • Solving Formula Errors
  6. Scenarios and Goal Seeking
    • Using Scenarios
    • Using Goal Seek
    • Solver
  7. PivotTables
    • Summary Tables Revisited
    • Building PivotTables
    • Multi-Layered PivotTables
    • Fine-Tuning PivotTable Calculations
    • Filtering a PivotTable
    • PivotCharts
  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