Excel VBA Programming Introduction
G Com Solutions Limited
Summary
- Certificate of completion - Free
Overview
Excel VBA Macros: Hyper-disambiguated Excel VBA Programming | Udemy
Excel VBA programming can seem baffling, especially when you don't fully understand the code you are asked to write. Learn to write Excel VBA macros, from scratch, to automate Microsoft Excel tasks and operations.
This course is aimed particularly at Excel users without much programming experience, who struggle to remember the syntax and structure of the VBA (Visual Basic for Applications) programming language.
During the course, we will use a style of programming which emphasizes the significance of each line of code that you write. This means that when you revisit the code, the meaning of each line is apparent from the syntax, rather than becoming more and more unfamiliar. The course also demonstrates how to get the maximum benefit from IntelliSense, Microsoft's code completion feature.
Course media
Description
This introductory Excel VBA Training Course shows delegates how to create and customise macros and gives them a basic familiarity with the Visual Basic for Applications environment. Best practices are introduced from the outset and delegates are encouraged to learn VBA by understanding its key principles, rather than simply memorising syntax.
Whether you are looking to enhance your career prospects by adding Excel VBA to your C.V., save your company money or increase your productivity, this course will provide your with all the knowledge you need to get started.
COURSE OUTLINE
Basics
Excel VBA overview, Understanding macro steps, Modifying macro steps, Calling one macro from another, Storing values in variables, Adding comments to your code, Stepping through macros, Getting help on macros
Objects, properties and methods
About Excel objects, Using the Object Browser , Range object, The Selection property
The Range property
Targetting cells, Counting the cells in a selection, Using the Offset statement, Retrieving the value of a cell, Retrieving a formula from a cell, Setting the value of cells
Charts and drawing
About programming charts, Assigning a range to a chart, Positioning a chart, Drawing shapes, Setting shape attributes
Using Visual Basic
Language structure, Using variables, Declaring variables, Scoping variables, Data types, Using constants, Using the VBA debugger
Making decisions
If statements, Select Case, Looping structures, Different types of loops, Manipulating arrays
Interactivity
Assigning a macro to a menu, Assigning a macro to a toolbar, Assigning macros to other objects, Built-in dialogue boxes, Creating custom forms, Using the Form Editor , Using form controls
Who is this course for?
Anyone wishing to learn professional Excel VBA programming techniques.
Requirements
Microsoft Excel 2010, 2013 or 2016 and a Windows computer. A basic familiarity with Microsoft Excel is also assumed.
Career path
Excel power user. Data analysis. Data scientist.
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Certificates
Certificate of completion
Digital certificate - Included
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.