Excel VBA Level 1
Course
Inhouse
Description
-
Type
Course
-
Methodology
Inhouse
-
Duration
1 Day
Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code.
Important information
Government funding available
About this course
This is
a generic VBA course and is suitable for users of any version of
Microsoft Excel VBA. You need to have a good working knowledge
of Excel.
Reviews
Course programme
Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code.
PREREQUISITES
This is a generic VBA course and is suitable for users of any version of Microsoft Excel VBA. You need to have a good working knowledge of Excel.
MACROS
-
Running Macros
-
Where macros are stored
-
Assigning macros to buttons or a custom toolbar
-
Recording Macros
-
Entering a list of people's names
-
Formatting a cell
-
Adding a Header and Footer
-
Naming the three sheets
-
Inserting three more sheets and naming them
-
Running an Advanced Filter
-
Inserting a Logo
-
Exporting a Sheet to text
-
Create a Pivot Table
-
Protect a sheet with a password
-
Copy a range and paste the values into a new workbook
-
Open, Close, Save a workbook
-
The Screen Components
-
Project Explorer
-
Project Properties
-
The Code Window
-
The Immediate Window
-
Finding Macros
-
Project Explorer
-
Export and Import VBA Modules
-
Add and Remove a module
-
Understanding the macro results
-
Understanding Code Formatting (Indents, etc)
-
Reading from and writing to a cell
-
Absolute vs Relative Referencing
-
Playing back VBA
-
Stepping through code
-
Stopping Code
-
Excel Objects and their hierarchy
-
Workbook
-
Range
-
Cell
-
Worksheet
-
Columns
-
Rows
-
Workbook
-
Using the Offset property
-
Using the object browser
-
What is a sub procedure
-
What is a function
-
Formatting Objects
-
Cut / Copy / Paste
-
Deleting rows / columns / ranges / cells
-
Using Msgbox
-
Using Variables
-
Variable Types
-
Understanding Variable Scope
-
If... elseif... end if
-
Using With...
-
Using Do... Loop
-
Creating a simple function
-
Understanding VBA's Operators (*, /, + etc)
Excel VBA Level 1