Lotus 1-2-3
The spreadsheet that started it all offers powerful new ways to work with numbers. Check out 1-2-3 "web tables" that let you bring in live web-info and perform analysis on it; SmartLabels and SmartFill --
features that know what you want to do even before you type in the commands.
|
Lotus 1-2-3 Millennium (Set of 5 CDs) Intro/Interm/Adv/Formulas & Functions, Macros & Charts Details
|
L205232
|
$199.95
|
|
Lotus 1-2-3 Millennium Edition Training CDs Currculum |
|
Lotus 1-2-3 Millennium Introduction
Learn how to identify and use the components of the 1-2-3 screen, customize the workspace, create and modify worksheets and use the Range selector. Use Formulas, add color to cells,
wrap text in a cell, use the Function selector, copy an entire worksheet, spell check a workbook, preview and print a worksheet and format numbers.
Topics Covered Include:
Discussing options in the Welcome box
Discussing shortcut keystrokes
Defining worksheets/workbook
Customizing the workspace
Learning the components of the 1-2-3 screen
Showing/Hiding SmartIcon bars
Creating worksheets
Formatting text
Deleting worksheets
Saving a file
Moving around in a worksheet
Combining data
Entering text
Explaining range
Renaming a worksheet
Selecting cells
Inserting a row
Using the Range Selector
Sizing columns
Selecting an entire row/column
Clearing a cell
Centering/Aligning data over a range
Summing/Adding cells
Using the Function Selector
Adding color to cells
Copying an entire worksheet
Wrapping text in a cell
Spell checking a workbook
Entering a formula
Previewing/Printing a worksheet
Copying formulas
Formatting numbers
Lotus 1-2-3 Millennium, Intermediate
After learning the material in Learning Lotus 1-2-3 Millennium Intermediate, you'll not only be able to create your own spreadsheets, but you'll also know how to enhance the appearance of
your data and protect it. You'll learn how to modify grid lines, move a worksheet, split a worksheet window, align and rotate text, change text properties and format columns and rows.
You'll also be able to create and modify styles, protect and lock worksheets and workbooks, use SmartMaster templates, create and modify charts, create and size a map and use drawing tools.
Topics Covered Include:
Hiding/Showing grid lines
Changing the color of grid lines
Changing the display size
Moving a worksheet
Splitting the Worksheet Window
Aligning data
Rotating text
Changing text properties
Freezing a column
Freezing rows
Editing cell data
Unfreezing a row
Applying a border
Using/Explaining SmartLabels
Displaying/Using the Formatting SmartIcon bar
Adding a designer frame
Copying/Applying formatting
Adding a drop shadow/pattern/pattern color
Creating a Named Style
Applying a Named Style to a cell
Redefining a Style
Deleting a Named Style
Viewing Style Gallery options
Applying a style from the Gallery
Sorting data
Hiding/Showing cell data
Locking a worksheet
Unlocking a worksheet
Making a range of cells unprotected
Locking a workbook
Unlocking a workbook
Demonstrating password protection
Discussing SmartMaster templates
Creating an invoice from a SmartMaster
Entering data for a invoice
Entering dates
Viewing/Changing date formats
Explaining how 1-2-3 interprets dates
Using the Date function
Creating a chart from data
Resizing a chart
Selecting components of a chart
Changing the chart type
Changing a chart title
Referencing a cell for a title
Creating/Sizing a map
Using a Drawing tool
Lotus 1-2-3 Millennium--Advanced
Learn to create and work with named ranges, versions, databases or query tables as well as macros. You'll also learn how to embed data and make changes to it. Using 123's Internet
tools, you'll be able to create hyperlinks to a Web site, use data from the Internet in your own spreadsheet, and convert a range of data to a Web page.
Chapter 1 - Named Ranges
Getting Started
Naming a Range
Creating a New Named Range
Using the Navigator Button
Using Named Ranges in Formulas
Displaying a Range Name for Cells
Deleting a Named Range
Saving Our Work
Chapter 2 - Creating and Using Versions
What is a Version
Creating a Version
Using a Blank Version
Displaying Versions
Renaming a Version
Renaming Another Version
Creating a Version Group
Making a Comment
Creating a Version Report
Chapter 3 - Working with Databases and Query Tables
The Database Table
Opening/Viewing a Database Table
Discussing Guidelines
Fixing Our Database
Creating a Query Table
Using the Query Table Assistant
Setting Up the Query Table
Naming a Query Table
Sorting Query Table Records
Finding/Displaying Specific Records
Using the Find Assistant
Chapter 4 - Using Macros and Embedding Objects
Using Macros
Running a Macro
Discussing Macros
Creating/Recording a Macro
Discussing Embedded Objects
Embedding Data
Embedding an Approach File
Editing Embedded Data
Chapter 5 - Internet Options
Displaying Internet Tools
Using Internet Tools
Discussing the Web Table
Creating a Web Table
Converting Data to Web Pages
Viewing Our Work
Lotus 1-2-3 Millennium--Formulas and Functions
Covers a variety of formulas and functions ranging from financial to statistical. You will also become familiar with and be able to use Regression, What If tables, and the Backsolver to analyze data
Chapter 1 - Reviewing Mathematic Principles
Opening an Existing Workbook
Reviewing Arithmetic Operators
Mathematical Order of Equations1-2-3's Order of Precedence
Overriding Order of Precedence
Reviewing Mathematical Terms
Chapter 2 - Writing/Using Formulas
Guidelines for Entering Formulas
Entering Formulas
Copying Formulas
Explaining Cell References
Predefined SmartLabels
Using SmartLabels
Disabling SmartLabels
Editing DataMoving Data
Chapter 3 - Functions
Explaining Parts of a Function
Using Logical Functions
Logical Function Arguments
Discussing Text Formulas
Adding Functions to the Menu
Chapter 4 - Demonstrating Functions
Using the Average Function
Using the Round Function
Using the Convert Function
Using the Payment Function
Working with Interest Rates
Explaining Interest Rates
Using the Term and FV Functions
Chapter 5 - Analyzing Data
Using Frequency Distribution
Using Regression Analysis
Predicting Values
Setting Up a What If Table
Using Backsolver
Lotus 1-2-3 Millennium--Macros and Charts
Learn to create charts and maps as visual references for your data that will not only enhance it, but also present it in an easy to understand format. Macros and scripts will make your
day-to-day tasks in spreadsheets easier to perform.
Chapter 1- Outlining a Workbook
Discussing 1-2-3 Macros and Charts
Exploring the 1-2-3 Workspace
Outlining a Workbook
Demoting Columns
Demoting Rows
Expanding an Outline
Removing an Outline
Chapter 2- Working with Charts and Maps
Creating a Chart
Moving a Chart
Choosing a Chart Type
Customizing a Chart
Altering the Chart Legend
Creating/Saving a Chart Style
Creating a Map
Customizing a Map
Creating/Adding a Map Pin Character
Chapter 3- Using/Demonstrating Macros
Parts of a Macro
Using Macros
Running a Macro
Editing a Macro
Copying a Macro
Running a Macro on Other Workbooks
Using More Macros
Debugging Macros
Naming Macros
Chapter 4- Using LotusScript
Discussing LotusScript
Recording a Script
Examining the Script Editor Window
Editing a Script
Running a Script
Creating a Script Button
|
