|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-essentials-for-accounting-finance/
课程评论：没有评论
**课程名称：** Microsoft Excel Essentials for Accounting & Finance **课程概述：** 本课程专为希望弥补 Microsoft Excel 知识空白、优化职业生涯早期工作流程的会计和金融专业人士设计。课程将为您奠定坚实基础，侧重于日常使用的基础到中级实用技能，帮助您更高效地完成工作，从而推动职业发展。课程将结合真实的会计和金融案例，将模块内容与您的专业工作紧密联系起来，并展示这些技能如何影响了其他会计和金融领域的专业人士！ 本课程面向 Excel 初学者，涵盖 Excel 工作簿和工作表的含义、工作簿的组成菜单、数据格式设置、处理大型数据集的技巧，以及用于优化工作流程的基础到中级工具和功能。 **涵盖概念：** * 格式设置与数据呈现 * 数据清洗 * 数组与表格 * 快捷键（键盘操作替代鼠标） * IF 语句逻辑 * 错误预防 **基础函数：** UPPER, LOWER, PROPER, ROUND, TRIM, LEN, EXACT, RIGHT, LEFT, MID, CONCAT, SUM, COUNT **中级/高级函数：** SUMIF, COUNTIF, INDEX, MATCH, INDEX(MATCH), VLOOKUP **工具：** * 排序与筛选 * 复制粘贴（基础、值、公式、运算、转置） * 删除重复值 * 条件格式
This course is for Accounting & Finance professionals that want to overcome the Microsoft Excel knowledge gap to optimize their workflow early in their career. This will build a foundation for you as this course focuses on basic to moderate fundamentals and technical skills that can be used every day and can advance your career by giving you the tools to perform your work more efficiently. Real world Accounting & Finance examples will be used as we form the connection between the modules of this course and how they can be used in your professional life, as well as how they have already impacted other professionals in the Accounting & Finance world! Being a course more tailored to Excel beginners at a basic proficiency level, this course will cover topics like the basic meaning of an "Excel Workbook" or "Excel Worksheet", the different menus that make up a workbook, formatting your data, tips for working with large datasets, and basic to moderate tools and functions for workflow.Concepts Covered: Formatting and Data Presentation, Data Cleansing, Arrays vs Tables, Keystrokes (working with your keyboard instead of mouse), IF Statement Logic, Error PreventionBasic Functions: UPPER, LOWER, PROPER, ROUND, TRIM, LEN, EXACT, RIGHT, LEFT, MID, CONCAT, SUM, COUNTModerate/Advanced Functions: SUMIF, COUNTIF, INDEX, MATCH, INDEX(MATCH), VLOOKUPTools: Sort and Filter, Copy & Paste (Basic, Values, Formulas, Operations, Transpose), Delete Duplicate Values, Conditional Formatting
