Microsoft Excel 2003 Training Manual Our CompleteVISUALTM computer training manual is now used in over 60 countries worldwide! Why are we the best seller:
The first ever-created complete visual step-by-step training manuals
Unlimited printing rights
No annual renewal fees
Suitable for all levels of users
Low cost site license but high quality manuals
Independent hands on lessons and completely customizable
Microsoft Excel 2003 Training Manual
Table of Contents: Module 1
GETTING STARTED
Creating An Excel 2003 Workbook
What's New In Excel 2003
How To Start Excel 2003
How To Create a New Default Excel Workbook
How To Create A New Excel Workbook Using Template
Getting Familiar With The Excel Screen
How To Use Menu
How To Show Or Hide Toolbars
How To Move Toolbar And Menu Bar
How To Use Toolbar Button
How To Use Shortcut Menu Using Right Mouse Click
How To Use Shortcut Key
Getting Help And Maintenance
How To Search Help
How To Use Content Help
How To Use Microsoft Office Online
How To Use Type A Question For Help Box
How To Use Office Assistant Help
How To Use Get Help In A Dialog Box
How To Get Office Updates From Microsoft Office Online
How To Detect And Repair Errors In Excel
How To Recover Excel When It Is Not Responding
How To Set The AutoRecover Options
How To Recover An Excel File
Moving Around Your Cursor
How To Activate A Cell Using The Mouse
How To Move To A Cell Using Keyboard
How To Move Using Go To Command
How To Move using Name Box
How To Move Within Selected Range
How To Move To Other Sheets Within A Workbook
Selecting Range In Workbook
How To Select A Single Cell
How To Select A Range of Cells
How To Select A Range Of Cells Using Shift key
How To Select The Entire Column
How To Select The Entire Row
How To Select The Entire Worksheet
How To Select Non-Adjacent Ranges
How To Select Multiple Worksheets
Entering Data Into Worksheet
How To Enter Text (Label) Into A Cell
How To Edit Cell Content
How To Edit Contents Using Formula Bar
How To Replace Contents In A Cell
How To Delete Contents In A Cell
How To Undo And Redo
How To Enter Number As A Value Into A Cell
How To Enter Number As A Label Into A Cell
How To Enter Date Into A Cell
How To Use AutoFill To Enter Text
How To Use AutoFill Options
How To Use AutoFill To Enter Sequence Numbers
How To Customize AutoFill
How To Use Pick List To Enter Data
How To Enter Data Into A Range Of Cells
How To Fill A Range Of Cells With The Same Data
How To Save A Workbook For The First Time
How To Save Another Copy Using `Save As'
How To Save To Another Folder
How To Save Into A Diskette
How To Save Into A Different File Format
How To Close The Current Workbook
How To Open A Workbook
How To Exit Excel 2003
PERFORMING CALCULATIONS
Using Simple Formula
How To Enter A Formula Using Keyboard
How To Enter A Cell or A Range Reference Using Mouse
How To Use AutoSum To Calculate Total Quickly
How To Use Relative References
How To Use Absolute References
Using Simple Functions
How To Enter A Function Directly
How To Use Paste Function
Using AutoCalculate And Labels
How To Use AutoCalculate To Calculation Without Using Formula
How To Accept Labels In Formulas
How To Use Label (Natural Language) In Formula
MANAGING WORKSHEET AND WORKBOOK INFORMATION
Managing Worksheet Information
How To Move Information Using Cut And Paste
How To Move Information Using Drag And Drop
How To Copy Information Using Copy And Paste
How To Use Paste Options
How To Copy Information Using Drag And Drop
How To Insert A New Row
How To Insert Multiple Rows
How To Delete Rows
How To Insert A New Column
How To Insert Multiple Columns
How To Delete Columns
How To Insert A Cell
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
How To Add Worksheet Background
How To Delete Worksheet
EXERCISES
Exercise - Getting Started
Exercise - Performing Calculations
Exercise - Managing Worksheet and Workbook Information
Microsoft Excel 2003 Training Manual
Table of Contents: Module 2
FORMATTING WORKSHEET
Adjusting Column Width / Row Height
How To Adjust Column Width Using Mouse
How To Adjust Column Width Using Menu
How To Adjust Row Height Using Mouse
How To Adjust Row Height Using Menu
How To Hide / Unhide Rows / Columns
How To Freeze A Column / A Row
How To Slit A Worksheet In Panes
Formatting Cell Using Toolbar
How To Change Font
How To Change Font Size
How To Bold
How To Italic
How To Underline
How To Change Font Color
How To Align Data In A Cell
How To Indent Data In A Cell
How To Merge Cells And Center Data
How To Change Number To Percentage
How To Increase / Decrease Decimal Points
How To Copy Format Using Format Painter
Formatting Cell 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 Color
How To Add Outline Border
How To Add Double Line Border
How To Format Table Using AutoFormat
CREATING CHART
Creating Chart Using Chart Wizard
How To Use Chart Wizard
How To Move Chart
How To Resize Chart
How To Change Chart Type
How To Change Chart Source Data
How To Swap Data Series In Legend With The X-axis
How To Move Existing Chart To Another Worksheet
Changing Chart Options
How To Change Chart Title, X axis And Y axis Title
How To Change Gridlines
How To Change Legend Options
How To Change Data Labels
How To Add Data Table
How To Delete Data Series
How To Add Data Series Using Mouse
How To Delete Chart
Formatting Chart
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
SETTING UP PAGE AND PRINT
Setting Up Page
How To Insert And Remove Page Break
How To Set And Clear Print Area
How To Change Page Orientation
How To Change Scaling
How To Change Paper Size
How To Change Page Margin
How To Align To Center Of Page
How To Add Header / Footer
Previewing and Printing
How To Print Preview
How To Print Active Sheets
How To Print Selected Cells
How To Print Chart
How To Multiple Copies
EXERCISES
Exercise - Formatting Worksheet
Exercise - Creating Chart
Exercise - Setting Up Page and Print
Microsoft Excel 2003 Training Manual
Table of Contents: Module 3
VALIDATING, PROTECTING, AUDITING FORM AND TEMPLATE
Using Data Validation
How To Validate Data Input
How To Compose Data Input Message
How To Create Error Alert Message
Creating New Workbook Using Template
How To Create A New Workbook Using Built-In Template On Your Computer
How To Create A New Workbook Using Template On Office Online
How To Create A New Template
How To Create New Workbook From Own Template
How To Edit The Template
Protecting Worksheet Style, Contents And Elements
How To Protect The Worksheet
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
Protecting Your Workbook From Unauthorized Users Access
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
Auditing Worksheets And Tracing Cell References
How To Select Cells That Contain Formula
How To Watch Formulas
How To Find Cells That Provide Data To An Active Cell (Precedents)
How To Find Cells That Referred By An Active Cell (Dependents)
How To Hide All The Auditing Arrows
Tracing Errors
How To Circle And Remove Circle For Invalid Data
How To Correct Calculation Errors
How To Set Error Checking Options
How To Scan And Correct All Errors
WORKING WITH ADVANCED FORMATTING, STYLE AND OUTLINING
Customizing Data Appearance With Advance Formatting
How To Use Build-In Number Formats
How To Custom Number Format
How To Custom Date Format
Using Conditional Formatting
How To Use Conditional Formatting
Maintaining Format Consistency With Style
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
Using Data Outlining
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
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 3-D Formula Across Worksheets
How To Enter 3-D Formula Across Worksheets
How To Enter 3-D Formula Across Worksheets Using Function
Using Range Name
How To Define A Range Name
How To Define A 3-D Range Name Using The Menu
How To Redefine The Cell References In Range Name
How To Delete A Range Name
How To Use Range Name In 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 Workbook
How To Link Information Using Copy And Paste Link
How To Update Link
USING ADVANCED FUNCTIONS
Using Financial Functions
How To Use PMT Function
How To Use ABS Function
Using Logical Functions
How To Use Logical Test
How To Use IF Function To Return A Text
How To Use IF Function To Return A Value
How To Use Nested IF Function
How To Use OR Function
How To Use AND Function
How To Use COUNTIF Function
USING WORKGROUP FEATURES
Using Comments
How To Add Comment Into A Cell
How To Show Comments
How To Show/Hide Comment Indicators
How To Edit And Delete Comments
Sharing Workbooks
How To Enable Workbook Sharing
How To Disable Workbook Sharing
How To Merge Copies Of Shared Workbook
How To Accept Or Reject Changes In Merged Workbook
How To Protect A Shared Workbook
How To Track Changes In The Same Workbook
How To Accept Or Reject Changes From Different Users
Creating Workbook With Restricted Permission Using IRM
How To Create Workbook With Restricted Permission
How To View Workbook With Restricted Permisssion
How To Allow Users To View Workbook Without Microsoft Office 2003
How To Allow Users To Print Documents With Restricted Permission
How To Change User's Access Level
How To Set An Expiration Date For A Workbook
How To Attach A Referral Information In Restricted Workbook
How To Remove Workbook With Restricted Permission
EXERCISES
Exercise - Validating, Protecting, Auditing Form And Template
Exercise - Using Advanced Formatting, Style And Outlining
Exercise - Working With Multiple Worksheets And Workbooks
Exercise - Using Advance Functions
Exercise - Using Workgroup Features
Microsoft Excel 2003 Training Manual
Table of Contents: Module 4
CREATING POWERFUL DATABASE
Creating Database
How To Create Database Field
How To Add Records Manually
How To Add New Record Using A Built-In Data Form
Managing Record in Database
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
Sorting Records
How To Perform Simple Sort
How To Perform Multiple Sort
How To Set Advanced Sort Options
Using AutoFilter
How To Enable / Disable AutoFilter
How To Apply / Remove The Criteria
How To Customize Criteria
How To Use Wildcard In Criteria
Using Advance Filter
How To Define The Criteria Range
How To Use The Advanced Filter Command
Using Simple Database Functions
How To Find The Sum Of Specific Records Using Paste Function
How To Find The Average Of Specific Records
How To Find The Maximum / Minimum Value Of Specific Records
How To Find The Number Of Records
Using VLOOKUP Function
How To Use VLOOKUP To Find Data
How To Limit The Lookup Value For Exact Match
How To Use The Closest Match For The Lookup Value
CREATING PIVOTTABLE AND ANALYZING DATA
Creating Pivot Table
How To Create A PivotTable
How To Create A PivotTable From An Access Database
Updating Pivot Table
How To Update Information In Pivot Table
How To Add Information In Pivot Table
How To Arrange Information In Pivot Table
How To Remove Information In Pivot Table
How To Create Page In Pivot Table
How To Display Pages On Separate Sheets
Modifying Calculated Field in Pivot Table
How To Use Other Functions In Calculated Fields
How To Insert Calculated Fields
How To Hide Calculated Fields
How To Delete Calculated Fields
Creating Chart From Pivot Table
How To Create Chart From Pivot Table
Exploring What-If Table
How To Create One Variable What-If Table
How To Create Two Variable What-If Table
Using Scenarios
How To Create Scenarios
How To Apply Scenario
How To Edit Scenario
How To Delete Scenario
Implementing Problem Solving
How To Use Goal Seek
How To Load Add-Ins
How To Use Solver
AUTOMATING ROUTINE TASKS WITH MACROS
Understanding Macros
How To Record New Macro
How To Run Macro With Menu
How To Create A Run Macro Button On Toolbar
How To Create Macro Command Button On Worksheet
How To Edit Command Button
Editing Macro
How To Edit Macro Coding
How To Rename Macro
How To Delete Macro
Using Relative Reference Macro
How To Record A Relative Reference Macro
How To Run Relative Reference Macro
IMPORTING AND EXPORTING DATA
Importing / 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
Retrieving Data From A Database
How To Get Specific Information Using Database Query
How To Edit Database Query
WORKING WITH THE WEB
Creating Web Pages
How To Create Web Page In Excel
How To Create An Interactive Web Page
How To Preview A Web Page
How To Publish A Web Page
How To Add A New FTP Site
How To Access Files In An FTP Site
Editing The Web Pages
How To Open And Edit A Workbook Web Page
How To Create A Hyperlink
How To Delete A Hyperlink
EXERCISES
Exercise - Creating Powerful Database
Exercise - Creating Pivot Table And Analyzing Data
Exercise - Automating Routine Tasks With Macros
Exercise - Importing And Exporting Data
Exercise - Working With The Web
