- 提示:
- 透過本站連結購買Udemy課程，本站將獲得推廣佣金，有助未來提供更多實用進修課程資訊給讀者。
課程資料
報名日期*
全年招生
課程級別
學習模式
修業期
0 小時 45 分鐘
教學語言
英語
授課導師
Viliam Gregus
評分
*提示: 以上時間表僅供參考，以機構網站為準。
課程簡介
VLOOKUP, Pivot Tables, Charts, IF, Autofill, Conditional formating and much more with real-life examples.
In this course you will learn the most-used Excel skills which are most commonly required from top companies:
- VLOOKUP
- Pivot Tables
- IF function
- Charts
- Autofill
- SUM,MIN,MAX,AVERAGE and other basic formulas
- Sorting and filtering
- Conditional formatting and more.
Everything is presented on real-life examples and in a timely manner. All videos are 5 minutes or shorter, ensuring you wont loose focus and stay motivated during the course. You will get a file with 25 tasks where you can exercise your newly aquired knowledge, all tasks are solved in the videos by the Lector.
This course is for:
- Excel beginners and intermediate users with elementary knowledge of Excel (knowing how to input data, copy cell etc.)
課程章節
- 1 個章節
- 10 堂課
- 第 1 章 Lectures
課程內容
- Basic, most-commonly used Excel skills: VLOOKUP, Pivot Tables, Charts, IF function, Conditional formatting, Autofill, Sorting, Filtering, Table Trnsformation etc.
此課程所涵蓋的技能
評價
-
DDonna Goss
He is very concise an easy to follow in his directions. Found this class very informative.
-
MMorgan Klaif
I needed a refresher on some Excel functionality, and this provided it. I would have liked to see some further explanations or a larger dive into some extra capabilities, such as being able to use "add to data model" in the pivot tables to count distinct.
-
HHaruki Uike
It is concise but it included key functions/techniques. It is suitable for those who want to have overview of various Excel skills and what we can do with Excel.
-
AAbdulaziz
very useful information on analyzing data
