By Simpliv
Online
Can be taken anytime
Professional Training Course
Yes (Details)
English
$10
Course Overview
About this Course:
You're frustrated with losing time with Excel, while you could automate repetitive tasks! You regret not knowing how to program in VBA, right?
So read on, it may interest you!
This course is for non-computer scientists, and it's a complete training in learning VBA for Excel. You will learn the basics of programming in VBA to, for example, automate repetitive tasks, write your own custom functions, develop an ergonomic form, add your own control buttons in the ribbon, control Word.
This training has 2 objectives:
- You learn VBA language
- Teach you how to program Excel
Each lesson consists of a video of about 10 minutes, which captures the trainer's Excel screen during the presentation. You see exactly how the program is written, and then you can experiment on your own. Some lessons end with an exercise topic, most often corrected by the trainer in the following video. Excel2013 was used to shoot the videos. But the entire content of this training is 100% usable with previous versions (2010, 2007, 2003)
To successfully complete this course, it is essential to program by yourself, to resume and experiment all the programs analyzed in the videos and to do all the exercises.
Basic knowledge:
- It is necessary to be able to program and to have a computer equipped with Excel, version 2003, 2007, 2010 or 2013
Who should take this course
Who is the target audience?
- This course is not designed to learn how to use Excel, with the classic user interface. This knowledge is supposed to be already acquired
- This course is suitable for people who already use Excel, especially for business needs. It will save time by automating repetitive tasks. It will also enable them to develop better applications, offering more features
Accreditation
Course Completion Certificate
Course content
What you will learn:
- Automate repetitive tasks on a workbook
- Use external files
- Develop a user interface form
- Use Word to do mail merge
- support existing macros to correct or improve them
- Develop a complex application, controlled by buttons added to the ribbon
About Course Provider
Simpliv LLC, a platform for learning and teaching online courses. We basically focus on online learning which helps to learn business concepts, software technology to develop personal and professional goals through video library by recognized industry experts or trainers.
Why Simpliv
With the ever-evolving industry trends, there is a constant need of the professionally designed learning solutions that deliver key innovations on time and on a budget to achieve long-term success.
Simpliv understands the changing needs and allows the global learners to evaluate their technical abilities by aligning the learnings to key business objectives in order to fill the skills gaps that exist in the various business areas including IT, Marketing, Business Development, and much more.