When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
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.
This Course Includes
udemy
4.7 (59 reviews )
8h 34m 
english
Online - Self Paced
professional certificate
Udemy
About Excel 2010 VBA and Advanced (2-Course Bundle)
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.
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.