|
Microsoft Excel, Macros &
VBA Fundamentals Course Outline
Aims of the Two-Day Course
This course has been designed for existing Microsoft Excel users who
wish to learn how to use Macros and fundamentals of VBA. This course is
100% hands-on, with exercises to practice the skills as you learn them.
Course Content
- Charts
- Create a Chart (Type, Data Source, Options & Location)
- Format a Chart
- Import/Export To and From an Access Database
- From Excel to Access
- Export an object’s output as a microsoft Excel file
- Load the output of a Table, Query, Form or Report into
microsoft Excel
- Customising Excel
- Creating & Displaying a View
- Creating a Template
- Changing the Default Template Style
- Using a Custom Template to create a new Workbook
- Create a custom AutoFill series
- Outlining a Worksheet
- PivotTables
- Create a PivotTable using the PivotTable Wizard
- Changing Layouts
- Using other functions in a PivotTable
- Advanced Excel Functions
- VLOOKUP function
- The IF function
- Nesting IF Functions
- The ISERROR function
- Combining ISERROR, IF and VLOOKUP functions
|
- Database Functions
- Criteria
- Using Dfunctions (DUM, DMAX & DAVERAGE)
- Macros
- Recording a Macro
- Running a Macro
- Relative References
- Assigning a Macro to an Icon on the Toolbar
- Changing the Icon Appearance
- Editing Macros
- The Visual Basic Editor
- The Project Explorer
- The Code Window
- Procedures
- Inserting Comments
- VBA Objects
- The Range Object
- Flexible Ranges
- Virtual Worksheets
- Range Contents
|
Prerequisites
Trainees should have attended the Intermediate Excel course and have
a good working knowledge of Microsoft Excel.
Course Duration
Twelve hours (9.30am to 12.30pm and 1.30pm to 4.30pm on both days).
Prices
|
