The Ultimate Excel VBA Course(Wall Street Prep) 内容介绍

内容介绍

Start writing VBA code that you can immediately use on the job. No programming experience needed!
学好VBA 咨询投行进入横着走
表情

Most Microsoft Office users only know how to set up a basic table or maybe do a few formulas here and there. This course will 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 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, and we’ll show you how.

大多数微软Office用户只知道如何建立一个基本的表格,或者在这里和那里做一些公式。本课程将教你如何通过Excel的角,使它做任何你想要的,随时随地。它可以处理大量的信息,并为你创建一个可打印的报告。你可以制作自定义表格,这样你就可以快速访问、分析、编辑或添加新的信息到你的数据表/工作表中。Excel编程利用了一种简单而有效的工具 “VBA”–一种隐藏的编程语言,它在你工作时悄悄地在后台运行。它的使用非常简单和直接,我们将向您展示如何使用。

学习目的

-For finance professionals, speed in Excel is not only a requirement, it’s a big part of how you’re measured against your peers.
-This comprehensive course is designed to teach students and professionals how to save a ton of time in Excel with the easy-to-use VBA programming language.
-We’ll introduce you VBA environment and dive into real-world exercises that will teach you how to write your own macros, functions and subroutines and how to breeze through large data sets with ease!

-对于金融专业人士来说,Excel的速度不仅是一个要求,它是如何衡量你与同行相比的一个重要部分。
-本综合课程旨在教学生和专业人士如何使用易于使用的VBA编程语言来节省大量的时间。
-我们将向你介绍VBA环境,并深入到现实世界的练习中,教你如何编写你自己的宏、函数和子程序,以及如何轻松地处理大型数据集。

能学到什么

-Perfect for both Excel newbies and experts interested in VBA.
-Absolutely no programming experience is needed.
-Full of VBA techniques used by finance professionals.
-Come away with practical code you can use in your own spreadsheets.
-Complete real-world Macro/VBA projects from start to finish.
-Understand VBA enough to alter code you find online to fit your purpose.
-A great learning and reference tool: 150+ individual VBA lessons!
-The same course our corporate clients use to prepare their analysts and associates.

-非常适合Excel新手和对VBA感兴趣的专家。
-完全不需要编程经验。
-充满了金融专业人士使用的VBA技术。
-掌握实用的代码,你可以在自己的电子表格中使用。
-从头到尾完成真实世界的Macro/VBA项目。
-对VBA的理解足以改变你在网上找到的代码以适应你的目的。
-一个伟大的学习和参考工具。150+个人VBA课程! -与我们的企业客户使用的课程相同。
-我们的企业客户使用相同的课程来准备他们的分析师和同事。

课程目录

