|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/complete-excel-finance-course-from-beginner-to-pro/
课程评论：没有评论
Coursera 课程《从入门到精通 - Excel 教程》旨在帮助您提升 Excel 技能，提高工作、学习或个人项目的效率。本课程将教授强大的 Excel 函数，帮助您自动化工作，简化生活。您将学习如何设置和格式化各种财务报表，并利用高级函数深入分析数据。 课程内容涵盖： * Excel 基础：数据输入、公式构建和函数功能 * 专业财务分析设置 * 常见财务报表（如：合并财务报表、损益表）的构建 * 数据深度分析函数 * 多场景模拟 * VLOOKUP、HLOOKUP、INDEX & MATCH 函数 * 动态查询构建 * 财务函数 (NPV, IRR, Payback Period) * 宏的创建 * 债务附表和固定资产附表的创建 * 收入预测 * 统计回归分析 * 数据透视表和仪表板的创建 此外，课程还将分享能给雇主留下深刻印象的快捷键和技巧。每个章节结束后提供测验，以巩固所学概念。 所需材料：电脑、笔记本电脑或平板电脑（预装 Microsoft Excel）以及学习的动力。 课程提供 30 天不满意退款保证。
Why this course is for you You want to increase your Excel skills to become more efficient at work, school, or any personal project. You want to learn powerful Excel functions that will allow you to automate much of your work and make your life easier. You want to learn how to setup and format different financial setups and use advance functions to deeper analyze your data. The functions and formulas you will learn will not only teach you how to use Excel for finance, but it will teach you tools to become an Excel power user in other areas. I will teach you shortcuts and tips that will impress anyone employer. At the end of each section I have also created quizzes for you to make sure you are understanding the concepts and remember them for life! What you will learn: The basics of excel: how to input numbers, how to input formulas, and the different functions of ExcelHow to create a professional financial analysis setupBuild a common size income statementFunctions that will help you analyze your data at a deeperCreate multiple scenariosVlookup, hlookup, index & match functionsHow to build dynamic queriesFinance functions (NPV, IRR, Payback Period)How to create a macroHow to create integrated financial statements (Balance Sheet, Income Statement, Statement of Cash Flows)How to create debt schedules and pp & e schedulesForecasting revenuesRunning a statistical regressionHow to create pivot tables and dashboards What you will need: A computer, laptop, or tabletMicrosoft ExcelHunger to learn 30-day money back guarantee In the rare case that you feel the course was not helpful or isn't for you I will refund your money up to 30 days. You have nothing to lose and everything to gain.
