你好, 本人成人想找老師學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