Microsoft Excel 2016 and VBA Training- CPD Certified & IAO Accredited
Course
Online
Description
-
Type
Course
-
Level
Intermediate
-
Methodology
Online
-
Class hours
12h
-
Duration
Flexible
-
Start date
Different dates available
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 perform 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.
Important information
Price for Emagister users:
Facilities
Location
Start date
Start date
About this course
There is no experience or previous qualifications required for enrolment on this course. It is available to all students of all academic backgrounds.
On receiving your request an academic officer from the course will call you to explain everything about the course, including how you can sign up, payment options and enrollment periods.
Reviews
Subjects
- Excel
- Access
- Microsoft Excel
- Accredited
- Microsoft excel training
- MS Excel
- Macro Recorder
- VBA Training
- Edit a Macro
- Debug a Macro
- Macro Security
Teachers and trainers (1)
Adams Academy
Instructor
Course programme
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
Microsoft Excel 2016 and VBA Training- CPD Certified & IAO Accredited