Star Office
| StarOffice Writer New User | StarOffice Writer Intermediate | StarOffice Writer Advanced |
| StarCalc New User | StarCalc Intermediate | StarCalc Advanced |
| StarOffice Impress New User | StarOffice Impress Intermediate | StarOffice Impress Advanced |
| StarOffice Mail & Discussion | StarOffice Schedule | StarOffice Draw |
Getting started with StarOffice Writer
Starting StarOffice, Writer Exploring the Writer Screen, Customising the Workspace, View, Entering text into a document, Saving a document, Getting Help, Closing a document, Exiting StarOffice Writer
Working with Documents
Opening a document, Moving around in a document, Inserting new text, Correcting text, Printing a document, Preparing and printing, envelopes, Preparing and printing labels
Editing documents
Selecting text, Copying and moving text, Using the UNDO feature, Checking a document for Spelling errors, Using the Thesaurus, Checking a document for hyphenation
Formatting text
Applying bold, italics and underlining, Inserting special characters, Default options, Changing font and font sizes, Changing font colour and highlighting, Applying outline and shadow effects, Applying strikethrough and underline effects, Changing font capitalisation and character positioning
Formatting Paragraphs
Changing text alignment, Changing line spacing, Changing paragraph spacing, Indenting text, Adding paragraph borders, Inserting Tabs, Adding paragraph borders, Adding paragraph backgrounds
Formatting Pages
Changing margins, Altering page orientation, Adding page borders, Adding page backgrounds
StarOffice Writer Intermediate
Formatting paragraphs
Inserting line breaks, Altering paragraph text flow, Setting paragraph hyphenation, Inserting line numbering, Applying drop caps
Formatting Pages
Page Numbering, Inserting page breaks, Designating columns before entering text, Assigning columns to previously typed text, Resizing existing columns, Inserting column breaks, Working with sections
Bullets And Numbering
Bulleted Lists, Numbered Lists,
Working with Frames, Graphics and Objects
Inserting frames, Inserting a horizontal line, Inserting graphics and OLE objects, Inserting a plug-in, Inserting sounds and videos, Inserting an applet, Inserting a formula, Inserting a chart, Formatting frames, graphics and objects, Inserting captions
Tables
Creating a table, Modifying tables, Importing existing tables, Aligning cell text and data, Selecting Cells/Columns, Inserting Cells, Rows and Columns, Deleting Cells, Rows And Columns, Moving and Copying Cells, Rows and Columns, Adjusting Column Widths, Changing the Row Height, Calculating values in a table, Formatting numbers in a table, Sorting rows or columns, Altering the table format, Applying a table Autoformat, Adding a table caption, Converting text to tables, Converting tables to text, Protecting table contents
Mail Merge
Creating personalised form letters, Merge Labels, Merge envelopes, Merge invitations, Creating the Main Document, Constructing the Data File, Entering Data, Inserting Merge Fields
Paragraph Styles
What is a style?, Apply an existing style, Create a new style, Delete a style, Modifying styles, Copying styles, Transferring a style to the current document
Creating & Using Document Templates
Locating templates, Using existing templates, Modifying document templates, Create a new document template, Changing the standard template
Using document automation
Working with AutoText entries, Using auto-correct features, Applying auto-format functions, Using outline numbering, Inserting scripts, Working with Macros, Performing calculations in Text, Using the Microsoft Import AutoPilot
Reviewing, collaborating and merging documents
Finding and replacing text, Finding and replacing styles, Inserting notes in a document, Including document properties information, Merging multiple documents, Comparing documents, Recording changes to a document, Sending a document as an email
Working with Long Documents
Navigating long documents, Using bookmarks, Using cross referencing, Working with outlines and abstracts, Inserting notes, footnotes and endnotes, Indexes and table of contents, Using custom number sequences, Inserting captions, Creating a bibliography, Master documents
Creating Web Pages and other online documents
Working with Hyperlinks and Image Maps, Choosing a background colour of graphic, Adding graphics, charts and rulers, Inserting a floating frame and text frames, Inserting a scrolling text marquee, Adding sound and video, Creating interactive forms, Inserting headers, footers and fields, Printing an HTML document, Preparing your work for the web, Saving and publishing your page
Customising the Writer Environment
General options, Text document options, Configuring menus, Configuring the keyboard, Configuring the Status Bar, Configuring Toolbars, Configuring Events
Starting and Closing StarCalc
Creating a new spreadsheet, Closing a spreadsheet
The StarCalc Window
Title Bar, Menu Bar, Function Bar, Spreadsheet Object Bar, Main Toolbar, Formula bar, Show or Hide Toolbars, Status Bar, Scroll Bars, Spreadsheet tabs, Change a spreadsheet's name, Inserting sheets
Help
Help Agent, Tips, Help - Contents
Creating, Opening & Saving Spreadsheets
Create a new Spreadsheet, Open an existing Spreadsheet, Save a spreadsheet as a new file, Save changes to a spreadsheet
Inserting, Moving and Copying Cells and Data
Inserting rows and columns, Copy or Cut and Paste
Working with Numbers, Text, Dates and Times
Text, Numbers, Date and Time, Correcting mistakes, Selecting text and numbers, Aligning characters, Formatting numbers, Drag & Fill, AutoFill, AutoComplete, Formatting characters
Worksheet Calculations
Everyday Arithmetic, Mixed calculations, Circular references, Totals, Functions, Make decisions with the IF() function
Formatting Worksheets
Change column width, Change row height, Centre a heading across several columns, Apply Borders & Shading to cells, AutoFormat, Coloured text & background
Preparing to Print
Print Preview, Print What?, Page Setup
Printing
Cell Referencing
Using a Name, Naming a Cell or a Range, Navigation using range names, Absolute and Relative cell references, Absolute references, Making a cell reference absolute
IF() - Functions that make Decisions
IF(), Nested IF(), Nested AND, Using the AutoPilot, Function List
Editing Large Spreadsheets
Freeze Panes, View two parts of a sheet at the same time
Managing Data in Excel Lists
Creating a list, Adding records directly into a worksheet, Creating a calculated field, Sorting Data, Data Filtering, Criteria Operators, Grouping Data & Calculating Subtotals, Database statistical functions, Using SUMIF
Lookup Tables
Lookup Tables, VLOOKUP( )
Creating Charts
Introduction to charts, Source data layout, Chart components, Modifying charts
Custom Number Formats
Preset number formatting, Creating a custom number format, Delimiters
Using Styles
Create a new style by example, Creating or modifying a style
Protecting Cells, Worksheets & Workbooks
Protecting cells in a worksheet, Protecting a worksheet, Protecting a workbook, Unprotection