Computer Training
Course Objectives: Advanced Microsoft Excel 2007
Compare your skills and experiences to these objectives to see if this course would be appropriate for you to take.
- The Fundamentals
- Creating PivotTable
- Specifying PivotTable Data
- Changing a Pivot Table’s Calculation
- Filtering and Sorting a PivotTable
- Working with PivotTable Layout
- Grouping PivotTable Items
- Updating a PivotTable
- Formatting a PivotTable
- Creating a PivotChart
- Creating Scenarios
- Creating a Scenario Report
- Working with Data Tables
- Using Goal Seek
- Using Solver
- Using Data Validation
- Using Text to Columns
- Removing Duplicates
- Grouping and Outlining Data
- Using Subtotals
- Consolidating Data by Position or Category
- Consolidating Data Using Formulas
- Inserting a Hyperlink
- Creating a Web Page from a Workbook
- Importing Data from an Access Database or Text File
- Importing Data from the Web and Other Sources
- Working with Existing Data Connections
- Recording a Macro
- Playing and Deleting a Macro
- Adding a Macro to the Quick Access Toolbar
- Editing a Macro’s Visual Basic Code
- Inserting Copied Code in a Macro
- Declaring Variables and Adding Remarks to VBA Code
- Prompting for User Input
- Using the If…Then…Else Statement
- Inserting Clip Art
- Inserting Pictures and Graphics Files
- Formatting Pictures and Graphics
- Inserting Shapes
- Formatting Shapes
- Resize, Move, Copy and Delete Objects
- Applying Special Effects to Objects
- Grouping Objects
- Aligning Objects
- Flipping and Totaling Objects
- Layering Objects
- Inserting SmartArt
- Working with SmartArt Elements
- Formatting SmartArt
- Using WordArt
- Inserting an Embedded Object
- Inserting Symbols