詳細課程介紹

Microsoft Excel is widely used amongst all expertise. Most users have some basic understanding of Excel, but may need a hand when it comes to the operating the special features. There are many functions and tips which users can benefit from to achieve better results in their Excel practice. This course is suitable for general users to participate, where classes go through practical use and focuses on a variety of Excel tips, application skills and troubleshooting.

課程合適對象

你正面對這樣的情況嗎？

  • 經常使用 Excel 工作的人士

  • 需要加快工作效率

課程目標

完成課程後，學員能夠：

  • Workbook and worksheet management

  • Hacking Excel’s built-in features

  • Hacking Pivot Table

  • Naming Hacks

  • Hack formulas and functions

Course curriculum

    1. 課程迎新及啟動需知

    2. 課程練習文件

    1. Create a Personal View of Your Workbooks

    2. Enter data in multiple worksheets at the same time

    3. Remove Phantom Workbook Links

    1. Control Conditional Formatting with Checkboxes

    2. Count or Sum Cells That Meet Conditional Formatting Criteria

    3. Random Sorting

    4. Support Multiple Lists in a Combo Box

    5. Turn Conditional Formatting and Data Validation On and Off with a Checkbox

    6. Validate Data Based on a List on Another Worksheet

    1. Name Range

    1. How to Create a basic pivot Table

    2. Pivot Table Fundamentals

    3. Preparing Data for pivot Table Reporting

    4. Timeline

    5. Using Slicers

    1. Add Descriptive Text to Your Formulas

    2. Compare Two Excel Ranges

    3. Fill All Blank Cells in a List

    4. Make Your Formulas Increment by Rows When You Copy Across Columns

    5. Sum or Counting Cells While Avoiding Error Values

    6. Use the VLOOKUP Function Across Multiple Tables

About this course

  • $600.00
  • 23 個課堂
  • 2.5 小時的短片內容

關於本課程

  • 畢業要求

    完成課節(觀課70%或以上內容)，提交習作並合格，即會獲頒修業證書。

  • 上課前的準備

    你需要一部 Windows 系統電腦，已安裝 Microsoft Excel 2016 或較新版本在內。

  • 教學支援

    當值課程主任支援課堂操作，導師常駐討論室回答學生疑難。

版本選擇

你可按需要選擇最適合的版本，相同課程日後升級只需補回差額。