課程資料
報名日期
全年招生
課程級別
學習模式
修業期
3 小時 44 分鐘
教學語言
英語
授課導師
Stanley Ka
證書
- 可獲發
- *證書的發放與分配，依課程提供者的政策及安排而定。
評分
1次瀏覽
課程簡介
Microsoft Excel (2007, 2010, 2013, 2016)
• Learn from an experienced consultant with over 10 Years of MS Excel and MS Access experience
• Hands-on practical exercises that you can use in real life and on the job.
• Beginner and Intermediate concepts covered
• Useful for Excel Beginners, College and University Students, and New Job seekers who would like to improve their skills
課程章節
- 12 個章節
- 36 堂課
- 第 1 章 Introduction
- 第 2 章 Formatting Data
- 第 3 章 Conditional Formatting
- 第 4 章 Working with Cells
- 第 5 章 Excel Functions and Series
- 第 6 章 Sort and Filter
- 第 7 章 Pivot Tables: Summarizing Data
- 第 8 章 Working with Text
- 第 9 章 Intro to Charts
- 第 10 章 IF Function: Evaluating Numbers, Text, and Logical Statements
- 第 11 章 Intermediate Concepts
- 第 12 章 Excel Shortcuts
課程內容
- Formulas and Functions
- Sorting Data Quickly
- Filtering Data
- Conditional Formatting (Highlighting information if a certain condition is met)
- Working and Manipulating Text (Working with Names, Addresses, and Other Customer Data)
- Summarizing Data through Pivot Tables (Summarize a client base quickly and draw conclusions)
- Pulling Data from a different database (HLookup and VLookup Functions - Merging Customer Data)
- How to evaluate logical statements quickly and efficiently (IF Functions and variations)
此課程所涵蓋的技能
評價
-
SSJ Almand
THE LESSONS ARE GOOD BUT SOME OF THE RESOURCES COME READY POPULATED AND THEREFORE ARE NOT INTERACTIVE. RATHER DISAPPOINTING.
-
JJob Yuya Ndombasi
Well I do have experience with it, but the basics are fully covered and carefully explained on a way that any levels of experience may enrol this course. And it does indeed offer some really cool and helpful problem solving methods that you can rely on.
-
DDarshana Kashyap
The experience with the tutorials was really nice, the method chosen to explain every details was much appreciated.
-
VVishwanath Biswal
Wonderful..!! Earlier, I was a not aware of Excel, and this tutorial taught me a lot. I like the way of teaching, because Stanley ka taught each and every concepts from the very basics. Thank you.
