Microsoft Stand out 2002 Training Instructions
Our CompleteVISUALTM computer training instructions is now used in over 60 countries worldwide! Why are we the better seller:
The 1st 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 wholly customizable
Microsoft Stand out 2002 Training Instructions
Table of Contents: Module 1
GETTING STARTED
Creating An Stand out 2002 Book
How To Start Stand out 2002
How To Create a New Default Stand out Book Exploitation Task Pane
How To Create A New Stand out Book Exploitation Templet
Getting Familiar With The Stand out Screen
How To Use Menu
How To Show Or Hide Toolbars
How To Come Toolbar And Menu Bar
How To Use Toolbar Button
How To Use Cut off Menu Exploitation Right Mouse Click
How To Use Cut off Key
Getting Help
How To Use Office Assistant Help
How To Use Contents Help
How To Use Answer Wizard Help
How To Use Index Help
How To Use What's This Help
Moving About Your Pointer
How To Activate A Cell Exploitation The Mouse
How To Come To A Cell Exploitation Keyboard
How To Come Exploitation Go To Command
How To Come exploitation Name Box
How To Come Inside Chosen Range
How To Come To Another Sheets inside A Book
Selecting Range In Book
How To Choice A Single Cell
How To Choice A Range of Cells
How To Choice A Range Of Cells Exploitation Shift key
How To Choice The Entire Column
How To Choice The Entire Row
How To Choice The Entire Worksheet
How To Choice Non-Adjacent Ranges
How To Choice Multiple Worksheets
Entering Data into Worksheet
How To Enter Text (Label) Into A Cell
How To Edit Cell Content
How To Edit Text Exploitation Formula Bar
How To Replace Text In The Cell
How To Delete Text In The Cell
How To Enter Number (Value) Into A Cell
How To Enter Date (Value) Into A Cell
How To Use AutoFill To Enter Text
How To Use AutoFill To Enter Sequence Amount
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 Book For The 1st Time
How To Save Another Copy Exploitation `Save As'
How To Save To Another Folder
How To Save Into A Floppy
How To Close The Current Book
How To Open A Book
How To Exit Stand out 2002
PERFORMING CALCULATIONS
Using Simple Formula
How To Enter A Formula Exploitation Keyboard
How To Enter A Cell or A Range Reference Exploitation 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 Exploitation Formula
How To Accept Labels In Formulas
How To Use Label (Natural Language) In Formula
MANAGING WORKSHEET AND Book INFORMATION
Managing Worksheet Information
How To Come Information Exploitation Cut And Paste
How To Come Information Exploitation Drag And Drop
How To Copy Information Exploitation Copy And Paste
How To Copy Information Exploitation 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 Book Information
How To Rename Worksheet
How To Add New Worksheet
How To Arrange Worksheet
How To Copy Worksheet
How To Delete Worksheet
EXERCISES
Exercise - Acquiring Started
Exercise - Acting Calculations
Exercise - Managing Worksheet and Book Information
Microsoft Stand out 2002 Training Instructions
Table of Contents: Module 2
FORMATTING WORKSHEET
Adjusting Column Breadth / Row Height
How To Adjust Column Breadth Exploitation Mouse
How To Adjust Column Breadth Exploitation Menu
How To Adjust Row Height Exploitation Mouse
How To Adjust Row Height Exploitation Menu
Formatting Cell Exploitation 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
Formatting Cell Exploitation Menu Options
How To Double Underline Exploitation Menu Option
How To Align Vertically
How To Change Text Orientation
How To Wrap Text In A Cell
How To Format Amount
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 Exploitation AutoFormat
CREATING CHART
Creating Chart exploitation Chart Wizard
How To Use Chart Wizard
How To Come Chart
How To Size 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 Come 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 Exploitation 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 Image Chart
SETTING UP PAGE AND PRINT
Setting Up Page
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 Chosen Cells
How To Print Chart
How To Multiple Copies
EXERCISES
Exercise - Format Worksheet
Exercise - Creating Chart
Exercise - Setting Up Page and Print
Microsoft Stand out 2002 Training Instructions
Table of Contents: Module 3
VALIDATING, PROTECTING, AUDITING FORM AND Templet
Using Data Validation
How To Validate Data Input
How To Compose Data Input Message
How To Create Error Alert Message
Creating New Book Exploitation Templet
How To Create A New Book Exploitation Built-In Templet
How To Create A New Templet
How To Create New Book From Own Templet
How To Edit The Templet
Protecting Worksheet Style And Content
How To Protect The Worksheet
How To Unprotect The Worksheet
How To Change Cell For Redaction In Protected Sheet
How To Hide Cell Formula In Protected Sheet
How to Protect Book Content
How To Protect The Book Structure
How To Unprotect The Book Structure
Protecting Your Book From Unauthorized Users Access
How To Set Watchword To Open
How To Move out Watchword To Open
How To Set Watchword To Modify
Auditing Worksheets And Tracing Cell References
How To Find Precedents Cells
How To Find Dependent Cells
How To Hide All The Arrows
Tracing Errors
How To Circle And Move out Circle For Invalid Data
WORKING WITH ADVANCE FORMATTING, STYLE AND OUTLINING
Customizing Data Appearance With Advance Format
How To Use Build-In Number Formats
How To Custom Number Format
How To Custom Date Format
Using Conditional Format
How To Use Conditional Format
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 Book
Using Data Outlining
How To Create An Outline Mechanically
How To Move out Outline
How To Create Outline Manually
How To Use Subtotal To Create Outline
How To Show / Hide Details Exploitation Outline Symbols
How To Move out Subtotal
WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS
Managing Data in Multiple Worksheets
How To Choice Adjacent Worksheets
How To Choice Non-Adjacent Worksheets
How To Enter Data Into Multiple Worksheets
How to Use 3-D Formula Across Worksheet
How To Enter 3-D Formula Across Worksheets
How To Enter 3-D Formula Across Worksheets Exploitation Function
Using Range Name
How To Define A Range Name
How To Define A 3-D Range Name Exploitation 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 Some Workbooks
How To Consolidate Data
How To Come Or Copy Worksheets to Another Book
How to link information from some worksheets and book
How To Link Information Exploitation Copy And Paste Link
How To Update Link
USING ADVANCE FUNCTIONS
Using Fiscal Functions
How To Use PMT Function
How To Use ABS Function
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/Hide Comment Indicators
How To Edit And Delete Comments
Sharing Workbooks
How To Change Book Sharing
How To Disable Book Sharing
How To Copies Of Shared Book
How To Track Changes In Shared Book
How To Accept Or Reject Changes
EXERCISES
Exercise - Validating, Protecting, Auditing Form And Templet
Exercise - Exploitation Advance Formatting, Style And Outlining
Exercise - Working With Multiple Worksheets And Workbooks
Exercise - Exploitation Advance Functions
Exercise - Exploitation Workgroup Features
Microsoft Stand out 2002 Training Instructions
Table of Contents: Module 4
CREATING POWERFUL Information
Creating Information
How To Create Information Field
How To Add Records Manually
How To Add New Record Exploitation A Built-In Data Form
Managing Record in Information
How To Search For The Record Exploitation Data Form
How To Edit / Delete The Record Exploitation Data Form
Sorting Records
How To Perform Simple Sort
Using AutoFilter
How To Change / Disable AutoFilter
How To Apply / Move out The Criteria In The Information Exploitation AutoFilter
How To Customize Criteria In AutoFilter
How To Use Wildcard In Criteria
Using Advance Filter
How To Define The Criteria Range Example Of The Criteria Range
How To Use The Advance Filter Command
Using Simple Information Functions
How To Find The Sum Of Specific Records Exploitation 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 Search Value For Exact Match
How To Use The Nearest Match For The Search Value
CREATING PIVOT TABLE AND ANALYZING DATA
Creating Pivot Table
How To Create A Pivot Table
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 Move out 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 Another 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 Resolution
How To Use Goal Seek
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 Cryptography
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 Exportation DATA
Importing / Exportation Data
How To Use Text Import Wizard
How To Export Data To A Document
How To Copy Data From Another Applications
How To Insert Objects
EXERCISES
Exercise - Creating Powerful Information
Exercise - Creating Pivot Table And Analyzing Data
Exercise - Automating Routine Tasks With Macros
Exercise - Importation And Exportation Data
