| |Microsoft Excel 2007 Level 4 Macros and Pivottables | |
ID: SAE073 | Course Length: 1 |  |
|
| | |
Module 0: Course Details |
| | | - Duration: 1 Day Webinar Or Instructor-led Classroom Setting
- Overview of All Relevant Tabs in the Ribbon
- Work with Macros
- Create Pivot Tables
- Prerequisites:
- Successfully Completed An Introductory Course in Excel
- Working Experience in Using This Software.
- Must Master the Use of the Keyboard, Mouse, and Start Menu.
- Intermediate Experience with Excel
- Ability To Create and Save Files To Folders
- Objectives:
- This Course Will Cover
|
 |
| | |
Module 1: Functions |
| | | - Workday Functions
|
 |
| | |
Module 2: About Macros |
| | | - What Is a Macro
- Why Use a Macro
- Storing a Macro and File Types
- Displaying the Developer Ribbon
|
 |
| | |
Module 3: Using Macros |
| | | - Defining Macros
- Opening a Workbook Containing Macros
- Running a Macro
- Using a Shortcut Key
- Using the Visual Basic Toolbar
- Opening the Visual Basic Editor Window
- Using the Visual Basic Editor Window
|
 |
| | |
Module 4: Recording Macros |
| | | - Recording a Macro
- Assigning a Shortcut Key
- Using Relative References
- Recording a Macro in the Personal Macro Workbook
- Deleting a Macro
|
 |
| | |
Module 5: Creating a Macro Button |
| | | - Creating a Macro Button
- Assigning a Macro To a Button
- Using a Macro Button
- Copying a Macro Button
- Formatting a Macro Button
- Moving/sizing a Macro Button
- Deleting a Macro Button
- Adding the Custom Button To the Qat
|
 |
| | |
Module 6: Pivot Tables |
| | | - What Is a Pivottable
- Creating a Pivottable
- Rearrange a Pivottable
- Format a Pivottable
- Create a Pivotchart
|
 |
| | |
Module 7: Lab |
| | |
|
 |