EXCEL VBA INTRODUCTION
The best solution for Introduction To Excel Vba Training CoursesA hands-on one-day course with free pre-course online skills testing
Note: this Excel VBA Introduction course is CPD certified.
It is delivered as a classroom course.
This means that not only has it been rigorously assessed in terms of content and quality, but it comes with a FREE CPD Certification certificate, as well as an Activia diploma of completion.
We are a corporate member of the CPD: the highest level of association available.
Full details of modules and topics covered in this one-day course
This course covers 2010, 2013 and 2016 versions
This is a one-day training course structured into 5 modules
This intensive, hands-on one-day course has been designed for people who wish to learn the basics of the Excel VBA programming language, get used to the concepts and methods of VBA programming, and understand (and use) the relevant techniques.
The course is designed for existing, experienced users of Excel 2007, 2010, 2013 or 2016 who need to use VBA to automate their spreadsheets.
Delegates should therefore have a solid grounding in, and understanding of, Microsoft Excel to a high level. Familiarity with the content of the Advanced course would be a minimum requirement although the Professional level is ideal.
ABOUT MICROSOFT VBA
VBA stands for Visual Basic for Applications and is a programming language developed by Microsoft. Although VBA is derived from the programming language Visual Basic, it is normally used within a host application (e.g. Excel, Access, etc.) not as a standalone language.
- Setting Excel Macro Options
- Record and Run Simple Macros
- Assign Macros to the Quick Access Toolbar
- Starting the Visual Basic Editor
- Using the Project Explorer
- Using the Properties Window
- Creating, Importing and Exporting Modules
- Explore Recorded Macros
- Creating Sub and Function Procedures
- Declare and Use Variables
- Displaying Message to the User
- Getting Input from the User
- Understanding Objects, Properties and Methods
- Referencing Cells and Ranges
- Gathering Cell and Range Information
- Using the Offset Method
- Using the Resize Method
- Using With Blocks
- Referencing Workbooks and Worksheets
- Using the IF Statement
- Using the Select Case Statement
- Using For Next Loops
- Using Do Loops
- Using For Next Loops
Don't see a date you want?
[Duration: one day]
- Introduction to Dashboards
- Inserting Graphics for a Dashboard
- Specialist Functions and Formulas
- Dashboard Navigation
- Preparing your Workbook's Layout and Structure
- Using Excel Objects for Specialist Dashboard Views
- Using Macros and VBA with Dashboards
[Duration: one day]
- Working with Functions and Formulas
- Outlining, Grouping and Sub Totals
- Protecting Your Spreadsheet
- Presenting Data with Charts
- Formatting Financial Data
- Data Tools: Managing Your Data
- Formula Auditing
- LOOKUP Functions
AVERAGE REVIEW: 4.7 out of 5 BASED ON 21 REVIEWS
All Activia introduction to excel vba training courses have been created, reviewed and developed to ensure up to date provision and constantly improving standards of content. Our Microsoft Excel training is interactive and classroom-based which maximises learning through the ability to ask questions and discuss specific issues.
Maximum class size for Microsoft Excel courses is 6 delegates, which ensures that attendees get adequate time for personal attention from the instructor.
Note that we never cancel our scheduled classes -- even if there are only one or two delegates -- so once you have booked, your place is assured.
For training at your offices, we can deliver classes of up to 8 delegates, though with bigger class sizes you must understand that there is less time for questions from delegates, and this may affect the quality of their experience.
Note: With non-credit card bookings you must sign and return a Booking Form before we can confirm your training.
Also note: If you are a private individual you must pay by credit card at the time of booking.
Note: Please allow 1 - 2 working days for your confirmation and invoice.
If you are coming to our centre, dress code is smart casual. Refreshments in the form of tea/coffee will be provided for morning and afternoon breaks, but please note that we do not provide lunch. The timetable is as follows:
Note: break times can vary according to the needs of the training, and course duration for smaller class sizes are usually shorter because fewer delegates have fewer questions !
For training at your offices, this itinerary can be varied by prior arrangement.
With every Microsoft Excel training course with Activia, you get a free workbook as well as downloadable exercises, which match the course content exactly, so you can review and revise afterwards to reinforce your knowledge.
Every delegate on a Microsoft Excel course also gets an Activia Training Attendance Certificate.