Online Excel Workshop 基础设置篇 内容概要: 实用办公技巧篇 1. 插入/删除多个空行 2. 自动筛选和高级筛选 3. 多表快速切换 4. 快速调整行高列宽 5. 选择性粘贴 6. 快速填充 – …
Reviews ,
73
Students, Category
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.
Course Content
About Instructor
Course Reviews
$15.00
30 day money back. Full Lifetime Access
Requirements
- Knows English
- Understands Basics
Material Included
- Basic Course Structure
- Advanced Levels