Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel 2007 VBA and Advanced (2-Course Bundle)
Rating: 4.7 out of 5(15 ratings)
81 students

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.
Created byIntellezy Trainers
Last updated 3/2017
English

What you'll 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

Course content

2 sections • 84 lectures • 7h 26m total length

  • Introduction2:43
  • Understanding Objects1:50
  • Referencing Workbooks, Worksheets, and Cells3:07
  • Displaying the Developer Tab2:10
  • Setting Macro Trust within Excel1:58

    Configure macro trust in Excel via the trust center to enable VBA content, and manage macro settings, including disabling all macros with notification or allowing digitally signed macros.

  • Recording a Macro6:40
  • Running a Macro0:40
  • Editing a Macro with the Visual Basic Editor3:03
  • Examining the VBA Editor Menu and Toolbar9:43
  • Setting VBA Editor Options8:52
  • Reviewing the Project Explorer1:14

    the project explorer shows everything within this workbook, including all sheets. i place code under modules, like module 1 for macros, to avoid losing code if a sheet is deleted.

  • Reviewing the Properties Window3:04

    Navigate the properties window to edit properties of the selected object in the VBA editor, renaming modules and sheets, toggling visibility, and controlling workbook elements directly.

  • Understanding the Object and Procedure Drop-Down Lists1:16
  • Viewing the Immediate Window2:36
  • Viewing the Object Browser5:36
  • Understanding Functions and Procedures5:53

    Explore the difference between a procedure (subroutine) and a function in VBA, and learn how public and private access control shapes macro design in Excel.

  • Dimensioning Variables12:27
  • Understanding Object Variables5:10
  • Understanding Variables and Scope5:44
  • Commenting Your Code4:53
  • Creating Constants4:28
  • Manipulating Data6:33
  • Understanding Procedure Arguments9:42
  • Using the InputBox() Function11:22
  • Understanding the MsgBox() Function10:02

    Explore how to use the MsgBox function in VBA as both a procedure and a function, selecting buttons, icons, default options, and returning values for debugging and decision making.

  • Using String Functions12:07
  • Using Date Functions11:08

    Use Excel VBA date functions to obtain current date, month, year, and weekday with a configurable week start; validate input with input box and CDate.

  • Using If/Then/Else6:41
  • Creating a Select/Case Statement5:02
  • Creating For/Next Loops6:58
  • Creating Do Loops6:20
  • Creating While/Wend Loops5:00
  • Understanding UserForms1:09
  • Understanding Controls11:28
  • Setting Control Properties1:06

    Set control properties, methods, and events using the property window to customize forms and palettes. Apply changes on form load by adjusting background colors and propagating tweaks across controls.

  • Referencing Controls in VBA Code2:44
  • Responding to Events11:16
  • Creating a Function to Open a UserForm2:19
  • Understanding Logic Errors and Syntax Errors4:22
  • Running Your Macro from the VBA Editor1:01
  • Setting Breakpoints1:35
  • Stepping Through Your Macro3:44
  • Creating Watches6:58

    Create watches to debug VBA loops by watching variables in the watch window and immediate window, using breakpoints and break conditions to stop when a value meets a condition.

  • Adding Error Trapping11:24
  • Course Recap3:25

    Apply takeaways from Excel VBA basics: manage application, workbook, worksheet, and range objects; use active sheets and cells; write and debug powerful macros with the VBA editor.

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 this course is for:

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

Report abuse