This course covers Excel Macro Recording and Coding Excal VBA. For Excel users. Extend the capabilities of Excel with Macros and VBA code.
DurationExcel Macros and VBA Course summary
For Excel users. Extend the capabilities of Excel with Macros and VBA code.
Outline:
Record simple Excel macros with shortcuts or buttons
Setting Excel Macro Options
Record and Run Macros
The Quick Access Toolbar
Excel VBA Editor
Use the VBA Editor
Create, copy and import/export modules
Starting the Visual Basic Editor, Use Project Explorer
Creating Procedures and Functions
Create macro procedures in code using variables
Creating Sub and Function Procedures
Declare and Use Variables
Displaying Messages
Getting Input from the User
Controlling Program Flow
IF Statement
Select Case Statement
For Next Loops and Do Loops
Interacting with a spreadsheet :
Referencing Cells and Ranges
Gathering Cell and Range Information
The Offset Method
With Blocks
Referencing Workbooks and Worksheets
Functions
Standard Excel Functions in VBA
Custom functions
Calling functions and sub procedures
User Forms
Basic design, display and interaction with forms
PCWorkshops deliver's computer programming, database and data visualization courses to companies of all industries and sizes in city centers near our locations.
Our head-quarters are in London.
We customize programming courses and query development courses on request per company.
This course will give learners the opportunity to gain more knowledge, experience and confidence using Microsoft PowerPoint through completion of a wide range of tasks.
Tailored for beginners or occasional computer users, the Level 3 ICDL course units aim to elevate you to a professional standard of computer proficiency.
Whether you are a new user or have been using Access for years, this course will vastly increase your understanding of Access.
This afternoon session is suitable for delegates with existing Word experience and who are required to produce longer Word documents.
We have conducted large –scale roll outs of MS Project implementations as well as conducted a highly successful public course schedule for project management tools and Computer Training Courses on MS Office applications such as Word, Excel, Access, PowerPoint and so on.
About Coursetakers.com
Coursetakers.com is more than a decade old course aggregator and Online course platform that helps students find courses and compare course prices from Training providers in the UK, by just submitting their inquiry through the website. Coursetakers also helps Institutes, Universities and Online Instructors market their courses, gain leads and get more students to enroll into their courses.
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy
Online
USA
UK
India
UAE
South Africa
Canada
New Zealand
Australia
Malaysia
Singapore
Saudi Arabia
Egypt
Jordan