Microsoft Excel 2016 and VBA

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

Formatting Worksheets Using Macros

•     Insert Text
•     Format Text
•     Sort Data
•     Duplicate Data
•     Generate a Report

Creating an Interactive Worksheet

•     Determine the Dialog Box Type
•     Capture User Input

Working with Multiple Worksheets

•     Insert, Copy, and Delete Worksheets
•     Rename Worksheets
•     Modify the Order of Worksheets
•     Print Worksheets

Performing Calculations

•     Create User-Defined Functions
•     Automate SUM Functions
•     Activities – Microsoft Excel 2016 and VBA Training

Assessment and Certification: 
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 - Read Less