|
Training
Materials for:
Windows Vista
Windows XP
Microsoft Word 2007
Microsoft Excel 2007
PowerPoint 2007
Microsoft Access 2007
Internet
Explorer 7
Outlook 2007
Expression Web
Microsoft Project
Microsoft Publisher
Microsoft FrontPage
Microsoft Visio
Computer
Concepts
ECDL / ICDL
Downloads
PLUS MANY MORE ...
|
Lotus 123 V5 (for Windows)
Foundation Level Training Course
Courseware Training Manual
1. Lotus 123 - A First Look
- Starting 123
- The 123 Tutorial
- Help Using the Button Bar
- The Lotus 123 Screen Window
- Getting Help
- The 123 Edit Line
- Lotus 123 SmartIcons
- Alternative SmartIcons
- Worksheet Tabs
- The Lotus 123 Status Bar
- Starting Lotus 1-2-3
2. Building Spreadsheets
- Entering Data
- Editing Data
- Moving Data
- Copying Data
- Inserting and Deleting Rows and Columns
- Using Formulas
- Copying and Moving Formulas
- Recalculating Formulas
- Formatting Data
3. 123 Worksheet Techniques
- Selection Techniques
- Manipulating Rows or Columns
- Naming Ranges
- The Go To Command
- Using the Navigator to go to a Named Range
- Filling a Range With a Series
- Using Find & Replace
- Spell Checking a Worksheet
4. Lotus 123 - The Basics
- Creating, Opening and Saving Files
- Password Protection Issues
- Multiple Worksheets Within a Single File
- Creating and Deleting Worksheets Within a Single File
- Viewing Multiple Worksheets within a Single File
- Working With Multiple Files - Tilling and Cascading
- What are SmartMasters?
- Creating an Invoice Using a SmartMaster
5. Printing From Lotus 123
- General Windows Printing Issues
- Printing the Current Worksheet
- Print Previewing
- Page Breaks
- The Page Setup Dialog Box
- Page Orientation
- Page Margins and Centering Your Print on the Page
- Page Headers and Footers
- Controlling the Size of Your Printed Data
- Printing Titles
6. Worksheet Formatting
- Modifying Font Types and Attributes
- Number Formatting
- Cell Contents Alignment
- Modifying Column Width and Row Height
- Adding Borders and Changing Colors/Patterns
- Quick Formatting Using the Right Hand Mouse Button
- Named Styles
- The Gallery
7. 123 Databases
- What is a Database?
- Queries
- Using Forms, and ‘Working Together’ With Lotus Approach
8. Manipulating Charts Within 123
- What is a Chart?
- Creating a Chart
- Customizing a Chart Title
- Customizing the Chart Axis Titles
- Customizing a Chart Legend
- Scaling and Moving a Chart
- Changing the Chart Type
- Customizing Chart Lines and Colors
- Printing Charts
9. 123 Calculations - Formulae and Functions
- What is a Formula?
- Numeric Formulas
- Text Formulas
- Logical Formulas
- How to Use Formulas
- Entering Values Manually or Using the Mouse
- Relative and Absolute Formulae
- Using @Functions
|
