The course present the extended with Visual Basic for Application functions of Microsoft Excel 2013. The course consists of series of modules, which emphasize on the programming and controlling program flow. The course consists of demonstrations, discussions and scenarios for quick and effective acquiring of the material.
The training is aimed to introduce the participants to the new opportunities for working with Microsoft Excel 2013 so that after the training the participants to be able to apply the learnt tools in their daily work. The goal of the training is not only to show the novelties in the products, but also present facilitating means for the everyday work provided by the new software.
Get the best of Microsoft Excel!
This course will help you learn how to track and visualize data for better management and insight of large amounts of information.
Combine theory with practice
The course is enriched with multiple demonstrations, practical exercises and scenarios for effective learning and
comprehension of the course material.
Meet our team of certified trainers who are here to help you master your knowledge and practices in the area of Microsoft Technologies.
Antoniya is Business Productivity Consultant and Trainer. She is a highly skilled IT professional with more than 10 years of experience in developing solutions and training programs based on Microsoft technologies. Her expertise focus lies in the field of MS SharePoint, MS CRM, MS Office, Business Intelligence and Microsoft e-Learning Gateway solutions implementation.
What you’ll learn
In this course you will learn how to:
- Create macros via recording
- Create and test macros and functions in VBA editor
- Know the structure of the program code
- Declare and use variables
- Expand the MS Excel 2013 environment with new features
- Use different constructions (if..then..else, for … next, etc.) to control the execution of the program code
- Use objects like Application, Workbook, Worksheet, Range
Frequently Asked Questions
Who should attend?
The course is intended for advanced users of Microsoft Excel 2013. Users, who need to upgrade their skills for Enhancing Microsoft Excel 2013 with VBA.
Can the training be customized?
Yes. If you are organizing a training for a group of people from your organization, we can discuss what your goals for the group learning outcomes are. This training can be customized to include more real examples from your everyday work, that have challanged the team!