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
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
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.
Instructor Details
- 4.2 Rating
59 Reviews
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.
More courses by Intellezy Trainers
Microsoft 365 Administration (Exam 70-346) (2020)
4.6 (5,865 Reviews)
Provider: Udemy
Time: 6.5h
$13.99
Microsoft Azure Solutions (Exam 70-533) – 9 Course Bundle (2018)
4.5 (1,991 Reviews)
Provider: Udemy
Time: 9.4h
$14.99
More Excel courses
Microsoft Excel Data Analysis - Learn How The Experts Use It (2026)
5.0 (5,696 Reviews)
Provider: Udemy
Time: 3h
$39.99
Microsoft Excel: Advanced Dashboard Design (Project-Based!) (2026)
4.9 (4,868 Reviews)
Provider: Udemy
Time: 6.4h
$99.99
Master NEW Excel Functions in Office 365 & Office 2021+
4.8 (5,262 Reviews)
Provider: Udemy
Time: 7.1h
$15.99
Microsoft Excel Certification Exam Prep: MO-201 Excel Expert (2026)
4.8 (3,239 Reviews)
Provider: Udemy
Time: 8.6h
$119.99
Reviews
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.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 84 / 100












