Session Outline
- Master the skills of using Excel to improve working methods and working efficiency.
- Design pleasing and professional data reports.
- Use three or more nested functions to solve complex work problems.
- Create excellent professional charts.
- Easily sort, filter, and summarize data.
- Use PivotTables to write any kind of report you want.
1. ่กจๆ ผๆ นๅบ๏ผ้ซ็บงๆไฝๆๅทง
1.1. ๅๅไธๅฟซ้ๅกซๅ
1.2. ๆกไปถๆ ผๅผ
1.3. ๆ ่ฎฐๅๅ ้ค้ๅคๅผ
1.4. ๆฐๆฎ้ช่ฏ
1.5. ๆฐๆฎไฟๆคๅฏ็ ่ฎพ็ฝฎ
2. ๅ่กจ็ฎก็๏ผๆฐๆฎๆด็ไน้
2.1. ๅๅนถ่ฎก็ฎ
2.2. ้ซ็บง็ญ้
2.3. ๆๅบๅ็ญ้็่ๅไฝฟ็จ
3. ่กจๆ ผ็ต้ญ๏ผๅฝๆฐๅ ฌๅผ้ญ ๅ
3.1. ไฝ ๅฟ ้กป็ฅ้็ๅฝๆฐๅ ฌๅผๅบ็ก
3.2. ๅ ฌๅผ็ๅๅธ่ฎก็ฎไธ่ฐ่ฏๆๅทง
3.3. ๆๆฌๅฝๆฐ
3.4. ็ป่ฎกๆฑๅๅฝๆฐ
3.5. ้ป่พๆฅๆพๅฝๆฐ
4. ่กจ้ๅฆไธ๏ผๆบ่ฝ่กจๆ ผ
4.1. ๅฟซ้็พๅ่กจๆ ผ
4.2. ๅป็ป้ฆ่ก
4.3. ่ชๅจๆฑๆป
4.4. ๅ ฌๅผ่ชๅจๅกซๅ
5. ่กจๆ ผๅฉๅจ๏ผ้่ง่งๅๅๆ
5.1. ๅ่กจๅๅค่กจๅๅปบ้่ง่กจ
5.2. ่ชๅจๅ็ปๅๆๅจๅ็ป
5.3. ๅ็ๅจ่ๅจ
5.4. ๅผๆฑๆปๆนๅผ
5.5. ๅจๆๆฐๆฎ้่ง่กจ
6. Power Query
6.1. ๅทฅไฝ็ฐฟ่ชๅจๆฑๆป
6.2. ๆไปถๅคน่ชๅจๆฑๆป
6.3. ๆฐๆฎๅ็ป
6.4. ๅๅนถๅ่ฟฝๅ ๆฅ่ฏข
7. ่กจๆ ผๅฐ่ฑก๏ผๅพๆ ๆผ็คบไน้
7.1. ๅ็งๅพ่กจ็ฎไป
7.2. ๅพ่กจ็ฑปๅ้ๆฉๅปบ่ฎฎ
7.3. ๅถไฝ็พ่งไธไธ็ๅพ่กจ
7.4. ่ฟทไฝ ๅพใๅY่ฝดๅพใๅคๅ้ฅผๅพ็ญๅถไฝ
7.5. ๅพ่กจ็พๅไธ้จๆฒ
8. ๆป็ปๆ้ซ๏ผๅญฆไปฅ่ด็จ๏ผๆดไฝ็ญ็
1. Table Basis: Advanced Skills
1.1. Text to columns and flash fill
1.2. Conditional formatting
1.3. Mark and delete the duplicates
1.4. Data validation
1.5. Data protection
2. Table Management: Data Consolidation
2.1. Group calculation
2.2. Advanced filtering
2.3. Sorting and filtering
3. Soul of Table: The Charming of Formulas
3.1. Formulas basis you need to know
3.2. Formulas evaluating and debugging
3.3. Text formulas
3.4. Statistical formulas
3.5. Lookup &reference formulas
4. AI Excel: Smart Table
4.1. Quickly beautifying table
4.2. Header freezing
4.3. Automatically summing up
4.4. Automatically filling up formulas
5. The Weapon of Table: PivotTable
5.1. Creating PivotTable from single and multiple worksheets
5.2. Date, number and text grouping
5.3. Slicer connection
5.4. Summarized value type
5.5. Dynamic PivotTable
6. Power Query
6.1. Automatic summarizing of workbook
6.2. Automatic summarizing of file
6.3. Data grouping
6.4. Queries merging and appending
7. The Impression of Table๏ผBusiness charts
7.1. Brief Introduction of charts
7.2. Suggestion on choosing charts
7.3. Making professional and beautiful charts
7.4. Sparklines, combo charts and pie of pie, etc.
7.5. 3 steps to beautify charts
8. Q&A