Chapter 1: The Range Object
Get the Developer Tab and Intro to Developer Tab 1:29
Getting Started With Range Object 1:19
Quick Tip – Project Explorer and Properties Window! 1:12
Creating Your First Macro From Scratch 2:29
Adding a Secondary Command 0:51
Debugging in Excel VBA 1:22
Saving a Macro-Enabled Workbook (.xlsm) 1:11
Before You Begin The Exercises 3:06
Exercise 01 3:53
10 Several Ways to Trigger Your Macro 1:22
11 Affecting Multiple Cells with One Range Command – 2 Methods 1:35
12 Adding Strings of Text to a Cell 1:40
13 Using a Named Range with the Range Object 1:37
Chapter 2: Range Properties
14 VALUE Property 1:54
15 TEXT Property 0:59
16 ROW and COLUMN Properties 1:07
17 SELECT Property 0:55
18 COUNT Property 1:47
19 Exercise 02a 4:32
20 ADDRESS Property 1:48
21 FORMULA Property 3:47
22 NUMBERFORMAT Property 2:27
23 FONT, BOLD, UNDERLINE or ITALIC Properties 2:43
24 Exercise 02b 6:36
Chapter 3: The Cells Object
25 The Cells Object 2:24
26 Using Column Letters Instead of Numbers 0:55
27 Using Cells Positionally Within a Range 2:10
28 Affecting ALL Cells in a Worksheet 2:05
29 Exercise 03 4:12
30 Using Range Object with Cells Object 3:01
Chapter 4: Variables
31 Intro to Variables 2:24
32 Declaring Variables – Variable Types 2:37
33 Declaring Variables – Types Demo 4:24
34 Concatenation – Joining Two Or More Strings! 2:26
35 BONUS – Date Math Fun! 3:41
36 Exercise 04 4:16
37 Calling a Procedure from Another 1:57
38 Public and Private Variables 3:06
39 Using Constants 2:02
40 BONUS – Passing Variables to Another Procedure – ByVal and ByRef 7:05
Chapter 5: Toolbars and Menus
41 File Menu Walkthrough 1:52
42 Edit Menu Walkthrough 5:08
43 View Menu Walkthrough 2:12
44 View Menu – Watch Window, Local Window and Immediate WIndow 7:43
45 Watch Window Wonders! 3:25
46 Insert and Format Menus 0:40
47 Debug Menu 5:12
48 Run and Tools Menus 2:13
Chapter 6: Important Tools and Excel Logic
49 Determining the Last Row in your Data Set 3:17
50 Determining the Last Column in your Data Set 2:22
51 Determining the Next Row in your Data Set 1:06
52 Recording a Macro 3:39
53 BONUS – Dynamic Sorting 5:55
54 Absolute vs. Relative References 4:07
55 Using With and End WIth 3:32
56 Comparison Operators in Excel VBA 1:01
57 If Then Statement 2:25
58 Using Is Not Equal To () 0:41
59 Logical Operator, NOT 0:56
60 Exercise 06a 4:42
61 If, Then, Else Statement 1:22
62 If, Then, ElseIF Statement 2:02
63 Comparative Operators with Text and Numbers 2:35
64 Using If Then Statements in a One-Liner of Code 1:42
65 Using GOTO and Labels 1:52
66 Select Case as Alternative to IF THEN Statements 2:21
67 Message Box with Yes and No Buttons 6:26
68 Exercise 06b 6:33
69 Relative Positioning Using Offset 4:13
70 BONUS – User Defined Functions 101 4:49
71 BONUS – UDF Lesson 2 4:08
Chapter 7: Loops and Report Writing Basics
72 Intro to Loops; the For Next Loop 3:07
73 Fun with out For Next Loop 3:46
74 Beginning out First Report Using Loops 5:46
75 Using an InputBox 2:53
76 Adding InputBox to Our First Report to Make It Dynamic 3:12
77 Add a Button to Open Our Report 2:23
78 Add a Cool Button or Image to Open Report 2:19
79 Our First Printable Report, Part 1 5:00
80 Printable Report, Part 2 6:41
81 Printable Report, Part 3 3:19
82 Printable Report, Part 4 3:34
83 Exercise 07a 11:18
84 Using PrintPreview Automatically 0:50
85 Using PrintOut to Send Directly to Default Printer 1:59
86 Handling Debug Error When Cancelling InputBox 2:18
87 For Loop Going Backwards Using STEP 2:49
88 The FOR EACH Loop 5:17
89 FOR EACH Loop – Practice Examples 3:30
90 Exercise 07b 7:33
91 Intro to DO LOOPS 3:26
92 DO Until 1:53
93 Loop Until 1:31
94 DO While 1:43
95 Loop While 0:58
96 EXIT DO – Multiple Exits Using Your Own Criteria Along the Way! 1:48
97 BONUS – Loop Through Multiple Files in a Folder and Scrape Data From Each 12:09
Chapter 8: Events, Worksheet Events Made Easy
98 Intro to Worksheet Events and Selection Change 4:03
99 Worksheet Activate Event 1:13
100 Worksheet Deactivate Event 2:28
101 BeforeDelete Event – For Worksheet Deletion 1:05
102 BeforeDoubleClick Event – Trigger a Macro When Double Clicking 2:59
103 BeforeRightClick Event – Trigger a Macro When Right-Clicking 1:42
104 Calculate Event 2:33
Worksheet Events Made Easy
105 Exercise 08a 2:09
Chapter 8: Events, Worksheet Events Made Easy
106 How to Disable Events on the Workbook 1:32
107 Intro to Change Event 1:14
108 Change Event with EnableEvents Toggle – Avoid Endless Loop! 4:51
109 Change Event Triggered With Custom Range Using Intersect 3:19
110 FollowHyperlinks Event 2:41
111 Final Thoughts on Worksheet Events and Review Other Events 2:25
Worksheet Events Made Easy
112 Exercise 08b 5:42
Chapter 9: Workbook Events
113 Workbook Open 5:13
114 Workbook Activate 1:53
115 Before Save 2:25
116 After Save 2:13
117 Before Close 3:32
118 Before Print 1:21
119 Deactivate 1:06
120 NewChart 3:13
121 NewSheet 1:51
122 Exercise 09 4:36
123 Sheet Activate 2:19
124 Delete, DoubleClick, RightClick, Calculate, Change 4:51
125 SheetDeactivate 2:49
126 Follow Hyperlink 0:44
127 SheetSelectionChange 0:42
128 WindowActivate 1:09
129 WindowDeactivate 0:25
130 WindowResize 2:03
Chapter 10: Activex Controls of Worksheets
131 Activex Controls vs. Forms Controls 3:36
132 Button Click – Wage Calculator 4:10
133 Keydown Event 4:18
134 BONUS: Capturing Shift, Alt, Ctrl or Some Combination Using the Shift Variable 3:19
135 KeyPress Event 2:53
136 MouseMove Event 2:08
137 MouseMove Event with Application Statusbar 3:44
138 MouseUp and MouseDown Events – Left, Middle, & Rightclick, Shift, Alt & Ctrl 6:27
139 GotFocus and LostFocus Events 1:09
140 Use a Checkbox for its VALUE 2:41
141 Checkbox Event Without a Button 1:58
142 LinkedCell Property With a Checkbox 1:59
143 Option Buttons Intro – What is an Option Button and Grouping 3:08
144 Grouping, Alignment and Aesthetics for Control 2:45
145 Homemade Quiz Using Option Buttons and a Command Button 4:37
146 Compliance Checker for Your Forms or Quizzes, Part 1 3:36
147 Compliance Check, Part 2 9:49
148 SpinButton With Cell A1 4:21
149 SpinButtons With Textboxes and Numbers 6:04
150 SpinButton BONUS – Move Textbox Position with SpinButton 3:55
151 SpinButton With Dates in a Textbox 3:31
152 Activex “Label” Control – Basics 3:50
153 ComboBox – Fill With ListFillRange 3:33
154 Creating a Dynamic Range 4:47
155 ComboBox – How To Use Multiple Columns 3:09
156 Using ADDITEM to Get Specific Items in Your ComboBox List 9:25
157 Noteworthy Properties of a ComboBox 5:37
158 Multiple Columns in ComboBox With ADDITEM and List, ListCount, etc. 7:16
159 ListBox Basics Using Dynamic Range 7:47
160 ListBox Click Event and Dynamic Options 3:26
161 BONUS – Manipulating and Using Multiselect Items in a Listbox 6:04
162 ListBox – Referencing Column 0 and 1 in a Cell Dynamically 3:32
163 Dynamic ListBoxes Using ADDITEM and More 9:36
164 Make and Utilize INVISIBLE Columns – Special Trick! 3:35
165 Using Scroll Bar on a Worksheet 3:29
166 Pictures on a Worksheet, Plus Using FollowHyperlink Method 5:52
167 Toggle Button 2:24
168 A Brief Note on Alternate, 3rd Party Controls 1:33
Chapter 11: Userforms – The Best Thing Ever!
169 Userform – Hide, Show and Unload 3:19
170 Simple Database and Creating a Data Entry Form 3:55
171 Fill Status ComboBox With Rowsource When Userform Starts – 2 Methods 4:03
172 New Employee Data Entry Form 9:04
173 Format Textbox Numbers as Numerals, Clearing Out Form Upon Submission 3:13
174 Set the Tab Order for Userform Controls 2:10
175 Set Default Values to Make Data Entry Easier 2:18
176 Avoid Duplicate Employee ID and Other Fun Automation Tricks 5:37
177 Edit Mode for Employee Database, Part 1 11:26
178 Edit Mode for Employee Database, Part 2 7:49
179 Edit Mode, Part 3 – Adding Automation and Save Button 15:56
180 BONUS – Refreshing the Rowsource After Updating Data 3:55
181 BONUS – Combobox by Last Name Instead of EmpID 9:41
182 BONUS – Search Name and ID 15:49
183 Userform Report with Filters, Part 1 11:09
184 Userform Report with Filters, Part 2 6:03
185 Applying the Dynamic Filters to Reports 3:10
186 Clear Out Last Report 3:06
187 Report Generation and Aesthetics, Headers, Footers, Footers, Repeat Rows, etc. 6:05
188 Advanced Exercise – Review of Objectives 8:04
189 Advanced Exercise 01 – Solution 7:57
190 Advanced Exercise 02 – Solution 4:10
191 Advanced Exercise 03 and 04 – Solutions 7:44
192 Advanced Exercise BONUS A and B – Solutions 3:41
193 Advanced Exercise BONUS C Automate the Workflow for Efficiency – Solutions 3:21
Chapter 12: BONUS VBA Functions
194 InStr Function – Search for Text Within Other Text 7:18
195 The EVALUATE Function – Mac-Daddy of all functions 5:59
196 Sum Function in Excel VBA – EASY! 3:14
197 Count Function in VBA 2:13

购买

自助开通

课程原链接

www.wallstreetprep.com/self-study-programs/the-ultimate-excel-vba-course/

本页面内容
(福贝壳儿 www.forbanker.com/)
引用自原网页

希望看到这里的童鞋们:事事如意,(面试)试试如意!
本站购买的内容均包含更新
福贝壳儿 » The Ultimate Excel VBA Course(Wall Street Prep) 内容介绍