Excel 2010 VBA and Advanced (2-Course Bundle)

Excel 2010 VBA and Advanced (2-Course Bundle), available at $19.99, has an average rating of 4.4, with 58 lectures, based on 59 reviews, and has 205 subscribers.

You will learn about 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 This course is ideal for individuals who are Students wishing to learn Visual Basic programming techniques and advanced Excel features. It is particularly useful for Students wishing to learn Visual Basic programming techniques and advanced Excel features.

Enroll now: Excel 2010 VBA and Advanced (2-Course Bundle)

Summary

Title: Excel 2010 VBA and Advanced (2-Course Bundle)

Price: $19.99

Average Rating: 4.4

Number of Lectures: 58

Number of Published Lectures: 58

Number of Curriculum Items: 58

Number of Published Curriculum Objects: 58

Original Price: $59.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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.

Course Curriculum

Chapter 1: Excel 2010 VBA

Lecture 1: Introduction

Lecture 2: Displaying the Developer Tab

Lecture 3: Setting Macro Trust within Excel 2010

Lecture 4: Recording and Running a Macro

Lecture 5: Examining the VBA Editor Part 1

Lecture 6: Examining the VBA Editor Part 2

Lecture 7: Reviewing the Excel 2010 Object Model

Lecture 8: Understanding Functions and Procedures

Lecture 9: Understanding Variables and Scope Part 1

Lecture 10: Understanding Variables and Scope Part 2

Lecture 11: Commenting Your Code

Lecture 12: Creating Constants

Lecture 13: Understanding Arguments

Lecture 14: Using If-Then-Else

Lecture 15: Understanding Logical Operators

Lecture 16: Creating a Select-Case Statement

Lecture 17: Creating For-Next Loops

Lecture 18: Creating Do Loops

Lecture 19: Creating While-Wend Loops

Lecture 20: Viewing the Object Browser

Lecture 21: Using the InputBox Function

Lecture 22: Understanding the MsgBox Function

Lecture 23: Using String Functions

Lecture 24: Using Date Functions

Lecture 25: Designing a Form

Lecture 26: Understanding Different Controls

Lecture 27: Working with Form Properties Part 1

Lecture 28: Working with Form Properties Part 2

Lecture 29: Understanding the Difference Between Syntax and Logic Errors

Lecture 30: Using Breakpoints

Lecture 31: Stepping Through Your Macro

Lecture 32: Creating Watches

Lecture 33: Adding Error Traps

Lecture 34: Course Recap

Chapter 2: Excel 2010 Advanced

Lecture 1: Introduction

Lecture 2: Help with Functions

Lecture 3: Logical Functions

Lecture 4: Financial Functions

Lecture 5: Text Functions

Lecture 6: Lookup Functions

Lecture 7: Applying Conditional Formats

Lecture 8: Managing Conditional Formats

Lecture 9: Creating Sparklines

Lecture 10: Modifying Sparkline Styles

Lecture 11: Using Data Validation

Lecture 12: Working with Tables

Lecture 13: Sorting a List

Lecture 14: Filtering Data

Lecture 15: Creating a PivotTable

Lecture 16: Filtering and Sorting

Lecture 17: Filtering with Slicers

Lecture 18: Adding a PivotChart

Lecture 19: Auditing and Error Checking

Lecture 20: Using the Scenario Manager and Goal Seek

Lecture 21: Transferring Between Word and Excel

Lecture 22: Importing a Text File

Lecture 23: Transferring Between Access and Excel

Lecture 24: Course Recap

Instructors

Intellezy Trainers
Multi-Award-Winning eLearning Specialists

Rating Distribution

1 stars: 1 votes
2 stars: 4 votes
3 stars: 11 votes
4 stars: 13 votes
5 stars: 30 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu