Microsoft Excel 2007 Training ManualTable of Contents: Level 3
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 Set 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
©2007 EBook Publishing. All rights reserved.
|
