|
Training materials for::
Windows Vista
Windows 2000 / XP
Microsoft Word
Microsoft Excel
PowerPoint
Microsoft Access
Internet
Explorer
Outlook
Microsoft Project
Microsoft Publisher
Microsoft FrontPage
Microsoft Visio
 Expression
Web
Computer
Concepts
ECDL / ICDL
Downloads
PLUS MANY MORE ...
|
Microsoft Excel 97 Courseware
Intermediate Level Training Course
Courseware Training Manual
1. Worksheets, a further look
- Renaming worksheets
- Deleting and inserting worksheets
- Finding files
- Displaying other toolbars
- Customizing the look of the toolbars
- Freeze panes
- Grouping and ungrouping worksheets
- The series command
2. Further formatting techniques
- Conditional formatting
- Creating new styles based on existing cell formatting
- Using colors in Excel 97
- Using colors based on values
- Gridlines
- Hiding data and re-displaying data
3. Further functions
- What are functions?
- Using paste function
- The if( ) function
- Data validation functions
- The hlookup / vlookup functions
- A sample hlookup
- The choose function
- Entering a choose function
- The date functions
- Mathematical date functions
- Time functions
- Text manipulation functions
4. Database and list management
- What is a database?
- Excel 97 databases
- Database terminology
- Creating, editing and navigating a database
- Sorting an internal Excel 97 database
- What is autofilter?
- Filtering data
- Top 10 autofilter
- Advanced filtering
- Totaling and manipulating filtered data
- Creating subtotals
- Using data forms
- The Excel 97 data form
5. Customizing charts
- The chart wizard
- Adding and removing data
- Changing data by dragging and dropping columns
- Formatting the chart area
- Chart formatting - legends
- Chart formatting - axis
- Chart formatting - the plot area
- Chart formatting - gridlines
- Chart formatting - the data series
6. Drawing and pictures
- Drawing lines, boxes, ovals and arcs
- Using autoshapes
- Creating text boxes
- Pictures
- Bring to front/send to back
- Grouping and un-grouping objects
7. Excel 97 and other applications
- Using the conversion feature
- Cut, copy and paste - using the clipboard
- Using paste special
- OLE - embedding vs. Linking
- Linking data from other worksheets
- Linking data from Word
- Linking data to Word
Microsoft Office 2007 Courseware materials
|
