Excel 2007 VBA and Advanced (2-Course Bundle)

Excel 2007 VBA and Advanced (2-Course Bundle), available at $19.99, has an average rating of 4.65, with 84 lectures, based on 14 reviews, and has 77 subscribers.

You will learn about 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 This course is ideal for individuals who are Students wishing to learn Visual Basic programming techniques and advanced Excel features. It is particularly useful for Students wishing to learn Visual Basic programming techniques and advanced Excel features.

Enroll now: Excel 2007 VBA and Advanced (2-Course Bundle)

Summary

Title: Excel 2007 VBA and Advanced (2-Course Bundle)

Price: $19.99

Average Rating: 4.65

Number of Lectures: 84

Number of Published Lectures: 84

Number of Curriculum Items: 84

Number of Published Curriculum Objects: 84

Original Price: $59.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Students wishing to learn Visual Basic programming techniques and advanced Excel features.

Target Audiences

Students wishing to learn Visual Basic programming techniques and advanced Excel features.

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.

Course Curriculum

Chapter 1: Excel 2007 VBA

Lecture 1: Introduction

Lecture 2: Understanding Objects

Lecture 3: Referencing Workbooks, Worksheets, and Cells

Lecture 4: Displaying the Developer Tab

Lecture 5: Setting Macro Trust within Excel

Lecture 6: Recording a Macro

Lecture 7: Running a Macro

Lecture 8: Editing a Macro with the Visual Basic Editor

Lecture 9: Examining the VBA Editor Menu and Toolbar

Lecture 10: Setting VBA Editor Options

Lecture 11: Reviewing the Project Explorer

Lecture 12: Reviewing the Properties Window

Lecture 13: Understanding the Object and Procedure Drop-Down Lists

Lecture 14: Viewing the Immediate Window

Lecture 15: Viewing the Object Browser

Lecture 16: Understanding Functions and Procedures

Lecture 17: Dimensioning Variables

Lecture 18: Understanding Object Variables

Lecture 19: Understanding Variables and Scope

Lecture 20: Commenting Your Code

Lecture 21: Creating Constants

Lecture 22: Manipulating Data

Lecture 23: Understanding Procedure Arguments

Lecture 24: Using the InputBox() Function

Lecture 25: Understanding the MsgBox() Function

Lecture 26: Using String Functions

Lecture 27: Using Date Functions

Lecture 28: Using If/Then/Else

Lecture 29: Creating a Select/Case Statement

Lecture 30: Creating For/Next Loops

Lecture 31: Creating Do Loops

Lecture 32: Creating While/Wend Loops

Lecture 33: Understanding UserForms

Lecture 34: Understanding Controls

Lecture 35: Setting Control Properties

Lecture 36: Referencing Controls in VBA Code

Lecture 37: Responding to Events

Lecture 38: Creating a Function to Open a UserForm

Lecture 39: Understanding Logic Errors and Syntax Errors

Lecture 40: Running Your Macro from the VBA Editor

Lecture 41: Setting Breakpoints

Lecture 42: Stepping Through Your Macro

Lecture 43: Creating Watches

Lecture 44: Adding Error Trapping

Lecture 45: Course Recap

Chapter 2: Excel 2007 Advanced

Lecture 1: Introduction

Lecture 2: Financial Functions

Lecture 3: Logical Functions

Lecture 4: Text Functions

Lecture 5: Statistical and Math Functions

Lecture 6: Lookup Functions

Lecture 7: Displaying Formulas

Lecture 8: Tracing Cell Precedents and Dependents

Lecture 9: Using the Formula Evaluator

Lecture 10: Error Checking

Lecture 11: Using Subtotals

Lecture 12: Using Goal Seek

Lecture 13: Using the Scenario Manager

Lecture 14: Understanding Custom Formats

Lecture 15: Applying a Custom Format

Lecture 16: Using Conditional Formatting

Lecture 17: Adding Data Bars, Color Scales, and Icon Sets

Lecture 18: Managing Formatting Rules

Lecture 19: Planning a Database and Understanding Database Terms

Lecture 20: Understanding Logical Operators

Lecture 21: Formatting and Sorting Tables

Lecture 22: Filtering a Table

Lecture 23: Using an Advanced Filter

Lecture 24: Creating a Simple PivotTable

Lecture 25: Using the PivotTable Field List Pane

Lecture 26: Working with PivotTable Options

Lecture 27: Sorting in a PivotTable

Lecture 28: Formatting a PivotTable

Lecture 29: Creating a PivotChart

Lecture 30: Formatting a PivotChart

Lecture 31: Development Tips

Lecture 32: Importing from Access

Lecture 33: Importing a Text File

Lecture 34: Managing Updates

Lecture 35: Exporting Data

Lecture 36: Recording a Macro

Lecture 37: Running a Macro

Lecture 38: Running a Macro from a Custom Button

Lecture 39: Course Recap

Instructors

Intellezy Trainers
Multi-Award-Winning eLearning Specialists

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 6 votes
5 stars: 8 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu