Lotus 123

CBIT Canadian Beaver Training Ottawa
Ottawa, Ontario, Canada

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' Module 0: Working with Lotus 1-2-3
| Starting 1-2-3
Using the Welcome To 1-2-3 Dialog Box
Working with 1-2-3 Windows
Defining Spreadsheet Terms
Moving the Cell Pointer
Using the Infobox


| Module 1: Working with Workbooks
| Creating and Closing a Workbook
Entering Data
Entering Labels and Values Into a Sheet
Saving a New Workbook
Opening and Saving An Existing Workbook
Editing and Deleting Cell Data
Using the Undo Feature


| Module 2: Working with Ranges
| Defining Cell Ranges
Selecting a Range and a Non-adjacent Range
Entering Data Into a Range
Using Smartfill


| Module 3: Creating Simple Formulas
| Using Formulas and Functions
Using the Sum Smarticon
Using Autototal
Using the @function Selector
Entering a Formula


| Module 4: Copying and Moving Data
| Copying and Pasting Data
Filling a Range
Cutting and Pasting Data
Using Drag and Drop
Using Absolute References


| Module 5: Using Page Setup and Printing
| Previewing a Sheet
Zooming the Preview Window
Scrolling Pages in the Preview Window
Viewing Multiple Pages
Changing Page Setup Options and the Page Orientation
Adding a Header and Footer
Formatting Headers and Footers
Printing Grid Lines
Printing the Current Sheet


| Module 6: Formatting Values and Text
| Applying and Clearing Number Formats
Changing the Number of Decimal Places
Changing the Font
Changing the Font Size
Changing the Font Color
Using Automatic Formatting
Adding Font Attributes


| Module 7: Working with Columns and Rows
| Selecting Columns and Rows
Hiding and Unhiding Columns and Rows
Inserting and Deleting Columns and Rows
Changing Column Width and Row Height
Fitting To the Largest Entry
Fitting To the Widest Number


| Module 8: Working with Cell Alignment
| Changing Cell Alignment and Vertical Alignment
Resetting Default Alignment
Centering Text Across Columns
Wrapping Text
Rotating Cell Entries


| Module 9: Formatting Cells
| Adding Cell Borders and Patterns
Copying and Clearing Styles
Using the Style Gallery


| Module 10: Documenting a Sheet
| Displaying Formula Markers
Adding a Note To a Formula
Printing Formulas
Adding and Printing Cell Comments


| Module 11: On-line Help
| Using Help
Ask the Expert
Using Help Topics Dialogue Box
Using Index
Using Microsoft Excel Menu Finder

...''

Elements of this syllabus are subject to change.

Phone:613 742-6800

School Address/Venue(s):

CBIT Canadian Beaver Training Ottawa
214 Montreal Rd
Suite 100
Ottawa, Ontario
K1L 8L8
Canada

Jobs & Resumes: Ottawa
Houses & Roommates: Ottawa
Travel Agencies: Ottawa

Search other schools for Lotus 123 training resources.

Corel Bryce
Corel Designer
Corel Draw
Corel Knockout
Corel Painter
Corel Presentations
Corel Ventura
Corel Wordperfect
Crystal Reports
Approach Millennium
Lotus Freelance Graphics Millennium
Lotus Wordpro
Access 2007
Excel 2007
Infopath 2007
Project 2007
Onenote 2007
Outlook 2007
Powerpoint 2007

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.