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

Excel 2010 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 2/2018
English

What you'll learn

  • Understand Macro Development Basics
  • Understand VBA Programming Fundamentals
  • Work with Control Structures
  • Use VBA Functions
  • Create User Forms
  • Learn Debugging Techniques
  • Use Advanced Functions
  • Use Conditional Formatting and Sparklines
  • Create PivotTalbes and PivotCharts
  • Analyze Data

Course content

2 sections • 58 lectures • 8h 34m total length

  • Introduction2:28

    Explore the Excel object model, the VBA editor, variables, subroutines, functions, arguments, constants, control structures, user forms, and debugging to build robust Excel 2010 VBA macros.

  • Displaying the Developer Tab9:02
  • Setting Macro Trust within Excel 20103:50
  • Recording and Running a Macro7:41
  • Examining the VBA Editor Part 118:37

    Explore the VBA editor basics by navigating the macros dialog, understanding project and properties windows, and using debugging tools like compile, breakpoints, and watches to master Excel automation.

  • Examining the VBA Editor Part 219:32
  • Reviewing the Excel 2010 Object Model8:56

    Explore the Excel 2010 object model, VBA fundamentals, and the difference between functions and procedures, with practical module creation and prefix organization.

  • Understanding Functions and Procedures10:49

    Learn to declare variables with option explicit, create public or private subroutines, and distinguish subroutines from functions while testing with the immediate window and debugging with a breakpoint.

  • Understanding Variables and Scope Part 117:49

    Learn how to declare variables in VBA with dim, choose types (string, integer, double, boolean), set object variables for a worksheet and a range, and understand defaults, errors, and commenting.

  • Understanding Variables and Scope Part 217:27

    Understand VBA scope, from local variables to module-level private and public declarations, and how the immediate window helps inspect or change values across subs and functions.

  • Commenting Your Code3:18
  • Creating Constants5:48
  • Understanding Arguments9:04
  • Using If-Then-Else8:00
  • Understanding Logical Operators5:33
  • Creating a Select-Case Statement12:10
  • Creating For-Next Loops11:40
  • Creating Do Loops4:50
  • Creating While-Wend Loops9:29
  • Viewing the Object Browser9:28
  • Using the InputBox Function8:22
  • Understanding the MsgBox Function10:02
  • Using String Functions15:46
  • Using Date Functions13:03
  • Designing a Form1:45

    Design a user form in Excel VBA to create an interactive interface with controls like dropdowns, text boxes, and images, and explore form properties and events.

  • Understanding Different Controls7:58
  • Working with Form Properties Part 115:02
  • Working with Form Properties Part 215:40
  • Understanding the Difference Between Syntax and Logic Errors12:17
  • Using Breakpoints5:43
  • Stepping Through Your Macro2:53

    Step through your macro with f8 to advance lines, monitor the active cell and i loop, and use the watch window to track expressions during debugging.

  • Creating Watches4:27
  • Adding Error Traps15:31
  • Course Recap3:48

    Explore the Excel object model - application, workbook, worksheets, and range - along with the VBA editor, core concepts like variables, constants, procedures, functions, control structures, and debugging, plus user forms and auto filter.

Requirements

  • Intermediate to advanced Excel knowledge required.

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.

Who this course is for:

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

Report abuse