- Duration / Course length: Upto 12 Hours Start now
- Accredited by: CiQCPD Qualification Standards
- Certificates:
- Course delivery: This course is delivered in video format
Course details
Microsoft Excel is one of the most popular spreadsheet programs in the world and is used throughout every single type of business out there. One of the key parts of Excel is the Visual Basic for Applications (VBA) features which can be used to automate tasks in Excel by writing macros. If you would like to make the most out of excel and VBA then this Microsoft Excel 2016 and VBA Training course is for you.You start out with learning to develop macros using the Macro Recorder, editing the macro, and debugging it as well, along with customizing the Quick Access toolbar and hotkeys. Next you move onto formatting worksheets as you look into inserting and formatting text, sorting and duplicating data, and generating reports using macros. Following that you will learn to identify the appropriate dialog box types and ways to capture user input through a variety of techniques. Finally you will look into working with multiple worksheets through the insert, copy and delete options using macros; and performing calculations as well.
All in all, the course will be able to help you automate a lot of tasks and teach you programming as well, if you take the chance and get this course now.
COURSE CURRICULUM
Developing Macros
- Create a Macro Using the Macro Recorder
- Edit a Macro
- Debug a Macro
- Customize the Quick Access Toolbar and Hotkeys
- Set Macro Security
- Insert Text
- Format Text
- Sort Data
- Duplicate Data
- Generate a Report
- Determine the Dialog Box Type
- Capture User Input
- Insert, Copy, and Delete Worksheets
- Rename Worksheets
- Modify the Order of Worksheets
- Print Worksheets
- Create User-Defined Functions
- Automate SUM Functions
- Activities – Microsoft Excel 2016 and VBA Training
Upon completion of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and the results will be given to you immediately. Before sitting your final exam you will have the opportunity to test your proficiency with a mock exam. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £24 for a PDF copy and £39 for an original print copy sent to you by post. Updated on 17 September, 2019
Eligibility / Requirements
Our Microsoft Excel 2016 and VBA Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.
About Adams Academy
Adams Academy is best known for offering awarding body accredited online courses that are available for anyone who wishes to acquire a certification and take their professional life to the next level. As an online learning site, we are aware of the fact that there are a lot of people out there who considers themselves to be a curious learner but the courses that they are interested in are not available in the area. So, we have decided to give them a chance to learn in a convenient way – in their own convenient place and time.
Our Mission
To make learning more accessible to learning enthusiasts, regardless of where they are residing in the world. To offer different courses of different levels for the students to choose from. To position our company as a leader in the industry of online learning.
Our Vision
Maintain the good credibility and reputation that we have built as online courses provider.
