Course details
Save 20% by buying both courses. This bundle includes:
- Excel 2007 VBA
- Excel 2007 Advanced
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.
Updated on 22 March, 2018- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Excel Data Analysis Academy for Health & FitnessUSD 13
USD 650Duration: Upto 2 Hours - Microsoft Office 2016 Complete Diploma The Teachers TrainingUSD 13
USD 260Duration: Upto 7 Hours