Project Description
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
- Qualified and experienced instructor
- Easy-to-follow, step-by-step instruction
- Daytime, evening and weekend classes
Learn from the Experts
Get Your Skills Certified
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
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.
| Course No. 課程編號 | Info. 語言/系統/地點 | Start 開課日 | End 完課日 | Day(s) 上課日 | Time 上課時段 | Duration 課程長度 | Enrol 報名 | |
|---|---|---|---|---|---|---|---|---|
| DMM3-6A1K | Cantonese / PC / MongKok | 14/03 | 21/03 | SAT | 1000-1300 | 6 hours / 2 sessions | 20200314 | $1,100Enrol |
| DMM3-12C2C | Cantonese / PC / Central | 20/04 | 21/04 | MON,TUE | 1900-2200 | 6 hours / 2 sessions | 20200420 | $1,100Enrol |
| DMM3-6A2K | Cantonese / PC / MongKok | 23/05 | 30/05 | SAT | 1000-1300 | 6 hours / 2 sessions | 20200523 | $1,100Enrol |
| DMM3-12C3C | Cantonese / PC / Central | 22/06 | 23/06 | MON,TUE | 1900-2200 | 6 hours / 2 sessions | 20200622 | $1,100Enrol |
| DMM3-45C2K | Cantonese / PC / MongKok | 23/07 | 24/07 | THU,FRI | 1900-2200 | 6 hours / 2 sessions | 20200723 | $1,100Enrol |
| 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.
- Smart Formatting Tricks
- The Format Painter
- Styles and Themes
- Conditional Formatting
- Tables: List Management Made Easy
- The Basics of Tables
- Sorting and Filtering a Table
- Dealing with Duplicate Rows
- Performing Table Calculations
- Grouping and Outlining Data
- Basic Data Grouping
- Grouping Timesavers
- Lookup, Reference, and Information Functions
- The Basic Lookup
- Advanced Lookups
- Information Functions
- Advanced Formula Writing and Troubleshooting
- Conditions in Formulas
- Descriptive Names for Cell References
- Variable Data Tables
- Controlling Recalculation
- Solving Formula Errors
- Scenarios and Goal Seeking
- Using Scenarios
- Using Goal Seek
- Solver
- PivotTables
- Summary Tables Revisited
- Building PivotTables
- Multi-Layered PivotTables
- Fine-Tuning PivotTable Calculations
- Filtering a PivotTable
- PivotCharts
- You can enrol this course by our online system, or call (852) 3605 3322 for reservation.
