教育王國

標題: 誠請<EXCEL 專家> - 教成人 (元朗/旺角區) [打印本頁]

作者: jannylaw0926 時間: 16-10-18 19:16 標題: 誠請<EXCEL 專家> - 教成人 (元朗/旺角區)

你好, 本人成人想找老師學EXCEL. 主要是學以下內容, 地點可大家就 . 有意請PM我, 謝謝.
Formula and Functions
- Common functions review: SUM, AVERAGE, COUNT ,MAX ,MIN
- Advanced functions for Text handling – LEFT, RIGHT, MID, LEN, UPPER, LOWER
- Advanced functions for Number handling – ROUND, RANDOM
- Advanced functions for Date calculations – DATEDIF, NETWORKDAYS, WEEKDAY
- Advanced functions for Logical decisions – IF, NOT, AND, OR
- Advanced functions for Data Lookup – VLOOKUP, HLOOKUP
- Database functions – DSUM, DMIN, DMAX, DCOUNT, DAVERAGE
- Formula Tracing and Error Checking

Pivot Table and Data Analysis

- Create and understand Pivot Table
- Create various analysis report from different perspective
- Create Pivot Charts
- Auto summarize data by quarter, season or year.

Charting

- Create various charts like bar chart, pie chart and line charts
- Format various charts features like axis, legend, titles and background

Macro Recorder

- To record and run a macro
- To edit a macro
- Macros available to other workbooks
- To run a macro from a toolbar button

歡迎光臨教育王國 (/)