FORMATTING CELLS USING MENU OPTIONS
Formatting Cells Using Menu Options
- Double Underline Using Menu Option
- Align Vertically
- Change Text Orientation
- Wrap Text In A Cell
- Format Numbers
- Format Date
- Change Cell Background Colour
- Add Outline Border
- Add Double Line Border
- Format Table Using AutoFormat
WORKING WITH ADVANCED FORMATTING, STYLE AND OUTLINING
Customising Data Appearance With Advance Formatting
- Use Build-In Number Formats
- Custom Number Format
- Custom Date Format
Using Conditional Formatting
- Use Conditional Formatting
Maintaining Format Consistency With Styles
- Add Style Box Tool To The Toolbar
- Create New Style
- Apply Styles
- Redefine Style
- Delete Style
- Merge Style From Another Workbook
Using Data Outlining
- Create An Outline Automatically
- Remove Outline
- Create Outline Manually
- Use Subtotal To Create Outline
- Show / Hide Details Using Outline Symbols
- Remove Subtotal
MANAGING WORKBOOK INFORMATION
Managing Workbook Information
- Rename Worksheet
- Add New Worksheet
- Rearrange Worksheet
- Copy Worksheet
- Hide And Unhide Worksheet
- Hide And Unhide Workbook
- Format Worksheet Tab
WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS
Managing Data in Multiple Worksheets
- Select Adjacent Worksheets
- Select Non-Adjacent Worksheets
- Enter Data Into Multiple Worksheets
- Using 3-D Formula Across Worksheets
- Enter 3-D Formula Across Worksheets
- Enter 3-D Formula Across Worksheets Using Function
Using Range Names
- Define A Range Name
- Define A 3-D Range Name Using The Menu
- Redefine The Cell References In Range Name
- Delete A Range Name
- Use Range Name In 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 Link
IMPORTING AND EXPORTING DATA
Importing / Exporting Data
- Use Text Import Wizard
- Export Data To A Document
- Copy Data From Other Applications
- Insert Objects
- Export Data To Excel Workbook In Other Application
Retrieving Data From A Database
- Get Specific Information Using Database Query
- Edit Database Query
FORMATTING CHARTS
Formatting a Chart
- Change Font Format
- Change Text Orientation
- Change Object Color
- Change The Order Of Data Series
- Use Combination Of Chart Type
- Create A Pie Chart
- Use 3-D View To Rotate Chart
- Explode A Wedge In Pie Chart
- Create A Picture Chart
WORKING WITH COMMENTS
Using Comments
- Add A Comment Into A Cell
- Show Comments
- Show/Hide Comment Indicators
- Edit And Delete Comments
CREATING POWERFUL DATABASES
Creating A Database
- Create Database Field
- Add Records Manually
- Add New Record Using A Built-In Data Form
Managing Record in Database
- Search For The Record Using Data Form
- Edit / Delete The Record Using Data Form
- Create A List
- Find Total In A List
- Switch Functions In A List
- Convert A List To A Range
Sorting Records
- Perform Simple Sort
- Perform Multiple Sort
- Set Advanced Sort Options
Using AutoFilter
- Enable / Disable AutoFilter
- Apply / Remove The Criteria
- Customise Criteria
- Use Wildcard In Criteria
Using Advanced Filters
- Define The Criteria Range
- Use The Advanced Filter Command
|