Interactive Training CD-ROM Courseware for Excel 95 Intermediate

USING EXCEL FOR WINDOWS 95
INTERMEDIATE

Netscape 4.05 & earlier & Microsoft IE 4.5 for Macintosh Y2K Browser Bug

Call Us at 317-881-3826

Click here:

Changing Worksheet Views

Viewing A Worksheet

Splitting A Screen

Using Scroll Bars To Move In A To Worksheet

Discussing Different Parts Of The Worksheet

Removing Splits From A Window

Freezing Frames Automatically

Hiding Columns / Unhiding Columns

Hiding Rows / Unhiding Rows

Inserting One Or More Columns, Rows Or Blank Cells

Creating And Using Names To Identify A Cell

Assigning A Name To A Cell Or Cell Range That Isn't A Row Or Column

Using Names To Create A Formula

Composing A Formula Out Of A Cell Name

Making A List Of Named Cells In The Worksheet & The Corresponding Addresses

Specifying Ranges Of Cells To Print

Defining & Using Range Names

Excel Functions

Absolute vs. Relative Cell References

Using Absolute Cell Reference

Using The IF Function To Test Conditions

Using The Payment Function

Using The Goal Seek Command

Using The VLOOKUP Function

Using Array Formulas

Using The Trend Function

Explaining The Trend Formula

Linking Excel Workbooks

Explaining Linking Formulas

Linking Worksheets In An Open File

Linking Worksheets Without Opening Them

Saving Source Workbooks

Working With Dependent Linked Workbooks

Closing All Open Workbooks At Once

Changing Workbook Appearance

Using The Options Dialog Box

Exploring The View Tab

Exploring The General Tab

Explaining Add-Ins

Using AutoFormat

Clearing AutoFormats

Opening Spell Check

Customizing Shade & Intensity Of Colors In The Color Palette

Copying Color From One Workbook To Another

Changing The Color Back To The Original

Arranging Windows

Choosing Tiled In The Arranging Windows Dialog Box

Customizing The Size And Location Of Windows

Opening A Group Of Workbooks In One Step By Saving Them As A Workspace File

Copying Between Worksheets

Chart Wizard

Creating A Chart As An Embedded Object Using The Chart Wizard

Viewing Different Radio Buttons

Adding Chart Titles For The Chart Heading & Each Axis

Sizing A Chart

Moving A Chart