This course covers Excel Macro Recording and Coding Excal VBA. For Excel users. Extend the capabilities of Excel with Macros and VBA code.
Excel 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.
Whether you are a new user or have been using Word for years, this course will vastly increase your understanding of Word.
Anyone attending our Intermediate Word 2016 training class should already be able to create, edit, and print Word 2016 documents on Windows. In this Word 2016 session, delegates will learn advanced formatting, use Word 2016 drawing tools, create and manage tables, and work with column layouts.
Microsoft Word combines a powerful word processing application with the user-friendly atmosphere of Windows. Training participants will learn the basics of creating, editing, and saving documents in our Fundamentals level class.
Microsoft Visio course is offered by Eident. Eident deliver scheduled and on-demand IT skills training courses
Now that more presentation are being delivered online, it's even more important to use PowerPoint effectively, to engage your audience. Learn how to prepare professional presentations with our PowerPoint course modules.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy