Save 20% by buying both courses. This bundle includes:
The Excel 2007 VBA course introduces you to Excel Macro programming using Microsoft's Visual Basic for Applications (VBA). The overall focus of this course is to teach you proper Visual Basic programming techniques along with an understanding of Excel's object structure. Other topics in this course include recording macros, programming basics, proper variable declaration, Visual Basic functions, 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 2007 Advanced course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you learn how to analyze and manage your data. You will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager, and subtotals. Additionally, during this course, you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and PivotCharts, and record basic Macros.
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.