Microsoft Excel 2010 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 Show Difference values In A
PivotTable
How To Filter A PivotTable With Slicers
How To Format And Delete A Slicers How To Change A PivotTable Options Creating A Chart From A PivotTable How To Create A Chart From A PivotTable
How To Modify A PivotChart 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
©2010 EBook Publishing. All rights reserved.
|
