Online Excel Workshop 基础设置篇 内容概要: 实用办公技巧篇   1. 插入/删除多个空行 2. 自动筛选和高级筛选 3. 多表快速切换 4. 快速调整行高列宽 5. 选择性粘贴 6. 快速填充 – …

Reviews ,

73

Students, Category

Created By

, Last Updated

June 27, 2021

, Course Duration

0 Days

This course includes

On Demand Video & Quiz

0

Units in Course

Access on mobile and TV

Certificate of completion

Online Excel Workshop 基础设置篇

内容概要: 实用办公技巧篇   1. 插入/删除多个空行 2. 自动筛选和高级筛选 3. 多表快速切换 4. 快速调整行高列宽 5. 选择性粘贴 6. 快速填充 – ctrl + e/ enter/ d/ r 7. 单元格内换行 8. 单元格格式 9. text-to-column 10. 打印设置 11. Word/Excel 表格互转 常用公式更新篇 1. Excel365 动态数组 2. 文字公式 3. 日期公式 4. 查询公式应用 5. Vlookup/ xlookup/ sumif/ countif 6. 批量修改公式技巧 7. 公式错误代码讲解 Pivot Table 1. Calculated Field 2. Pivot Table 中排序和筛选 3. 拆分表格 4. Slicer 我们准备了以上实用干货,希望对朋友们能够有帮助!   Featured Speaker Pennie Y. Zhao
Senior Analyst, TAO Admin Pennie is a Senior Analyst at TAO admin. She has over six years of working experience in finance and accounting, with expertise in various accounting and taxation software, including SAP, Simply Accounting, Quickbook, APPAC package, etc. Pennie also has advanced proficiency in Microsoft Office Suite particularly in Excel Visual Basic Applications (VBA) and Pivot tables. Pennie holds a Microsoft Excel Expert certificate (Microsoft 365 Apps and Office 2019), and is a currently a CPA candidate.
Seminar Information Date: Thursday, June 24, 2021 Time: 7:00 pm – 8:30 pm EST (registration starts at 6:45 pm) Session Format: Online Webinar Language: Mandarin Chinese 中文讲解 Cost: Member: Free; Non-member: $15 CPD Credit: 1.5 Hours Enrolment Limit:80 People Once registered, you will receive an email confirmation with webinar details.  Active participation is mandatory for receiving the CPD certificate, including answering all poll questions. 

Course Content

About Instructor

Course Reviews

No Reviews found for this course.

Sponsors

top