Microsoft Excel 2007 Training ManualTable of Contents: Level 2
WORKING WITH
ILLUSTRATIONS AND CHARTS
How To Insert An Picture And Apply A Style
To It
How To Apply A Shape To A Picture
How To Apply An Effect
How To Insert Shapes And Apply Styles
How To Rearrange, Show/Hide Objects Using
The Selection Pane
How To Insert A SmartArt
How To Use The SmartArt Text Pane
How To Change The Shape In A SmartArt Creating A Chart
How To Insert A Chart How To Move A Chart How To Resize A Chart How To Change The Chart Type
How To Add, Edit or Remove A Chart Data
Source How To Swap Labels In The Legend With The Horizontal Axis
How To Change The Order Of A Data Series How To Move An Existing Chart To A New Worksheet Modifying A Chart
How To Change A Chart Layout And Style How To Change The Chart Title How To Change The Axis Titles How To Change The Legend How To Insert Data Labels How To Add A Data Table How To Change The Axes How To Change The Gridlines
How To Insert A New Chart Element How To Delete A Chart Formatting A Chart How To Select A Chart Element How To Format The Chart Elements
How To Format Text In A Chart Using
WordArt How To Change The Text Orientation How To Change The Color Of A Chart Element How To Create A Combination Of Chart Types How To Create A Pie Chart
How To Set The 3-D Rotation How To Explode A Wedge In A Pie Chart How To Create A Picture Chart SETTING UP A PAGE AND PRINTING Setting Up A Page
How To Insert And Remove A Page Break
How To Set And Clear The Print Area How To Change The Margin In The Page Layout View How To Change The Page Orientation How To Change The Scaling How To Change The Paper Size How To Change The Page Margin How To Align To The Center Of The Page How To Add A Header / Footer
How To Add An Image As A Watermark Previewing and Printing How To View The Print Preview How To Print Active Sheets How To Print Selected Cells How To Print A Chart How To Print Multiple Copies VALIDATING, PROTECTING AND AUDITING FORMS & TEMPLATES Using Data Validation And Tracing Invalid Data How To Validate Data Input How To Compose A Data Input Message How To Create An Error Alert Message How To Circle Invalid Data Creating A New Workbook Base On A Template
How To Create A New Workbook Base On A
Template How To Create A New Template How To Create A New Workbook Base On Your Own Template How To Edit The Template Protecting Worksheet Styles, Contents And Elements How To Protect The Worksheet How To Unprotect The Worksheet How To Unlock Cells For Editing In A Protected Sheet How To Hide A Cell Formula How To Set A Password To Edit A Specific Range How To Grant Selected Users Permission To Edit A Range Without A Password Protecting Workbook Contents How To Protect And Unprotect The Workbook Structure Protecting Your Workbook From Unauthorized Users Access How To Set A Password To Open A Worksheet How To Remove A Password From A Workbook How To Set A Password To Modify A Worksheet Auditing Worksheets And Tracing Cell References How To Find Cells That Provide Data To An Active Cell (Precedents) How To Find Cells That Are Referred To By An Active Cell (Dependents) How To Correct Calculation Errors How To Set Error Checking Options How To Scan And Correct All Errors How To Use The Watch Window WORKING WITH ADVANCED FORMATTING, STYLES AND OUTLINING Customizing The Appearance Of Data With Advanced Formatting How To Use The Built-In Number Formats How To Customize The Number Format How To Customize The Date Format Using Conditional Formatting
How To Use The Conditional Formatting To
Highlight Cells
How To Use The Data Bars
How To Use The Color Scales
How To Use The Icon Sets
How To Edit The Rules
How To Change The Precedence Of The Rules
How To Stop A Rule
How To Clear The Rules Maintaining Format Consistency With Styles And Themes
How To Apply A Built-in Cell Style How To Create A Custom Cell Style How To Apply A Custom Cell Style How To Modify / Delete A Cell Style How To Merge A Style From Another Workbook
How To Apply A Theme
How To Create New Theme Colors
How To Create New Theme Fonts
How To Select The Theme Effects
How To Save The Custom Theme Using Data Outlining How To Create An Outline Automatically How To Remove An Outline How To Create An Outline Manually How To Use A Subtotal To Create An Outline How To Show / Hide Details Using Outline Symbols WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS Managing Data in Multiple Worksheets How To Select Adjacent Worksheets How To Select Non-Adjacent Worksheets How To Enter Data Into Multiple Worksheets Using A 3-D Formula Across Worksheets How To Enter A 3-D Formula Across Worksheets How To Enter A 3-D Formula Across Worksheets Using A Function Using Range Names How To Define Names Quickly How To Define A Range Name Manually How To Define A 3-D Range
How To Manage Names Using The Name Manager How To Redefine The Cell References For A Range Name How To Insert A Name In A Formula Combining Worksheets And Data From Different Workbooks How To Consolidate Data How To Move Or Copy Worksheets to Another Workbook Linking Information From Different Worksheets And Workbooks How To Link Information Using Copy And Paste Link How To Update A Link USING ADVANCED FUNCTIONS Using Financial Functions How To Use The PMT Function How To Use The ABS Function Using Logical Functions How To Use A Logical Test How To Use The IF Function To Return A Text How To Use The IF Function To Return A Value How To Use A Nested IF Function How To Use The OR Function How To Use The AND Function How To Use the COUNTIF Function ©2007 EBook Publishing. All rights reserved.
|
