VBA in Excel Course - Part 2 - Spreadsheet Developer
|
Summary
|
|
|||||||||||||
VBA in Excel Course - Part 2 - Spreadsheet Developer
VBA in Excel Course Part 2 - Spreadsheet Developer - 3 day course in Crawley
Our VBA in Excel Part 2 course is designed for those who are already creating VBA code and need to learn more about what is available and how to use it to create automated solutions.
Versions available: 2003, 2007, 2010
By the end of the course delegates will be able to:
- Use arrays to store and re-use data
- Use objects within the Excel data model to manipulate information
- Write file search routines
- Create functions
- Create complex user forms
Interested in learning more about this VBA in Excel Course Part 2 - Spreadsheet Developer Course? Contact Thales Training here.
If you want to find out more about VBA in Excel Course - Part 2 - Spreadsheet Developer, you can make an information request below and the school will contact you with further information.
Suitability and application
This 2-day VBA in Excel Course Part 2 - Spreadsheet Developer Course is suitable for individuals with previous knowlegde of VBA in Excel who are looking to expand their understanding of in-depth functions.
Pre-requisites: You must have either attended the VBA in Excel – Part 1 course or have equivalent knowledge.
Enquire to see if this VBA
in Excel Course Part 2 - Spreadsheet Developer Course is suitable for you here.
VBA in Excel Course Part 2 - Spreadsheet Developer Course Content
This VBA in Excel Course Part 2 - Spreadsheet Developer Course is designed to cover the following areas:
Comparison operators
- The Like function
System functions
- Val
- Case functions
- Trim functions
- Text functions
- Date functions
Excel functions
- Using Excel functions in VBA
Arrays
- Creating arrays
- Using arrays
- Single and multi dimensional arrays
- Static vs dynamic arrays
The Excel object model
- The object browser
- Collections
- Creating object variables
- Setting object variables
The range object
- Creating range objects
- Passing data between range objects and arrays
Working with sheets
- The For Each . . . Next Loop
- The worksheets collection
- The sheets collection
- Using Typename
Working with workbooks
- The workbooks object
Working with files
- The Dir function
- Searching for files
Working with charts
- The charts collection
- Adding charts
- Amending charts
Creating user defined functions (UDF’s)
- Creating functions
- Adding arguments
- Calling functions
Working with pivot tables
- The pivot tables collection
- The pivot cache
- The pivot fields collection
- The pivot items collection
Application objects
- Excel default information
- Display/alerts
- Screen Updating
- Status Bar
- On Time
- Using Wait
System Dialog boxes
- Showing dialog boxes
- Using dialog boxes
Advanced User Forms
- Using combo boxes
- Using check boxes
- Creating and using option groups
- Form interaction
ActiveX controls
- Multi page controls
- Tab strips
- Progress bar
- Spin button
- Calendar
Expenses
The cost of this VBA in Excel Course Part 2 - Spreadsheet Developer Course is £460.00 + VAT.
Lunch and refreshments: As part of your time with us you will enjoy delicious hot and cold food and refreshments daily from our restaurant.
Reference material: As part of your training you will be provided with a participant manual for you to use during your training. You can then take it away with you to use as a practical reference tool back at the office.
In House training: Should you want to hold a bespoke course at a different venue, please contact us here.
Thales Training
Thales Training - Business Training Courses & Bespoke Training Services
Thales Training & Consultancy, part of the international Thales Group, is an established training services organisation who works in partnership with our customers to develop individual, organisational and commercial advantage. Since 1998 we have been providing innovative training and managed services. Each year we continue to see our business grow delivering training and development solutions to over 10,000 participants internationally.
What we do
Thales Training & Consultancy delivers over 100 training courses in the areas of Management and People Development, IT and Computing, Technology, Project and Risk Management and Systems Engineering. All our courses are highly practical, include examples of best practice and can equip you with the skills and confidence you need to succeed in the workplace.
- Short Training Courses
- Outsourced Training Managed Service /Training Supply Management services
- Management and People Development Training
- IT / Computer Training
- Training Design and Consultancy
- Coaching Consultancy
- Health and Safety Training
- Bespoke Learning and Development Solutions
Courses designed by our trainers
All our courses are exclusively designed and regularly updated by our team of business experienced and expert trainers. This means when you attend one of our training courses you always benefit from the latest thinking and developments.
Our learning environment
All our training courses are held at our state of the art training centre in Crawley. The training centre provides a learning environment that is relaxed, offers great food, easy access, free parking and an exceptional customer service. All of which leads to time out of the office that we believe you’ll want to do again.
Show all courses with
Thales Training
Request information - obligation free
Contact information for Thales Training
Thales Training
RH10 9XN Crawley
Phone no: +44 (0)800 028 3045 
www.thales-trainingconsultancy.com
Contact Thales Training
Reviews by course attendees
Show all reviews
To request information from VBA in Excel Course - Part 2 - Spreadsheet Developer, please fill out the following details:
| Average rating | Quantity | Rec. | ||
| 5.0 | 1 | 100 % |
