For a full list of our products, please see our web site: www.nlearnseries.com

Copyright NLS Site
www.nlearnseries.com
Image
Image


SELECT A TOPIC



Excel 2000






Icons and Shortcuts
Cell formatting icons and shortcuts
Standard toolbar icons and shortcuts
 Customizing Toolbars and Menus
Customizing toolbars
Displaying hidden menu items
....
.
Selecting, Editing, and Formatting Selecting cells with the mouse
Selecting cells with the keyboard
Editing cell contents
Using Multiple Copy and Paste
Setting text position and alignment
 Working with Columns, Rows, and Cells
Navigational shortcuts
Clearing the #### signs from a cell
Working with columns
Working with rows
Preventing a column or row from scrolling out of view

....
.
Worksheets and Workbooks
Worksheets versus workbooks
Moving between worksheets
Switching between open workbooks
Inserting worksheets
Deleting worksheets
Naming or renaming worksheets
Hiding or unhiding worksheets
Changing worksheet sequence
Linking worksheets
Adjusting worksheet display settings		 Performing Calculations
Using AutoCalculate
Typing formulas
Sample formulas
Frequently used functions
Using the Formula Palette
Copying a formula in a range of cells
Formula tips
Switching to manual calculation
.... .
.
Working with Databases
Setting up a database
Using a data Form to add records
Finding records
Sorting a database
Filtering specific record groups
Creating subtotal reports
 Creating Charts
Creating column charts
Creating line charts
Creating pie charts
Working with pie charts
Creating a combination chart
Changing chart elements
....
.
 Working with Lists and Range Names
Using AutoFill to create quick lists
Using Range Names
Posting Excel Files Online
Posting workbooks and worksheets as Web pages
Working with Web pages
.
.
.
Printing
Specifying the print range
Adjusting printout settings