WORKING WITH ILLUSTRATIONS AND CHARTS
Working With Illustrations
- Insert An Picture And Apply A Style To It
- Apply A Shape To A Picture
- Apply An Effect
- Insert Shapes And Apply Styles
- Rearrange, Show/Hide Objects Using The Selection Pane
- Insert A SmartArt
- Use The SmartArt Text Pane
- Change The Shape In A SmartArt
Creating A Chart
- Insert A Chart
- Move A Chart
- Resize A Chart
- Change The Chart Type
- Add, Edit or Remove A Chart Data Source
- Swap Labels In The Legend With The Horizontal Axis
- Change The Order Of A Data Series
- Move An Existing Chart To A New Worksheet
Modifying A Chart
- Change A Chart Layout And Style
- Change The Chart Title
- Change The Axis Titles
- Change The Legend
- Insert Data Labels
- Add A Data Table
- Change The Axes
- Change The Gridlines
- Insert A New Chart Element
- Delete A Chart
Formatting A Chart
- Select A Chart Element
- Format The Chart Elements
- Format Text In A Chart Using WordArt
- Change The Text Orientation
- Change The Color Of A Chart Element
- Create A Combination Of Chart Types
- Create A Pie Chart
- Set The 3-D Rotation
- Explode A Wedge In A Pie Chart
- Create A Picture Chart
WORKING WITH ADVANCED FORMATTING, STYLES AND OUTLINING
Customizing The Appearance Of Data With Advanced Formatting
- Use The Built-In Number Formats
- Customize The Number Format
- Customize The Date Format
Using Conditional Formatting
- Use The Conditional Formatting To Highlight Cells
- Use The Data Bars
- Use The Color Scales
- Use The Icon Sets
- Edit The Rules
- Change The Precedence Of The Rules
- Stop A Rule
- Clear The Rules
Maintaining Format Consistency With Styles And Themes
- Apply A Built-in Cell Style
- Create A Custom Cell Style
- Apply A Custom Cell Style
- Modify / Delete A Cell Style
- Merge A Style From Another Workbook
- Apply A Theme
- Create New Theme Colours
- Create New Theme Fonts
- Select The Theme Effects
- Save The Custom Theme
|
Using Data Outlining
- Create An Outline Automatically
- Remove An Outline
- Create An Outline Manually
- Use A Subtotal To Create An Outline
- Show / Hide Details Using Outline Symbols
WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS
Managing Data in Multiple Worksheets
- Select Adjacent Worksheets
- Select Non-Adjacent Worksheets
- Enter Data Into Multiple Worksheets
Using A 3-D Formula Across Worksheets
- Enter A 3-D Formula Across Worksheets
- Enter A 3-D Formula Across Worksheets Using A Function
Using Range Names
- Define Names Quickly
- Define A Range Name Manually
- Define A 3-D Range
- Manage Names Using The Name Manager
- Redefine The Cell References For A Range Name
- Insert A Name In A Formula
Combining Worksheets And Data From Different Workbooks
- Consolidate Data
- Move Or Copy Worksheets to Another Workbook
Linking Information From Different Worksheets And Workbooks
- Link Information Using Copy And Paste Link
- Update A Link
WORKING WITH TABLES
Creating Tables
- Create A Table
- Change The Style Of A Table
- Create A New Table Style
- Show Or Hide Table Elements
- Create A Calculation In A Table
- Insert And Delete A Table Row
- Resize A Table
- Convert A Table To A Range
- Sort The Data In A Table
- Perform Multiple Sort
- Set Customize The Sort Order Using The AutoFilter
- Enable / Disable The AutoFilter
- Apply / Remove The Filter
- Customize The Filter
Using The Advanced Filter
- Define The Criteria Range
- Use The Advanced Filter
Using Simple Database Functions
- Find The Sum Of Specific Records Using The Insert Function Button
- Find The Average Of Specific Records
- Find The Maximum / Minimum Value Of Specific Records
- Find The Number Of Records
INTEGRATING DATA WITH OTHER APPLICATIONS
Importing / Exporting Data
- Use The Text Import Wizard
- Export Data To Another File Type
- Copy Data From Other Applications
- Insert An Object
Retrieving Data From A Database
- Get Specific Information From Microsoft Query
|