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 the job to meet specific criteria. Excel is more highly capable than many 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 powerful 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 data management with the course Microsoft Access for Beginners.

Course Fee

$1100

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.

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

Data Management with Microsoft Excel 2013
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名
DMM3-13C1KCantonese / PC / MongKok09-Sep11-SepMON,WED1900-22006 hours / 2 sessions20190909

$1,100Enrol

DMM3-3D1KCantonese / PC / MongKok18-Sep18-SepWED0945-1245;1400-17006 hours / 2 sessions20190918

$1,100Enrol

DMM3-24C2CCantonese / PC / Central08-Oct10-OctTUE,THU1900-22006 hours / 2 sessions20191008

$1,100Enrol

DMM3-35C2KCantonese / PC / MongKok13/1115/11WED,FRI1900-22006 hours / 2 sessions20191113

$1,100Enrol

DMM3-4D1CCantonese / PC / Central14/1114/11THU0945-1245;1400-17006 hours / 2 sessions20191114

$1,100Enrol

DMM3-6A3CCantonese / PC / Central07/1214/12SAT1000-13006 hours / 2 sessions20191207

$1,100Enrol

Data Management with Microsoft Excel 2010
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名
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. You can enrol this course by our online system, or call (852) 3605 3322 for reservation.

You may also be interested in