Prerequisites
Participants who want to attend this training should have basic knowledge in Microsoft Excel or have basic PC skills.
Course Description
Take your basic Microsoft Excel skills to the next level with this Advanced MS Excel training with VBA. This module takes you on a 2-day instructor-led workshop on the advanced capabilities of Microsoft Excel 2010, 2013 or 2016 with an introduction to an advanced excel VBA course.
At the end of the training, you should have a solid understanding of the more powerful functionalities of Excel to enable you to use it in a business environment. This course involves examples and exercises led by our premiere Microsoft Excel trainers and practicing data analysts who will leave you with practical tips and tricks that you can use at work on a regular basis.
Course Objectives
Upon completion of this course, participants will be able to:
-
Work with advanced formulas
-
Work with lookup functions
-
Create data tables
-
Validate cell entries
-
Work with data forms
-
Work with PivotTables
-
Export and import data
-
Query external databases
-
Work with Goal Seek and Solver
-
Work with scenarios
-
Work with views
-
Work with macros
-
Create interactive Web spreadsheets
-
Use Visual Basic Editor
-
Write basic programs in VBA
-
Work with custom dialog boxes
-
Use debugging and error-handling techniques
Who Should Attend
The MS Excel course with VBA that Phoenix One offers best suits individuals who already have foundational knowledge of how to use the software. This course will touch on creating interactive web spreadsheets, debugging techniques, and writing basic programs in VBA.
This course is highly recommended for any professional who uses Microsoft Excel and would like to learn advanced MS Excel skills to help them become more effective in their roles. Finance executives, marketing analysts, business managers and anyone who would like to learn advanced MS Excel skills can greatly benefit from the modules tackled in this training.