Skip to content
UdemyExcelPaid courseExpert levelCertificate

Excel 2010 VBA and Advanced (2-Course Bundle) (Udemy.com)

Learn the Visual Basic programming language and take your Excel skills to the next level in this 2-course bundle.

Created by: Intellezy Trainers

Last updated February 2018

icon
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

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

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Intellezy Trainers

Intellezy collaborates with organizations to help implement and adopt technology to its full potential. Our online videos include 250+ courses designed to educate and empower individuals

Our library, recognized by top influencers such as The Craig Weiss Group, Training Industry and eLearning Journal, provides dynamic and task-focused videos, quick reference guides, and assessments right at your fingertips, right when you need them.

In today’s rapidly evolving workplace, it is imperative to make sure your team members have the skills and expertise required to succeed. Intellezy offers custom content development to ensure learning materials, and the delivery approach is aligned to meet intended outcomes and address your specific training needs without covering topics that may be unnecessary or irrelevant.

icon
More courses by Intellezy Trainers

$13.99

$14.99

$15.99

$39.99

$11.99

$14.99

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

icon
Reviews

4.2

59 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Dale Leighton on 7/1/2019

Course content is detailed, explained clearly, & well paced. Highly recommended if you are looking for excel 2010 specific material.!!

By Eliud Perez on 4/11/2018

Because the instructor is succinct and clear.

By Cesar Trujillo on 3/12/2018

As of lesson number 3 this has been great

By Suzanne Watt on 3/6/2018

The sections on VBA loops, userforms and debugging were useful, but the rest of the course was far too basic, the modules on excel I didn't even need to look at as I have plenty of experience with formulas, conditional formatting and pivots etc. I thought there would be a lot more detail about VBA

By Phil Hamilton on 1/17/2018

The tutor is very good and explains everything well, however, poor video quality lets this course down

By Alex Mashego on 9/14/2017

So far so good, the instructor is doing a good job presenting the course contents. He also touches on the relevant topic which I am interested in. After going a bit deep with the course, I started feeling like some of the topics were rushed. He does not explain the syntax rules at all.

By Monson Marukatat on 9/10/2017

Two-thirds through, and I have used a lot of what I learnt in my work. My Excel has since been more efficient and less time-consuming as I can command Excel to partially recalculate the large worksheet instead of in the entirety. The instruction has been quite clear and to-the-point. What is missing, though, is the downloadable files to accompany the lecture. From lessons 27 (Forms) onward, I'm lost. It's more of a lecture without an opportunity to do my own exercises. The instructor started with finished codes without walking me through the process.

By Peter King on 8/19/2017

Very well explained! Could use some downloaded resources but otherwise very easy to follow

By Michael Riopel on 7/18/2017

Good information clearly explained. Second course was not what I expected, but a good explanation of Excel user concepts.

By Rajendran S Dhanasekharan on 6/25/2017

clear, well explained. all basics were covered.

Showing all 10 reviews on CourseDuck

Read all 59 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 84 / 100