Excel 2010 VBA and Advanced (2-Course Bundle)

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

Course Description

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

  • Excel 2010 VBA
  • Excel 2010 Advanced

In the Excel 2010 VBA course, the overall focus is to teach the user proper Visual Basic programming techniques along with an understanding of Excel’s object structure. Other topics in this course include: proper variable declaration, 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 2010 Advanced course delves into a variety of topics beyond the basics. You will learn how to use a wide range of financial, logical, text, and statistical functions; analyze data with the scenario manager; apply conditional formatting; and use the new Sparklines feature. Database management, PivotTables, PivotCharts, and Slicers are covered in detail, as well as importing and exporting Excel data to and from other applications.

Expected Outcomes

  1. Understand Macro Development Basics
  2. Understand VBA Programming Fundamentals
  3. Work with Control Structures
  4. Use VBA Functions
  5. Create User Forms
  6. Learn Debugging Techniques
  7. Use Advanced Functions
  8. Use Conditional Formatting and Sparklines
  9. Create PivotTalbes and PivotCharts
  10. Analyze Data