義工

求職招聘 今日: 4|主題: 40838

查看: 283 | 回覆: 2
誠請<EXCEL 專家> - 教成人 (元朗/旺角區)


大宅

國民生產總值:1416


發表於 16-10-18 19:17 |顯示全部帖子
你好, 本人成人想找老師學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




王國熱話
買 LEGO
屋企多唔多boardgame?
3D筆都幾好玩
Rumikub


伯爵府

國民生產總值:16536

畀面勳章 叻叻勳章 wyeth冷知識勳章 大廚勳章 BK Milk勳章 hashtag影視迷勳章


發表於 16-10-18 20:11 |顯示全部帖子

回覆樓主:

外間有d機構免費報讀
試下搜尋erb課程,睇下你個間有冇機構開班


大宅

國民生產總值:1416


發表於 16-10-18 21:52 |顯示全部帖子
wing324 發表於 16-10-18 20:11
外間有d機構免費報讀
試下搜尋erb課程,睇下你個間有冇機構開班

Thank youuuuuu


© Baby-Kingdom.com Limited. All rights reserved.