Excel VBA Level 1
Course
In Southwark
Description
-
Type
Course
-
Location
Southwark
-
Duration
1 Day
Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code.
Important information
Government funding available
Facilities
Location
Start date
Start date
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