Table of Contents

Tutorial Section:

Lesson 1:  Getting Started With CliqCalc

• The CliqCalc Screen
• Refreshing the Screen
• Moving Around the Spreadsheet
• Getting Out of Trouble
• Scrolling
• Go To Command
• Entering Text and Numbers
• Getting Help

Lesson 2:  Creating a Worksheet

• Setting Titles and Using Data Entry
• Changing the Format of Numbers
• Saving Your Spreadsheet

Lesson 3:  Copying and the Use of Functions

• Inserting and Deleting Rows and Columns
• Copying Numbers, Text, and Formulas
• Using Functions
• Setting Titles
• Playing What-if Games

Lesson 4:  If-Then-Else Parameters

• Using if-then-else Function
• Creating a Parameter

Lesson 5:  Names and External Worksheets

• Using the Name Command
• Consolidate Spreadsheets
• Creating Dependent Worksheets

Lesson 6:  Playback Command and Multiple Windows

• Using the Playback Feature
• Playing with Windows

Lesson 7:  Exploring Some New Features

• Estimating Your Tax Liability
• Determining Your Status

Lesson 8:  Using CliqCalc for Data Management

• Creating a Database
• Practice Sorting
• Searching in a Database

Lesson 9:  CliqCalc and Word Processing

• Creating a Memo
• Exercising the Editing Commands

Lesson 10:  CliqCalc and Forms

• Creating an Invoice
• Printing the Invoice

Lesson 11:  Spreadsheet Designers - Beware

• Building Secure Spreadsheet Models
• Building More Efficient Spreadsheet Models
• Auditing Your Spreadsheet Models

Lesson 12:  More Capabilities to Learn

• Operators
• Functions
• Printing Spreadsheets
• Interfacing to UNIX

Reference Section:

Chapter 1:  Introduction

• How to Use this Manual
• The Worksheet
• The Screen
• Moving Around the Worksheet

Chapter 2:  Getting Started

• READY Mode
• MENU Mode
• EDIT Mode
• LABEL and VALUE Modes
• POINT Mode
• Other Modes
• Other Indicators

Chapter 3:  HELP

• Getting Your Terminal Working
• Exiting from CliqCalc
• Help Screens
• Other Helpful Information

Chapter 4:  Expressions and Values

• Numeric Constants
• Characters Strings
• Field References
• Operators
• Functions

Chapter 5:  Formats

Chapter 6:  Protection and Hiding Values

• Protection
• Hiding Values
• Other Protection Capabilities

Chapter 7:  Windows and Titles

• Windows
• Titles

Chapter 8:  Saving and Retrieving Files

• Worksheet Files
• Passwords
• Combining Files
• Saving Parts of a Worksheet

Chapter 9:  Printing Reports

• Print Sequence
• Print in Landscape Mode

Chapter 10:  Naming Regions of the Worksheet

• Creating an Invoice
• Printing the Invoice

Chapter 11:  Integration

Chapter 12:  Data Management

Chapter 13:  Macros and Keystroke Files

• Keystroke Files
• Macros
  • Macros That Use the Screen
  • Macros That Use the Keyboard
  • Macros That Control Flow
  • Macros That Process Data
  • Macros That Process Files

Chapter 14:  Command Descriptions

• / copy
• / data
  • / data distribution
  • / data fill
  • / data matrix
  • / data parse
  • / data query
  • / data regression
  • / data sort
  • / data table
• / file
  • / file combine
  • / file directory
  • / file erase
  • / file import
  • / file list
  • / file retrieve
  • / file save
  • / file view
  • / file xtract
• / move
• / print
  • Output Page
  • Print Sequence
  • / print align
  • / print page
  • / print line
  • / print range
  • / print go
  • / print quit
  • / print options
  • / print clear
• / quit
• / range
  • / range erase
  • / range format
  • / range input
  • / range justify
  • / range label
  • / range name
  • / range protect
  • / range transpose
  • / range unprotect
  • / range value
• / system
• / system filter
• / system import
• / system push
• / system clipboard
• / worksheet
  • / worksheet column
  • / worksheet erase
  • / worksheet global
  • / worksheet insert
  • / worksheet page
  • / worksheet status
  • / worksheet titles
  • / worksheet window
• READY Mode Commands
• Editing Commands

Chapter 15:  CliqCalc on the Desk

• Accessing CliqCalc Files from the Desk and Index
• New
• Open
• Print

Appendix A:  CliqCalc for Lotus 1-2-3 Users

• Getting Started
• Things Go Better with UNIX
• Saved Worksheets
• Some Final Advice

Appendix B:  CliqCalc Standard Defaults and Limitations

Appendix C:  Setting Up CliqCalc

• Your CliqCalc Profile

Appendix D:  Quick Reference

• List of Functions
• Initial Control Sequences
• Cursor Movement
• Special Keys
• Keystrokes for Macros
• Simple Macros for Programming
• Advanced Macro Commands
• Arithmetic and Logical Operators