终极 Excel 课程
与丹·斯特朗（Dan Strong）一起从头开始学习Excel VBA，他是全球最畅销的Excel专家，拥有超过180K的学生！
教程演示🔗
What you’ll learn 学习内容
-
Automate and Customize data entry forms
自动化和自定义数据输入表单 -
Choose the right Loop for each task
为每个任务选择正确的循环 -
Master the CELLS and RANGE objects in multiple scenarios
在多个场景中掌握 CELLS 和 RANGE 对象 -
Create multiple Variable styles to match your need
创建多个变量样式以满足您的需求 -
Customize your VBA Editor and Understand all the Toolbars and options
自定义VBA编辑器并了解所有工具栏和选项 -
Debug and Troubleshoot code like a boss!
像老板一样调试和排除代码故障！ -
Record, Modify or Write Macros from scratch
从头开始录制、修改或写入宏 -
Make Custom Formulas/Functions on the fly
即时制作自定义公式/函数 -
Breeze through IF THEN statements and conquer all the Logical Operators
轻而易举地浏览 IF THEN 语句并征服所有逻辑运算符 -
Batch out inter-active MessageBoxes, InputBoxes and give users CHOICES!
批量输出交互式 MessageBox、InputBox，并为用户提供选择！ -
Generate Basic Reports that can be printed
生成可打印的基本报告 -
Add filters to report menus to narrow the records
向报表菜单添加筛选器以缩小记录范围 -
Take control of forms, Buttons, Drop-down menus, Checkboxes and option buttons AND so much more. . .
控制表单、按钮、下拉菜单、复选框和选项按钮等等。 . -
Trigger code from a number of different methods – from Clicking on a cell – to De-Selecting a worksheet.
从许多不同的方法触发代码 – 从单击单元格 – 到取消选择工作表。 -
Set up Special Commands when a workbook: Opens or closes, is selected, any cell or certain cells are selected, right before printing, etc. . .
在工作簿时设置特殊命令：打开或关闭、选择、选择任何单元格或某些单元格、在打印之前等。. -
Manipulate Userforms for data entry, report generation, editing tables/databases – ALL within your control. Restrict the flow of data OR make the Userform(s) responsive, calculating, INTUITIVE.
操作用户表单进行数据输入、报告生成、编辑表/数据库 – 一切都在您的控制范围内。限制数据流或使用户窗体响应迅速、计算迅速、直观。 -
Streamline your work and the work of others.
简化您和其他人的工作。 -
Put Excel ON AUTOPILOT. . .
将 Excel 置于 AUTOPILOT 上。 。 。 -
Trigger Macros using Worksheet and UserForm Controls (Buttons, Shapes, DropDowns, ListBoxes, Click Actions, Loads of Fun Controls)
使用工作表和用户窗体控件（按钮、形状、下拉列表、列表框、单击操作、大量有趣的控件）触发宏 -
Change Cell Properties using code – Cell Color, Font Properties (Bold, Italic, Underline, etc), Borders and more!
使用代码更改单元格属性 – 单元格颜色、字体属性（粗体、斜体、下划线等）、边框等！ -
Master Beginning to Advanced Math with Variables and Learn Proper Use, Declaration and Scope
掌握变量的初级高级数学，并学习正确的使用、声明和范围 -
Learn String Functions, Concatenation and How to Control Case-Sensitivity with VBA Functions
学习字符串函数、串联以及如何使用 VBA 函数控制区分大小写 -
Create Your Own Functions to be used In VBA or in a Cell!
创建您自己的函数以在 VBA 或单元格中使用！ -
Uncover Advanced Search Functions Only Available in VBA
发现仅在 VBA 中可用的高级搜索功能 -
Fun with Date and Time Math to Calculate Duration, Length and Intervals
使用日期和时间数学来计算持续时间、长度和间隔 -
PROJECTS: Create Full Games, Learn From Coding Exercises and Enjoy Mid-Lecture Challenges!
项目：创建完整的游戏，从编码练习中学习，并享受讲座中的挑战！ -
Discover and Master the VBE (Visual Basic Editor) and All the Mysterious Buttons and Features Within!
发现并掌握 VBE（Visual Basic 编辑器）以及其中所有神秘的按钮和功能！ -
Deal With Errors and Learn How To Prevent Them
处理错误并学习如何预防错误 -
Feed Information from One Macro to Another using ByRef and ByVal Methods
使用 ByRef 和 ByVal 方法将信息从一个宏馈送到另一个宏 -
Utilize Variable Types: Constants, Static, Module-Level, Public, Private, ‘Option Private Module’, etc
利用变量类型：常量、静态、模块级、公共、私有、“选项私有模块”等 -
BONUS #1: Free e-book “Excel VBA Master Keyboard Shortcuts” – Now with more shortcuts (for PC and Mac) than anywhere else
奖励#1：免费电子书“Excel VBA Master Keyboard Shortcuts” – 现在比其他任何地方都拥有更多的快捷键（适用于 PC 和 Mac） -
BONUS #2: Free Image Tools For Better Looking Buttons, Images and Form Backgrounds
奖励#2：免费图像工具，用于更好看的按钮，图像和表单背景 -
BONUS #3: Free Mouse Icons Packs To Customize MouseOver Effect on Many Controls Including a UserForm Background!
奖励#3：免费的鼠标图标包，用于在许多控件（包括用户窗体背景）上自定义鼠标悬停效果！ -
Three Methods of Accessing a Worksheet using Code
使用代码访问工作表的三种方法 -
Get the Boundaries of a Range of Cells the way Pros do (Better LastRow and LastCol Techniques)
像专业人士一样获取一系列单元格的边界（更好的 LastRow 和 LastCol 技术） -
Dynamically Sort or Filter Data. You can have multiple sort options, each assigned to different buttons!
动态排序或筛选数据。您可以有多个排序选项，每个选项分配给不同的按钮！ -
Utilize User-Input (MessageBoxes, InputBoxes, UserForms) and Use Conditional Logic (IF THEN, CASE STATEMENTS, AND, OR, NOT) to Control Direction
利用用户输入（MessageBoxes、InputBox、UserForms）并使用条件逻辑（IF THEN、CASE STATEMENTS、AND、OR、NOT）来控制方向 -
Insert Worksheet Functions into Cells Programmatically Using Regular or R1C1 Notation
使用常规或 R1C1 表示法以编程方式将工作表函数插入单元格 -
Practice Code Slimming and Efficiency Techniques, such as WITH/ END WITH statements
练习代码精简和效率技术，例如 WITH/END WITH 语句 -
Speed Up Your Code Massively with Dan’s “VBA Speed Hacks”
使用 Dan 的“VBA Speed Hacks”大幅加快代码速度 -
Get Random Numbers to Generate Passwords, Create FileNames, Produce Random Actions In Games/Projects, Speed Tests
获取随机数以生成密码、创建文件名、在游戏/项目中生成随机动作、速度测试 -
Search Cells and Strings with Advanced Pattern Matching & Comparison, LIKE Operator and InStr Functions
使用高级模式匹配和比较、LIKE 运算符和 InStr 函数搜索单元格和字符串 -
Advanced MessageBox Features (Including Special Icons, Direction, Buttons: Yes/No, Yes/No/Cancel, Abort/Retry and many more…)
高级 MessageBox 功能（包括特殊图标、方向、按钮：是/否、是/否/取消、中止/重试等等…… -
Create Optional UDF Parameters and choose Volatile or Non-Volatile Functionality
创建可选的 UDF 参数，然后选择易失性或非易失性功能
Requirements 要求
-
You should already have Microsoft Excel (version 2003 and up). Obviously the newer the better, but VBA works the same in all versions. It’s just that newer versions have more options, thus more VBA Commands to control those options.
您应该已经安装了 Microsoft Excel（版本 2003 及更高版本）。显然，更新越好，但 VBA 在所有版本中的工作方式都相同。只是较新的版本有更多的选项，因此有更多的VBA命令来控制这些选项。 -
Very very basic Excel skills needed for this course (like opening the program, how to click on cells and type things.) You really don’t need any Excel experience, because I’ll take you from Start to Finish in this course. I was just trying to be funny.
本课程需要非常非常基本的Excel技能（例如打开程序，如何单击单元格和键入内容。你真的不需要任何Excel经验，因为我将在本课程中带你从头到尾。我只是想搞笑。
Description 描述
Teach Excel to Do Your Work FOR YOU. . .
教 Excel 为你做你的工作。。。
Microsoft Office is everywhere, installed on over 750 million computers, but most users only know how to set up a basic table or maybe even do a few formulas here and there.
Microsoft Office无处不在，安装在超过7.5亿台计算机上，但大多数用户只知道如何设置基本表格，甚至可能在这里和那里做一些公式。
In my course, I teach you how to take Excel by the horns and make it do whatever you want, whenever you want. It can go through loads of information and create a printable report for you. You can make custom forms so that you can access, analyze, edit, or add new information quickly to your data tables/ worksheets.
在我的课程中，我教你如何掌握 Excel，让它随时随地做任何你想做的事。它可以浏览大量信息并为您创建可打印的报告。您可以创建自定义表单，以便您可以快速访问、分析、编辑或将新信息添加到您的数据表/工作表中。
Excel programming utilizes a simple but effective tool called “VBA” – the hidden programming language that runs quietly in the background while you work. It’s very easy and straight-forward to use.
Excel 编程利用一种简单但有效的工具，称为“VBA”——一种隐藏的编程语言，在您工作时会在后台安静运行。它使用起来非常简单明了。
I’ll show you the easiest tricks to learn this basic language in a fun, progressive method. Learn at your own pace. With each of my short, info-packed lectures, you’ll learn another essential skill that you can immediately use. You’ll find yourself handling these Automation tools instantly and in any spreadsheet you already use every day. If there’s one thing I’m good at – and my students are good at – it’s AUTOMATION.
我将向你展示以一种有趣、渐进的方法学习这种基本语言的最简单技巧。按照自己的节奏学习。通过我的每一个简短的、信息丰富的讲座，你将学到另一项可以立即使用的基本技能。您会发现自己可以立即在每天使用的任何电子表格中处理这些自动化工具。如果说有一件事是我擅长的，我的学生也擅长的，那就是自动化。
My motto is, “If I’m not making everybody’s job easier, quicker and more enjoyable, I don’t deserve to have this job” – and that’s what I live by.
我的座右铭是，“如果我不让每个人的工作更轻松、更快捷、更愉快，我就不配拥有这份工作”——这就是我赖以生存的。
Take this course and access your true potential.
参加这门课程，发挥你的真正潜力。
Oh, and I want to be the first to hear about your New Raise you get once you’re making Excel Programs and running everything on autopilot for your co-workers!
哦，我想成为第一个听说你的新加薪的人，一旦你制作了Excel程序，并在你的同事的自动驾驶仪上运行了所有的东西！
-Dan -担
Here’s what some of the students are saying:
以下是一些学生所说的话：
“I love this course. Extremely easy to follow along. If you are looking to learn more about Excel this is it!” – Jim C.
“我喜欢这门课程。非常容易跟上。如果您想了解有关 Excel 的更多信息，就是这样！
“Loving this course! The information is presented quite clear and concise, and it is a really great way of learning VB really fast, yesterday I was a total ignorant of the subject. Today I programmed my first macro and cannot wait to learn more.” – Marcela T.
“喜欢这门课程！信息呈现得非常清晰简洁，这是快速学习 VB 的好方法，昨天我对这个主题完全一无所知。今天，我编写了我的第一个宏，迫不及待地想了解更多。
“I had experimented with VBA previously, but I really feel like this course is exactly what I needed to take my Excel knowledge to the next level. In only 2 weeks I’ve improved my reporting exponentially and it’s all thanks to this course!” – Ryan S.
“我以前尝试过 VBA，但我真的觉得这门课程正是我将 Excel 知识提升到新水平所需要的。在短短 2 周内，我的报告就成倍地提高了，这一切都要归功于这门课程！
“You can’t go wrong with Daniel Strong!” – Steven S.
“丹尼尔·斯特朗（Daniel Strong）不会出错！”
“The presenter explains in detail and demonstrates what he’s covering, easy to follow along and learn!” – David B.
“演讲者详细解释并演示他所涵盖的内容，易于理解和学习！”
“Teaches you the fundamental of VBA programming without any prior experience. Shows with easy to follow Example!. thanks for the video!” – Sean C.
“教你VBA编程的基础知识，无需任何经验。显示易于遵循的示例！。谢谢你的视频！
“I’ve taken several different VBA courses here on Udemy and this one from Daniel is by far the most interesting and easy to understand. I’ve done exactly 107 lectures so far and already was able to automate 80% of my tasks at work that I’ve been doing manually for years… I’m angry with myself because of the time I wasted by not buying this course earlier. I can’t even imagine what I will be able to do after finishing the entire course :)” – Robert
“我在 Udemy 上学习了几门不同的 VBA 课程，而 Daniel 的这门课程是迄今为止最有趣、最容易理解的。到目前为止，我已经完成了 107 场讲座，并且已经能够自动化我多年来一直手动完成的工作任务的 80%……我对自己很生气，因为我没有早点购买这门课程浪费了时间。我什至无法想象在完成整个课程后我能做什么:)“ – 罗伯特
“Well explained, easy to understand lectures. Enjoyable and informative videos.” – Marlena
“解释得很好，易于理解的讲座。令人愉快且内容丰富的视频。
“Very clear explanations broken down in short videos. Daniel goes at a slow pace that is easy to follow and understand, even for people with no programming experience.” – Gustavo P.
“在短视频中分解了非常清晰的解释。丹尼尔的步伐很慢，很容易理解和理解，即使对于没有编程经验的人来说也是如此。
“Best course on VBA ever taken. Thanks a lot!” – Nikita L.
“有史以来最好的 VBA 课程。非常感谢！
“This is an excellent course!!! There’s a lot of good, useful “stuff” here. The examples are practical and real-world!” – Todd W.
“这是一门很棒的课程!! 这里有很多好的、有用的“东西”。 这些例子是实际的和现实世界的！
“Wow, I thought I knew a little bit about Excel but clearly I had only seen the tip of the iceberg. This course has opened my eyes to the true power of VBA within excel. Great course, fantastic instructor.” – Scott K.
“哇，我以为我对 Excel 有一点了解，但显然我只看到了冰山一角。这门课程让我大开眼界，了解了 excel 中 VBA 的真正力量。很棒的课程，出色的教练。
“By large and far, one of the best step by step guide to VBA programming I have ever seen. I have been playing around with VBA for over a year now, have watched countless videos and have read numerous articles and “How-to” guides, but I have never seen something this complete, this throughout. I am amazed at how little I actually new about the VBA world. Thanks a million!” – Alex B.
“到目前为止，这是我见过的最好的 VBA 编程分步指南之一。我已经玩了一年多的 VBA，观看了无数的视频，阅读了无数的文章和“操作方法”指南，但我从未见过如此完整、如此完整的东西。令我惊讶的是，我对 VBA 世界的实际了解如此之少。非常感谢！
“Everything I have been looking for, you would have to buy multiple books for this level of instruction!” – Luke S.
“我一直在寻找的一切，你都必须购买多本书才能获得这种级别的教学！”
“Excellent VBA basic to advance tutorial.” – Sandeep G.
“优秀的 VBA 基础高级教程。”
“This course is good for beginners and for experienced programmers. Experienced programmers may want to skip through some sections on basics, but it is good to see how the basics work in the context of and excell worksheet. He goes over different events and triggers (like buttons) to execute code. This is a really good course if you plan to do some pretty complex vba code with forms and reports.” – Christian H.
“这门课程适合初学者和有经验的程序员。有经验的程序员可能想跳过一些关于基础知识的部分，但最好看看基础知识在 和 excell 工作表的上下文中是如何工作的。他遍历了不同的事件和触发器（如按钮）来执行代码。如果你打算用表单和报告做一些非常复杂的vba代码，这是一门非常好的课程。
“Very helpful if you do any type of data analysis.” – Jonathan D.
“如果您进行任何类型的数据分析，都会很有帮助。”
“I think this is an excellent gateway to the tools we need to use going forward. I like the
“我认为这是通往我们未来需要使用的工具的绝佳途径。我喜欢
hands on nature.” – Andre C.
亲身亲近大自然。
“Much better than other classes and seminars. Great course.” – Mark S.
“比其他课程和研讨会好得多。很棒的课程。
“The instructor made VBA easy and straight forward to use.” – Min Z.
“讲师使 VBA 易于使用。”
“Very thorough and practical.” – Juan S.
“非常彻底和实用。”
***Now Available for Offline Viewing!***
现在可供离线观看！
Who this course is for:
本课程适用于谁：
- This Excel course is for anyone who wants to learn Automation secrets in Excel VBA. It’s for complete newbies and/or students looking for a refresher or Reference tool, to pick and choose relevant lessons for their projects. No prior programming knowledge is needed.
本 Excel 课程适用于任何想要在 Excel VBA 中学习自动化秘密的人。它适用于寻找复习或参考工具的完全新手和/或学生，为他们的项目挑选相关课程。无需事先具备编程知识。 - This course is probably not for you if you’re looking to learn super advanced report authoring, which will be covered in a future course specifically on this topic. We will, however, make sure you know how to make good solid reports from your data and many tricks to make them look good.
如果您想学习超高级报表创作，本课程可能不适合您，这将在将来专门针对此主题的课程中介绍。但是，我们将确保您知道如何从您的数据中制作出可靠的报告，以及许多使它们看起来不错的技巧。 - Beginning to Advanced Excel users who are ready to Automate their projects and use extremely customizable macros, build their own UserForms and learn the fundamentals of programming in a safe, easy, progressive way
初级到高级 Excel 用户，他们准备自动化他们的项目并使用高度可定制的宏，构建自己的用户窗体，并以安全、简单、渐进的方式学习编程的基础知识
