Introduction to Excel VBA

Course Description

Excel VBA is a powerful (and fun!) tool which allows you to automate your Excel workbooks. These videos will help you through your first steps on the way to becoming a programmer in Excel. You don't need any prior programming knowledge as we'll take things from first principles and hopefully give you a flavour of the cool things you can do with a little bit of effort!

Introduction to Excel VBA
Not yet rated

Video Lectures & Study Materials

Visit the official course website for more study materials: http://www.wiseowl.co.uk/courses/microsoft-excel-macros.htm

# Lecture Play Lecture
1 Getting Started in the VB Editor Play Video
2 Writing Your First VBA Macro Play Video
3 What to do When Things Go Wrong (Errors and Debugging) Play Video
4 Buttons, Toolbars and Keyboard Shortcuts Play Video
5 Selecting Cells (Range, Cells, Activecell, End, Offset) Play Video
6 Worksheets, Charts and Sheets Play Video
7 Workbooks Play Video
8 Variables Play Video
9 Object Variables Play Video
10 Message Boxes Play Video
11 Input Boxes Play Video
12 Application.InputBox Play Video
13 With Statements Play Video
14 If Statements Play Video
15 Select Case Statements Play Video
16 Do Until and Do While Loops Play Video
17 Find and FindNext Play Video
18 For Next Loops Play Video
19 For Each Loops Play Video
20 Creating Functions Play Video
21 Error Handling (On Error, Resume, GoTo) Play Video
22 Event Procedures Play Video
23 Application Events Play Video
24 User Forms Play Video
25 Files and Folders (FileSystemObjects) Play Video
26 Text Files (FileSystemObjects) Play Video
27 File Dialogs Play Video
28 Arrays Play Video
29 Constants and Enumerations (Const, Enum) Play Video
30 Creating Word Documents Play Video
31 Creating and Updating Linked Word Tables Play Video
32 Creating PowerPoint Presentations Play Video
33 Creating Outlook Emails Play Video
34 ADO (ActiveX Data Objects) Querying a Database Play Video
35 ADO (ActiveX Data Objects) Modifying Data with Recordsets Play Video
36 ADO (ActiveX Data Objects) SQL Statements (INSERT, UPDATE, DELETE) Play Video
37 Creating Add Ins Play Video
38 Type Declarations (UserDefined Types) Play Video
39 Class Modules Play Video
40 Using Class Modules in Other Projects Play Video
41 Custom Collections Play Video
42 Typed Collections Play Video
43 Dictionaries Play Video
44 Disabling Screen Updates Play Video
45 Saving as a PDF Play Video
46 Data Labels in Scatter Charts Play Video
47 ByRef and ByVal Play Video
48 ByRef and ByVal (When to use Parentheses) Play Video
49 Making Excel Talk Play Video
50 Finding the Last Used Row, Column and Cell Play Video
51 Querying Web Pages using Query Tables Play Video
52 Browsing to Websites and Scraping a Web Page Play Video
53 Web Scraping Across Multiple Pages Play Video
54 Downloading Files from Websites Play Video
55 Introduction to Charts in VBA Play Video
56 Embedding Charts in Worksheets Play Video
57 Introduction to Pivot Tables in VBA Play Video
58 Pivot Tables using an Access Database Play Video
59 Pivot Tables using a SQL Server Database Play Video
60 Pivot Tables and Consolidation Ranges Play Video
61 PowerPivot Data Models Play Video
62 Pivot Charts Play Video
63 Pivot Table Slicers Play Video
64 Pivot Table Date Fields and Timelines Play Video
65 Introduction to Shapes Play Video
66 Formatting Shapes Play Video
67 Adding Text to Shapes Play Video
68 Working with Strings Play Video
69 Splitting Strings Play Video
70 The Join Function and Concatenating Strings Play Video
71 Replacing Strings Play Video
72 Converting the Case of Text Play Video
73 The Asc and Chr Functions Play Video
74 The IIf Function Play Video
75 The Switch Function Play Video
76 Working with Dates Play Video

Comments

There are no comments. Be the first to post one.
  Post comment as a guest user.
Click to login or register:
Your name:
Your email:
(will not appear)
Your comment:
(max. 1000 characters)
Are you human? (Sorry)
 
Disclaimer:
CosmoLearning is promoting these materials solely for nonprofit educational purposes, and to recognize contributions made by WiseOwl Training (WiseOwl) to online education. We do not host or upload any copyrighted materials, including videos hosted on video websites like YouTube*, unless with explicit permission from the author(s). All intellectual property rights are reserved to WiseOwl and involved parties. CosmoLearning is not endorsed by WiseOwl, and we are not affiliated with them, unless otherwise specified. Any questions, claims or concerns regarding this content should be directed to their creator(s).

*If any embedded videos constitute copyright infringement, we strictly recommend contacting the website hosts directly to have such videos taken down. In such an event, these videos will no longer be playable on CosmoLearning or other websites.