Excel 2007 - Advanced
Duration: 1 day
Cost: $90.00 per student
Course Content
WORKING WITH TABLES
Creating Tables
- How To Create A Table
- How To Change The Style Of A Table
- How To Create A New Table Style
- How To Show Or Hide Table Elements
- How To Create A Calculation In A Table
- How To Insert And Delete A Table Row
- How To Resize A Table
- How To Convert A Table To A Range
- How To Sort The Data In A Table
- How To Perform Multiple Sort
- How To Customize The Sort Order
Using The AutoFilter
- How To Enable / Disable The AutoFilter
- How To Apply / Remove The Filter
- How To Customize The Filter
Using The Advanced Filter
- How To Define The Criteria Range
- How To Use The Advanced Filter
- Using Simple Database Functions
- How To Find The Sum Of Specific Records
Using The Insert Function Button
- How To Find The Average Of Specific Records
- How To Find The Maximum / Minimum Value Of Specific Records
- How To Find The Number Of Records
Using The VLOOKUP Function
- How To Use VLOOKUP To Find Data
- How To Limit The Lookup Value For An Exact Match
- How To Use The Closest Match For The Lookup Value
CREATING A PIVOTTABLE AND ANALYZING DATA
Creating A PivotTable
- How To Create A PivotTable
Updating A PivotTable
- How To Update The Information In A PivotTable
- How To Change The Layout Of A PivotTable
- How To Add An Information Field To A PivotTable
- How To Arrange Information In A PivotTable
- How To Filter The Report In A PivotTable
- How To Filter Specific Records
Working With Calculated Fields In A PivotTable
- How To Change The Calculated Field Value Settings
- How To Insert A Calculated Field
- How To Delete Calculated Fields
- How To Change A PivotTable Options
Creating A Chart From A PivotTable
- How To Create A Chart From A PivotTable
Exploring What-If Tables
- How To Create A One Variable What-If Table
- How To Create A Two Variables What-If Table
Using Scenarios
- How To Create Scenarios
- How To Apply A Scenario
Implementing Problem Solving
- How To Use The Goal Seek Tool
- How To Load Add-Ins
- How To Use The Solver Tools
USING WORKGROUP FEATURES
Using Comments
- How To Add A Comment Into A Cell
- How To Show/Hide Comments Permanently
- How To Show/Hide Comment Indicators
- How To Inspect A Workbook
- How To Apply Password Protection To The Editable Cells
Sharing Workbooks
- How To Enable Workbook Sharing
- How To Merge Copies Of Shared Workbooks
- How To Accept Or Reject Changes In A Merged Workbook
- How To Protect A Shared Workbook
- How To Track Changes In The Same Workbook
- How To Accept Or Reject Changes From Different Users
AUTOMATING ROUTINE TASKS WITH MACROS
Understanding Macros
- How To Record A New Macro
- How To Run A Macro
- How To Create A Run Macro Button On The Quick Access Toolbar
- How To Show The Developer Tab
- How To Create A Macro Command Button On A Worksheet
- How To Edit The Command Button
Editing A Macro
- How To Edit Macro Coding
- How To Rename A Macro
- How To Delete A Macro
Using A Relative Reference Macro
- How To Record A Relative Reference Macro
- How To Run A Relative Reference Macro
INTEGRATING DATA WITH OTHER APPLICATIONS
Importing/Exporting Data
- How To Use The Text Import Wizard
- How To Export Data To Another File Type
- How To Copy Data From Other Applications
- How To Insert An Object
Retrieving Data From A Database
- How To Get Specific Information From Microsoft Query
