Excel 2007 VBA and Advanced (2-Course Bundle)

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy

Course 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.

Expected Outcomes

  1. Understand Macro Development Basics
  2. Understand VBA Programming Fundamentals
  3. Use VBA Functions
  4. Create User Forms
  5. Use Advanced Functions
  6. Working with PivotTables
  7. Using Advanced Formatting in Excel
  8. Importing and Exporting Data