Excel 2007 VBA and Advanced (2-Course Bundle)
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
8 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2007 VBA and Advanced (2-Course Bundle) to your Wishlist.

Add to Wishlist

Excel 2007 VBA and Advanced (2-Course Bundle)

Learn the Visual Basic programming language and take your Excel skills to the next level in this 2-course bundle.
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
8 students enrolled
Last updated 3/2017
English
Curiosity Sale
Current price: $10 Original price: $55 Discount: 82% off
30-Day Money-Back Guarantee
Includes:
  • 7.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand Macro Development Basics
  • Understand VBA Programming Fundamentals
  • Use VBA Functions
  • Create User Forms
  • Use Advanced Functions
  • Working with PivotTables
  • Using Advanced Formatting in Excel
  • Importing and Exporting Data
View Curriculum
Requirements
  • Intermediate to advanced Excel knowledge required.
Description

Save 20% by buying both courses. This bundle includes:

  • Excel 2007 VBA 
  • Excel 2007 Advanced

The Excel 2007 VBA course introduces you to Excel Macro programming using Microsoft's Visual Basic for Applications (VBA). The overall focus of this course is to teach you proper Visual Basic programming techniques along with an understanding of Excel's object structure. Other topics in this course include recording macros, programming basics, proper variable declaration, Visual Basic functions, control structure use, looping, and UserForm creation. The final section deals with the debugging tools included in the Microsoft VBA editor and methods on how to effectively use them.

The Excel 2007 Advanced course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you learn how to analyze and manage your data. You will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager, and subtotals. Additionally, during this course, you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and PivotCharts, and record basic Macros.

Who is the target audience?
  • Students wishing to learn Visual Basic programming techniques and advanced Excel features.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
84 Lectures
07:26:43
+
Excel 2007 VBA
45 Lectures 04:06:33

Understanding Objects
01:50

Referencing Workbooks, Worksheets, and Cells
03:07

Displaying the Developer Tab
02:10

Setting Macro Trust within Excel
01:58

Recording a Macro
06:40

Running a Macro
00:40

Editing a Macro with the Visual Basic Editor
03:03

Examining the VBA Editor Menu and Toolbar
09:43

Setting VBA Editor Options
08:52

Reviewing the Project Explorer
01:14

Reviewing the Properties Window
03:04

Understanding the Object and Procedure Drop-Down Lists
01:16

Viewing the Immediate Window
02:36

Viewing the Object Browser
05:36

Understanding Functions and Procedures
05:53

Dimensioning Variables
12:27

Understanding Object Variables
05:10

Understanding Variables and Scope
05:44

Commenting Your Code
04:53

Creating Constants
04:28

Manipulating Data
06:33

Understanding Procedure Arguments
09:42

Using the InputBox() Function
11:22

Understanding the MsgBox() Function
10:02

Using String Functions
12:07

Using Date Functions
11:08

Using If/Then/Else
06:41

Creating a Select/Case Statement
05:02

Creating For/Next Loops
06:58

Creating Do Loops
06:20

Creating While/Wend Loops
05:00

Understanding UserForms
01:09

Understanding Controls
11:28

Setting Control Properties
01:06

Referencing Controls in VBA Code
02:44

Responding to Events
11:16

Creating a Function to Open a UserForm
02:19

Understanding Logic Errors and Syntax Errors
04:22

Running Your Macro from the VBA Editor
01:01

Setting Breakpoints
01:35

Stepping Through Your Macro
03:44

Creating Watches
06:58

Adding Error Trapping
11:24

Course Recap
03:25
+
Excel 2007 Advanced
39 Lectures 03:20:10

Financial Functions
07:44

Logical Functions
16:04

Text Functions
14:57

Statistical and Math Functions
05:26

Lookup Functions
10:14

Displaying Formulas
01:21

Tracing Cell Precedents and Dependents
01:23

Using the Formula Evaluator
04:05


Using Subtotals
04:11

Using Goal Seek
03:15

Using the Scenario Manager
08:00

Understanding Custom Formats
09:21

Applying a Custom Format
03:44

Using Conditional Formatting
02:58

Adding Data Bars, Color Scales, and Icon Sets
04:36

Managing Formatting Rules
05:14

Planning a Database and Understanding Database Terms
10:41


Formatting and Sorting Tables
01:48

Filtering a Table
10:03

Using an Advanced Filter
07:52

Creating a Simple PivotTable
01:56

Using the PivotTable Field List Pane
05:30

Working with PivotTable Options
05:44

Sorting in a PivotTable
06:03

Formatting a PivotTable
02:37


Formatting a PivotChart
02:14


Importing from Access
07:06

Importing a Text File
07:16

Managing Updates
01:44

Exporting Data
02:58

Recording a Macro
02:43

Running a Macro
01:31

Running a Macro from a Custom Button
02:34

Course Recap
01:21
About the Instructor
Intellezy Trainers
4.4 Average rating
4,597 Reviews
26,837 Students
137 Courses
Computer Training Specialists

At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.