- 提示:
- 透過本站連結購買Udemy課程，本站將獲得推廣佣金，有助未來提供更多實用進修課程資訊給讀者。
課程資料
報名日期*
全年招生
課程級別
學習模式
修業期
12 小時 58 分鐘
教學語言
英語
授課導師
Kenan Çılman
證書
- 可獲發
- (證書的發放與分配，依課程提供者的政策及安排而定。)
評分
*提示: 以上時間表僅供參考，以機構網站為準。
課程簡介
Learn Excel, develop strategy, solve business life affairs
This course is ideal for anyone who wants to learn Excel. The course is designed with an understandable and easy in English. The main goal of the course is to teach all the requirements you need in business life and to use Excel in the most efficient manner.
All videos here have examples and Excel files, and all of them are examples of real business life.
課程章節
- 8 個章節
- 61 堂課
- 第 1 章 Introduction
- 第 2 章 For Beginners
- 第 3 章 Data Management in Excel
- 第 4 章 Excel Formulas
- 第 5 章 Advanced Excel
- 第 6 章 Graphics in Excel
- 第 7 章 Linear Modelling in Excel
- 第 8 章 Useful Tips
課程內容
- Excel Fundamentals
- Formats, Fonts and Design
- Worksheet Properties
- Data Management in Excel
- Data Sort
- Data Sort From Left to Right
- Data Filter
- Table
- Remove Dublicates
- Custom List
- Subtotal and Data Groups
- Pivot Table
- Pivot Table Properties and Options
- User Defined Formulas in Pivot Table
- Merge Pivot Tables
- Excel Formulas
- Structure of Excel Formulas
- Text Formulas
- Flash Fill
- Statistical Formulas
- Date and Time Formulas
- SUBTOTAL Function For Filter
- Lookup Functions
- VLOOKUP For 2 Tables
- Advanced Filter Functions
- FORMULAS Menu
- Advanced Excel
- Data Validation
- Conditional Formatting
- Special Cells (GOTO SPECIAL)
- External Data From Other Sources
- Name Manager
- Consolidation
- Watch Window and Trace Cells
- Excel Protection
- Printer Settings
- Relation of PDF and Printer
- Graphics and Charts in Excel
- Simple Graphs
- Column Graphs
- Pie Chart Graphs
- Picture Graphs
- Graphics into the Cells
- Linear Modelling in Excel
- Goal Seek
- What-if Analysis / Data Table
- Excel Solver
- Senario Analysis
- Useful Tips
- Copy - Paste Options
- F4 Key
- Fix Headers
- VIEW Menu
- ComboBox
- Trendline
- Spin Button
- Animated Charts
- Scroll Bar
- Draw Shapes
- Fix Formulas (Details of F4 Key)
- Creating Custom Menu
- Watch Movie and Listen Music in Excel
此課程所涵蓋的技能
評價
-
MMuhammet Faruk Safa
Çok verimli bir eğitimdi🙏
-
UUdemy Hoca
teşekkürler
-
AAngie Castejon
Very detailed and informative.
-
AAbdullah Akıllıoğlu
Perfect
