|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/business-friendly-excel-automation/
课程评论：没有评论
课程名称：商务友好的Excel自动化（公式 + 宏/VBA） 课程概述：本讲座系列涵盖了我精心挑选的顶级Excel公式、宏及函数，这些工具帮助我实现了大多数商业流程的自动化，例如整合多个工作簿中的数据、通过Excel发送数据邮件、数据清理、处理复杂数据结构以及SAP自动化等。课程假设学员具备基本的Excel操作知识，适合拥有少量或没有编程背景的商业用户。大部分材料通过相关的商业应用进行讲解，并提供了一些可重复使用的宏模板，帮助你开始自动化自己的商业流程。课程分为两个视频系列，一个专注于公式，另一个专注于宏/VBA。每个系列包含7到8个小视频，难度逐渐增大，后续视频可能需要以前学习内容的知识。还提供了两个版本的Excel工作簿（.xlsx和.xlsm），一个用于跟随视频并尝试公式/宏，另一个则包含解决方案和详细评论，以帮助你理解每个公式/宏的使用方法。 视频系列1，Excel公式： 1. 基础知识：数学运算符、If / Else、And/Or、列表、Iferror / ifblank / ifnumber 2. 字符串处理：字符串连接、切割字符串 3. Sumif：Sumif和Sumifs 4. Index & Match组合 5. 偏移 6. Sumproduct 7. 间接引用 视频系列2，Excel宏： 1. 基础知识：Hello World、获取和设置范围/单元格 2. 范围管理 3. 复制与粘贴 4. For循环 5. If Else逻辑 6. 从其他工作簿（Excel文件）导入数据* 7. 发送电子邮件* 8. 使用Excel宏进行SAP自动化** 本课程配有易于重复使用的模板。
This lecture series will cover my pick of top Excel Formulas, Macros and/or functions that helped me automate the majority of business processes I have encountered such as consolidating data from multiple workbooks, sending emails with data from Excel, data cleanup, handling of complicated data structure, SAP automation, etc.The two series is taught assuming basic Excel operation knowledge suitable for business users with little to no programming background.Most of the materials are taught with relatable business applications and some Macros are provided as easily reusable templates to help you get started in automating your own business processes.The course is separated into two video series, one for Formulas and another for Macro / VBA. Each series has 7 or 8 bite size videos which get progressively more difficult and may require learnings from a previous video. Two versions of Excel.xlsx and.xlsm workbooks are also provided; one for you to follow along the video and attempt the Formulas/Macros for yourself and one with the solutions along with detailed commentary to help you understand how to use each Formula/Macro taught.Video Series 1, Excel Formulas:1. Basics: Mathematical Operators, If / Else, And/Or, List, Iferror / ifblank / ifnumber2. String Manipulation: Concatenation, cutting strings3. Sumif: Sumif and Sumifs4. Index & Match combination5. Offset6. Sumproduct7. Indirect ReferenceVideo Series 2, Excel Macros:1. Basics: Hello World, Get and Set Range / Cells2. Range Management3. Copy & Paste4. For Loops5. If Else Logic6. Importing Data from other workbooks (Excel files)*7. Sending Email*8. SAP Automation using Excel Macro**With Easily Reusable Templates
