Excel 2010 VBA and Advanced (2-Course Bundle)
4.2 (12 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
41 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2010 VBA and Advanced (2-Course Bundle) to your Wishlist.

Add to Wishlist

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.
4.2 (12 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
41 students enrolled
Last updated 3/2017
English
Curiosity Sale
Current price: $10 Original price: $55 Discount: 82% off
30-Day Money-Back Guarantee
Includes:
  • 8.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • Students wishing to learn Visual Basic programming techniques and advanced Excel features.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
58 Lectures
08:26:14
+
Excel 2010 VBA
34 Lectures 05:19:57

Displaying the Developer Tab
09:02

Setting Macro Trust within Excel 2010
03:50

Recording and Running a Macro
07:41

Examining the VBA Editor Part 1
18:37

Examining the VBA Editor Part 2
19:32

Reviewing the Excel 2010 Object Model
08:56

Understanding Functions and Procedures
10:49

Understanding Variables and Scope Part 1
17:49

Understanding Variables and Scope Part 2
17:27

Commenting Your Code
03:18

Creating Constants
05:48

Understanding Arguments
09:04


Understanding Logical Operators
05:33

Creating a Select-Case Statement
12:10

Creating For-Next Loops
11:40

Creating Do Loops
04:50


Viewing the Object Browser
09:28

Using the InputBox Function
08:22

Understanding the MsgBox Function
10:02

Using String Functions
15:46

Using Date Functions
13:03

Designing a Form
01:45

Understanding Different Controls
07:58

Working with Form Properties Part 1
15:40

Working with Form Properties Part 2
15:40

Understanding the Difference Between Syntax and Logic Errors
03:48

Using Breakpoints
05:43

Stepping Through Your Macro
02:53

Creating Watches
04:27

Adding Error Traps
15:31

Course Recap
03:48
+
Excel 2010 Advanced
24 Lectures 03:06:17

Help with Functions
04:11

Logical Functions
18:42

Financial Functions
09:37

Text Functions
15:43

Lookup Functions
08:36

Applying Conditional Formats
06:38

Managing Conditional Formats
05:05

Creating Sparklines
04:33

Modifying Sparkline Styles
05:06


Working with Tables
04:26

Sorting a List
05:06

Filtering Data
08:46

Creating a PivotTable
09:56

Filtering and Sorting
16:40

Filtering with Slicers
06:07


Auditing and Error Checking
09:26

Using the Scenario Manager and Goal Seek
11:39

Transferring Between Word and Excel
10:42

Importing a Text File
04:08

Transferring Between Access and Excel
04:17

Course Recap
01:54
About the Instructor
Intellezy Trainers
4.4 Average rating
4,582 Reviews
26,779 Students
137 Courses
Computer Training Specialists

At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.