Excel 2007 - Intermediate
Duration: 1 day
Cost: $95.00 per student
Course Content
WORKING WITH ILLUSTRATIONS AND CHARTS
Working With Illustrations
- 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 Using The Menu
- 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
