|
Hiding and showing data
The Draw workspace
Positioning objects
The basic drawing shapes
Drawing geometric shapes
Selection modes
Selecting objects
Moving and dynamically adjusting an object’s size
Editing objects
Special effects
Combining multiple objects
Pictures and 3D objects
Defining relationships
Creating a database form
Accessing other data sources
Entering data in a form
Creating queries
Creating reports
Exporting to PDF
Creating a simple macro
Creating a macro
Sometimes the macro recorder fails
Macro organization
Writing macros without the recorder
Finding more information
Customizing menu content
Customizing toolbars
Assigning shortcut keys
Using extensions
History and community
License, open source, OpenDocument
|
Using frames for page layout
Creating headers and footers
Example: Creating a simple list style
Positioning graphics within the text
Arranging, anchoring, and aligning
Examples of wrapping
Adding captions to graphics
Graphic file types supported
Creating a form letter
Printing mailing labels
Printing envelopes
Using the Mail Merge Wizard to create a form letter
Alphabetic indexes
Customizing index entries
Customizing the appearance of an index
Creating a bibliographic database
Adding a reference (citation) into a document
Formating the bibliography
Recommended method for creating master documents
Defining your own numbering sequences
Developing conditional content
Using input fields and input lists
Example: a simple form
Accessing data sources
Advanced form customization
Customizing menu content
Customizing toolbars
Assigning shortcut keys
Adding functionality with extensions
|
Validating cell contents
Autoformat, themes, conditional formatting
Hiding and showing data
Finding and replacing in Calc
Creating a chart
Editing charts
Formatting charts
Formatting 3D charts
Using the Object Properties dialog
Resizing and moving the chart
Gallery of chart types
Modifying styles
Drawing tools
Positioning graphics
Supported file types
Exporting to PDF
Creating formulas
Using functions
Finding and fixing errors
Examples of functions
Using regular expressions in functions
Example: Frequency distribution
Layout and grouping of results
Sorting, drilling, filtering, refreshing
Multiple data fields
GETPIVOTDATA
Consolidating data
Creating subtotals
Using scenarios
Multiple operations
Goal seek
Solver
Using multiple sheets
Referencing other sheets
Referencing other documents
Hyperlinks and URLs
Linking to external data
Embedding spreadsheets
Using the macro recorder
Write your own functions
Using a macro as a function
Passing arguments to a macro
Accessing cells directly
Sorting
Associating a range to a name
Sorting data
Filters
Advanced filters
Calc functions similar to database functions
Using formulas to find data
Address, Indirect, Offset, Index
Database-specific functions
Customizing AutoCorrect functions
Customizing the user interface
Adding functionality with extensions
|
Inserting text
Formatting text
Formatting characters
Formatting paragraphs
Creating an image map
Managing the Gallery themes
Using spreadsheets in Impress
Inserting a chart
Inserting other objects
Modifying slides
Adding and formatting notes
Creating handouts
Using slide transitions
Using slide animation effects
Controlling printing
Exporting to PDF
Choosing options for Impress
Customizing the user interface
Adding functionality with extensions
|
