Intermediate Excel Course 2003

Quick Links to Other Excel Courses

1. Microsoft Excel Basic Course
2. Microsoft Excel Advanced Course
3. Microsoft Excel VBA Course

Duration:

1 day

Prerequisites:

Excel 2003 : Basic or equivalent experience

FORMATTING CELLS USING MENU OPTIONS

• How To Double Underline Using Menu Option

• How To Align Vertically

• How To Change Text Orientation

• How To Wrap Text In A Cell

• How To Format Numbers

• How To Format Date

• How To Change Cell Background Colour

• How To Add Outline Border

• How To Add Double Line Border

• How To Format Table Using AutoFormat

WORKING WITH ADVANCED FORMATTING, STYLE AND OUTLINING

• How To Use Build-In Number Formats

• How To Custom Number Format

• How To Custom Date Format

• How To Use Conditional Formatting

• How To Add Style Box Tool To The Toolbar

• How To Create New Style

• How To Apply Styles

• How To Redefine Style

• How To Delete Style

• How To Merge Style From Another Workbook

• How To Create An Outline Automatically

• How To Remove Outline

• How To Create Outline Manually

• How To Use Subtotal To Create Outline

• How To Show / Hide Details Using Outline Symbols

• How To Remove Subtotal

MANAGING WORKBOOK INFORMATION

• How To Rename Worksheet

• How To Add New Worksheet

• How To Rearrange Worksheet

• How To Copy Worksheet

• How To Hide And Unhide Worksheet

• How To Hide And Unhide Workbook

• How To Format Worksheet Tab

WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS

• How To Select Adjacent Worksheets

• How To Select Non-Adjacent Worksheets

• How To Enter Data Into Multiple Worksheets

• Using 3-D Formula Across Worksheets

• How To Enter 3-D Formula Across Worksheets

• How To Enter 3-D Formula Across Worksheets Using Function

• How To Link Information Using Copy And Paste Link

• How To Update Link

IMPORTING AND EXPORTING DATA

• How To Use Text Import Wizard

• How To Export Data To A Document

• How To Copy Data From Other Applications

• How To Insert Objects

• How To Export Data To Excel Workbook In Other Application

• How To Get Specific Information Using Database Query

• How To Edit Database Query

FORMATTING CHARTS

• How To Change Font Format

• How To Change Text Orientation

• How To Change Object Color

• How To Change The Order Of Data Series

• How To Use Combination Of Chart Type

• How To Create A Pie Chart

• How To Use 3-D View To Rotate Chart

• How To Explode A Wedge In Pie Chart

• How To Create A Picture Chart

WORKING WITH COMMENTS

• How To Add A Comment Into A Cell

• How To Show Comments

• How To Show/Hide Comment Indicators

• How To Edit And Delete Comments

PROTECTING WORKSHEET STYLE, CONTENTS AND ELEMENTS

• How To Unprotect The Worksheet

• How To Unlock Cell For Editing In Protected Sheet

• How To Hide Cell Formula In Protected Sheet

• How To Set Password To Edit Specific Range

• How To Grant Selected Users Edit Range Without Password

• How To Protect The Workbook Structure

• How To Unprotect The Workbook Structure

• Protecting Your Workbook From Unauthorized Users Access

• How To Set Password To Open

• How To Remove Password To Open

• How To Set Password To Modify CREATING

CREATING POWERFUL DATABASES

• How To Create Database Field

• How To Add Records Manually

• How To Add New Record Using A Built-In Data Form

• How To Search For The Record Using Data Form

• How To Edit / Delete The Record Using Data Form

• How To Create A List

• How To Find Total In A List

• How To Switch Functions In A List

• How To Convert A List To A Range

• How To Perform Simple Sort

• How To Perform Multiple Sort

• How To Set Advanced Sort Options

• How To Enable / Disable AutoFilter

• How To Apply / Remove The Criteria

• How To Customize Criteria

• How To Use Wildcard In Criteria

• How To Define The Criteria Range

• How To Use The Advanced Filter Command