IBM Connections overview
What's new in IBM Connections?
Which app do I use?
Using the business card
Setting email notification preferences
Changing the display language
Configuring bidirectional text
Subscribing to feeds
What are @mentions and #hashtags?
What can external users do?
Using the rich text editor
Inserting an image with the rich text editor
Pasting an image
Inserting an iFrame with the rich text editor
Moderating content for the site
Moderating content before publishing it
Moderating published content that is flagged as inappropriate
Viewing metrics
Giving apps access to your data
Administrator help
IBM Connections Search
Searching IBM Connections
Advanced searching
Performing an advanced search
Advanced search options
Working with search results
Searchable content
My Content searches
Adding IBM Connections search to your browser
Product accessibility
Rich text editor keyboard shortcuts
Home page accessibility features
Search accessibility features
What's new in IBM Connections?
Which app do I use?
Using the business card
Setting email notification preferences
Changing the display language
Configuring bidirectional text
Subscribing to feeds
What are @mentions and #hashtags?
What can external users do?
Using the rich text editor
Inserting an image with the rich text editor
Pasting an image
Inserting an iFrame with the rich text editor
Moderating content for the site
Moderating content before publishing it
Moderating published content that is flagged as inappropriate
Viewing metrics
Giving apps access to your data
Administrator help
IBM Connections Search
Searching IBM Connections
Advanced searching
Performing an advanced search
Advanced search options
Working with search results
Searchable content
My Content searches
Adding IBM Connections search to your browser
Product accessibility
Rich text editor keyboard shortcuts
Home page accessibility features
Search accessibility features
Activities
Activities overview
What's new in Activities?
Starting an activity
Adding activity content
Adding an entry
Working with files
Getting the web address of an individual entry
Publishing attachments to Lotus Quickr
Adding a bookmark to an activity
Adding a to-do item
Working with activities
Editing an activity
Organizing activity content
Prioritizing activities
Tuning out an activity that does not interest you
Subscribing to an Activities feed to get automatic updates
Following activities
Copying an activity
Exporting activities
Searching activities
Filtering activities and entries by tags
Working with templates
Editing activity templates
Editing entry templates
Marking activity templates as favorites for easy access
Deleting activity templates
Updating members
Adding members to a stand-alone activity
Changing member roles in a community activity
Activities overview
What's new in Activities?
Starting an activity
Adding activity content
Adding an entry
Working with files
Getting the web address of an individual entry
Publishing attachments to Lotus Quickr
Adding a bookmark to an activity
Adding a to-do item
Working with activities
Editing an activity
Organizing activity content
Prioritizing activities
Tuning out an activity that does not interest you
Subscribing to an Activities feed to get automatic updates
Following activities
Copying an activity
Exporting activities
Searching activities
Filtering activities and entries by tags
Working with templates
Editing activity templates
Editing entry templates
Marking activity templates as favorites for easy access
Deleting activity templates
Updating members
Adding members to a stand-alone activity
Changing member roles in a community activity
Blogs
What are blogs?
What's new in Blogs?
Creating a blog
Creating a community blog
Who can see my blog? Creating public and restricted blogs
What is an Ideation Blog?
Using an Ideation Blog
Managing an Ideation Blog
What are tags and how do I use them?
Creating a blog entry
Adding an image to a blog posting
Adding a video to your blog post
Editing or deleting an entry
Using third-party blog editors to create entries for your blog
Posting a comment
Adding a bookmark from a web page
Notifying a user about a blog entry
Liking an entry
Flagging an entry as inappropriate
Finding a blog or blog entry
Subscribing to a Blogs feed
Following a blog
Managing your blog
Editing general blog settings
Managing blog entries
Managing blog comments
Viewing the hit count for your blog
Changing the look of your blog
How do I create an announcement?
Deleting a blog
Uploading a file to a blog
Adding links to your blog
Managing member permissions for a blog
Blogs roles and permissions
Resigning from a blog
What are blogs?
What's new in Blogs?
Creating a blog
Creating a community blog
Who can see my blog? Creating public and restricted blogs
What is an Ideation Blog?
Using an Ideation Blog
Managing an Ideation Blog
What are tags and how do I use them?
Creating a blog entry
Adding an image to a blog posting
Adding a video to your blog post
Editing or deleting an entry
Using third-party blog editors to create entries for your blog
Posting a comment
Adding a bookmark from a web page
Notifying a user about a blog entry
Liking an entry
Flagging an entry as inappropriate
Finding a blog or blog entry
Subscribing to a Blogs feed
Following a blog
Managing your blog
Editing general blog settings
Managing blog entries
Managing blog comments
Viewing the hit count for your blog
Changing the look of your blog
How do I create an announcement?
Deleting a blog
Uploading a file to a blog
Adding links to your blog
Managing member permissions for a blog
Blogs roles and permissions
Resigning from a blog
Communities
What is a community?
What's new in Communities?
Frequently asked questions in Communities
Browsing or searching for communities
Using the Communities business card
How do I join a community?
Joining communities
Accepting community invitations
Using the Recommendations app
Creating communities
Working with communities
Viewing members of a community
Following communities
Emailing your community
Getting the latest updates from your community
Viewing status updates from your community
Sharing a status message with the community
Sharing related communities with other members
Categorizing communities with tags
Leaving communities
How do I add community members?
Adding members to your community
Inviting people to join a community
Sending batch membership invitations
Resending community invitations as reminders to join
Revoking community invitations that are pending
Accepting membership requests
Importing multiple members into a community
Community membership roles
What can I do as a community owner?
What can I do as a community member?
What can I do as a non-member?
Adding apps to your Community
Communities apps
Working with community apps
Managing your communities
Moderating community content
Editing communities
Deleting communities that you own
Managing who can post status updates
Creating subcommunities
Accessing your subcommunities
Moving communities
Managing community membership
Exporting community membership
Customizing your community
Customizing the community Overview page
Customizing the community layout
Changing the community start page
Bookmarking important places
Adding a bookmark from a web page to a community
Searching a community for bookmarks
Working with community forums
Adding forums to a community
Removing community forums
Managing display settings in community forums
Browsing community forums
Adding topics to a community forum
Working with forum content
Adding files to a community
Sharing files with your community
Sharing folders with your community
Downloading files shared with a community
Viewing files shared with a community
Managing community files
Managing community folders
Managing deleted files
Managing access to community files
Working with galleries
Configuring a gallery to highlight community files and folders
Viewing thumbnail images of files in the community
Organizing media gallery files into folders and leveraging Files features
Working with rich content
Adding rich content pages to a community
Managing rich content pages
Working with community activities
Creating a community activity
Managing community activities
Working with a community blog
Adding a blog to your community
Creating a blog entry
Posting a comment
Managing your community blog
Using feeds
Working with feeds
Adding a feed to a community
Subscribing to a Communities feed to get automatic updates
Working with a community wiki
Adding a wiki to a community
Adding pages to a community wiki
Working with wiki pages
Working with deleted pages
Finding wiki pages
Managing a community wiki
Working with an Ideation Blog
Adding an Ideation Blog to your community
Posting ideas to an ideation blog
Managing your community's Ideation Blog
Using libraries
How do I add a library to my community?
Managing libraries
Managing a community library
Library roles and permissions
How do I manage a linked library?
How do I remove a library from my community?
How do I connect to an ECM server?
Adding files to a library
Viewing library files
Integrating Connections Content Manager libraries with IBM Docs
How do I edit files?
How do I edit file properties?
How do I copy or move files?
How do I delete library files?
Working with deleted files
How do I see information about library files?
What else can I do with library files?
Sharing library files and folders
How do I work with folders?
How do I work with file versions?
Working with draft files
Submitting files for review
Reviewing draft files
Document types
Library views
Scheduling community events
Viewing community events
Creating community events
Managing community events
Searching within a community
What is a community?
What's new in Communities?
Frequently asked questions in Communities
Browsing or searching for communities
Using the Communities business card
How do I join a community?
Joining communities
Accepting community invitations
Using the Recommendations app
Creating communities
Working with communities
Viewing members of a community
Following communities
Emailing your community
Getting the latest updates from your community
Viewing status updates from your community
Sharing a status message with the community
Sharing related communities with other members
Categorizing communities with tags
Leaving communities
How do I add community members?
Adding members to your community
Inviting people to join a community
Sending batch membership invitations
Resending community invitations as reminders to join
Revoking community invitations that are pending
Accepting membership requests
Importing multiple members into a community
Community membership roles
What can I do as a community owner?
What can I do as a community member?
What can I do as a non-member?
Adding apps to your Community
Communities apps
Working with community apps
Managing your communities
Moderating community content
Editing communities
Deleting communities that you own
Managing who can post status updates
Creating subcommunities
Accessing your subcommunities
Moving communities
Managing community membership
Exporting community membership
Customizing your community
Customizing the community Overview page
Customizing the community layout
Changing the community start page
Bookmarking important places
Adding a bookmark from a web page to a community
Searching a community for bookmarks
Working with community forums
Adding forums to a community
Removing community forums
Managing display settings in community forums
Browsing community forums
Adding topics to a community forum
Working with forum content
Adding files to a community
Sharing files with your community
Sharing folders with your community
Downloading files shared with a community
Viewing files shared with a community
Managing community files
Managing community folders
Managing deleted files
Managing access to community files
Working with galleries
Configuring a gallery to highlight community files and folders
Viewing thumbnail images of files in the community
Organizing media gallery files into folders and leveraging Files features
Working with rich content
Adding rich content pages to a community
Managing rich content pages
Working with community activities
Creating a community activity
Managing community activities
Working with a community blog
Adding a blog to your community
Creating a blog entry
Posting a comment
Managing your community blog
Using feeds
Working with feeds
Adding a feed to a community
Subscribing to a Communities feed to get automatic updates
Working with a community wiki
Adding a wiki to a community
Adding pages to a community wiki
Working with wiki pages
Working with deleted pages
Finding wiki pages
Managing a community wiki
Working with an Ideation Blog
Adding an Ideation Blog to your community
Posting ideas to an ideation blog
Managing your community's Ideation Blog
Using libraries
How do I add a library to my community?
Managing libraries
Managing a community library
Library roles and permissions
How do I manage a linked library?
How do I remove a library from my community?
How do I connect to an ECM server?
Adding files to a library
Viewing library files
Integrating Connections Content Manager libraries with IBM Docs
How do I edit files?
How do I edit file properties?
How do I copy or move files?
How do I delete library files?
Working with deleted files
How do I see information about library files?
What else can I do with library files?
Sharing library files and folders
How do I work with folders?
How do I work with file versions?
Working with draft files
Submitting files for review
Reviewing draft files
Document types
Library views
Scheduling community events
Viewing community events
Creating community events
Managing community events
Searching within a community
Files
Files overview
What's new in Files?
Using file sharing to collaborate with others
Understanding file access rights
Sharing files
Sharing folders
Limitations on files uploaded to a community
Uploading files
Working with files
Editing a file locally
Downloading a file
Using file tags
Using a file version
Locking files
Finding files
Removing files
Creating folders and subfolders
Adding files to folders
Working with folders
Finding folders
Tracking file and folder changes
Subscribing to a Files feed
Files overview
What's new in Files?
Using file sharing to collaborate with others
Understanding file access rights
Sharing files
Sharing folders
Limitations on files uploaded to a community
Uploading files
Working with files
Editing a file locally
Downloading a file
Using file tags
Using a file version
Locking files
Finding files
Removing files
Creating folders and subfolders
Adding files to folders
Working with folders
Finding folders
Tracking file and folder changes
Subscribing to a Files feed
Forums
What are Forums?
What's new in Forums?
Browsing forums
Creating forums
Adding forum topics
Creating a forum topic from a web page
Responding to forum topics
Working with forum topics
Editing forum topics
Moving forum topics
Deleting forum topics
Deleting responses to forum topics
Flagging forum content as inappropriate
Posting questions and answers to a forum
Posting questions to a forum
Answering questions in a forum
Working with attachments
Downloading attachments from forums
Managing forums
Forum moderation
Adding more owners to a forum
Pinning forum topics
Editing forums
Locking forums and forum topics
Locking forums to prevent users from adding topics or responses
Locking forum topics
Deleting forums
Searching forums
Following forums and forum topics
Subscribing to a Forums feed
What are Forums?
What's new in Forums?
Browsing forums
Creating forums
Adding forum topics
Creating a forum topic from a web page
Responding to forum topics
Working with forum topics
Editing forum topics
Moving forum topics
Deleting forum topics
Deleting responses to forum topics
Flagging forum content as inappropriate
Posting questions and answers to a forum
Posting questions to a forum
Answering questions in a forum
Working with attachments
Downloading attachments from forums
Managing forums
Forum moderation
Adding more owners to a forum
Pinning forum topics
Editing forums
Locking forums and forum topics
Locking forums to prevent users from adding topics or responses
Locking forum topics
Deleting forums
Searching forums
Following forums and forum topics
Subscribing to a Forums feed
Wikis
What are wikis?
What's new in Wikis?
How do I find wikis?
How do I create wikis?
How do I find wiki pages?
Editing other people's wiki pages
How do I create pages?
Using the rich text editor in Wikis
Adding a table of contents to a wiki page
Adding an image to a wiki page
Adding a video to your wiki page
How do I manage wiki members and access?
How do I recommend pages?
How do I comment on pages?
What happens to the original content when a page is edited?
Adding tags to Wikis
How do I track wiki and wiki page changes?
How does the trash work in wikis?
Subscribing to a Wikis feed
What are wikis?
What's new in Wikis?
How do I find wikis?
How do I create wikis?
How do I find wiki pages?
Editing other people's wiki pages
How do I create pages?
Using the rich text editor in Wikis
Adding a table of contents to a wiki page
Adding an image to a wiki page
Adding a video to your wiki page
How do I manage wiki members and access?
How do I recommend pages?
How do I comment on pages?
What happens to the original content when a page is edited?
Adding tags to Wikis
How do I track wiki and wiki page changes?
How does the trash work in wikis?
Subscribing to a Wikis feed
Connections Docs
Supported browsers
Important limits in Connections Docs
Publishing a version of a file
What if I have a file conflict?
Reverting to last version
Accessibility features for IBM Connections Docs
Working with documents
Creating and importing documents
Creating documents
Creating documents from Content Navigator
Changing the default file format of documents
Uploading documents to share
Opening existing documents in Connections Docs
Opening password-protected Word files
File compatibility and working with files
File formats that are supported in documents
Saving documents
Checking a document into a library from Connections Docs
Checking a document into Content Navigator from Connections Docs
Downloading a document
Sharing documents
Sharing documents with people or communities
Setting access levels for documents
Collaborating on documents in real time
Co-editing in real time in documents
About co-editing in documents
Co-editing with others in documents
Showing changes by each editor in a document
Collaborating by using Connections Chat in documents
Collaborating by using comments in documents
About comments in documents
Creating and acting on comments in documents
Viewing comments in documents
Searching comments in documents
Editing documents
Formatting text in documents
Setting font effects
Making text superscript or subscript
Setting font size
Aligning text
Indenting text
Adding bullets or numbers in documents
Copying and applying formatting
Creating multilevel lists in documents
Inserting bookmarks
Inserting links
Creating headers and footers
Creating a table of contents
Inserting fields in documents
Spell-checking documents
Searching in documents
Setting up paragraph properties
Setting up page properties
Working with images in documents
Inserting images in documents
Setting image properties in documents
Creating and editing tables in documents
Creating tables in documents
Changing table styles in documents
Setting table properties in documents
Setting background colors for table cells
Aligning text in table cells in documents
Adding rows and columns in tables
Merging or splitting table cells
Resizing tables in documents
Adding titles to tables in documents
Documents quick reference
Documents keyboard shortcuts
Working with spreadsheets
Creating and importing spreadsheets
Creating spreadsheets
Changing the default file format of spreadsheets
Uploading spreadsheets to share
Importing existing spreadsheets
Importing text files to spreadsheets
Creating spreadsheets from Content Navigator
Opening password-protected Excel files
File compatibility and exporting spreadsheets
File formats supported in spreadsheets
Saving spreadsheets
Checking in a spreadsheet to a library from Connections Docs
Checking a spreadsheet into Content Navigator from Connections Docs
Downloading a spreadsheets
Sharing spreadsheets
Sharing spreadsheets with people or communities
Setting access levels for spreadsheets
Collaborating on spreadsheets in real time
Co-editing in real time in spreadsheets
About co-editing in spreadsheets
Co-editing with others in spreadsheets
Showing changes by each editor in a spreadsheet
Collaborating with Connections Chat in spreadsheets
Collaborating by using comments in spreadsheets
About comments in spreadsheets
Creating and acting on comments in spreadsheets
Viewing comments in spreadsheets
Searching comments in spreadsheets
Changing the look of your spreadsheets
Changing indents in spreadsheets
Aligning text in spreadsheet cells
Changing fonts in spreadsheets
Changing colors in spreadsheets
Changing borders in spreadsheets
Changing row height or column width
Restoring default formatting to spreadsheet cells
Managing sheets in spreadsheets
Hiding and showing sheets in spreadsheets
Moving sheets in spreadsheets
Inserting sheets in spreadsheets
Sheets and cells protection
Formatting numbers
Entering and editing data
Data editing basics
Finding and replacing cell contents
Adding a hyperlink in a cell
Removing the link from a hyperlink
Using autofill to fill a range
Moving data by dragging in spreadsheets
Merging or splitting sheet cells
Spell-checking spreadsheets
Working with images in spreadsheets
Inserting images in spreadsheets
Moving and resizing images in spreadsheets
Setting image properties in spreadsheets
Working with charts in spreadsheets
Chart types in spreadsheets
Column charts
Bar charts
Pie charts
Area charts
Line charts
Scatter charts
Inserting charts in spreadsheets
Moving and resizing charts in spreadsheets
Copying charts in spreadsheets
Changing data source ranges
Setting chart properties in spreadsheets
Managing data ranges
Sorting data
Using instant filters
Adding data validation in spreadsheets
Freezing rows and columns in spreadsheets
Hiding rows and columns
Showing rows and columns
Referencing cells from another sheet
Copying data and images in spreadsheets
Naming a range
Finding or editing named ranges
Removing a named range
Relative and absolute references
Using formulas in calculations
About formulas and functions
List of functions
Grouped by category
Array functions
Inline array constants in formulas
Date and time functions
Engineering function
Information functions
Logical functions
Mathematical functions
Spreadsheet functions
Statistical functions
Text functions
ABS function
ACOS function
ACOSH function
ADDRESS function
AND function
ASIN function
ASINH function
ATAN function
ATAN2 function
ATANH function
AVERAGE function
AVERAGEA function
BASE function
BIN2DEC function
BIN2HEX function
BIN2OCT function
CEILING function
CHOOSE function
CHAR function
CODE function
COLUMN function
COLUMNS function
COMBIN function
CONCATENATE function
CONVERT function
COS function
COSH function
COUNT function
COUNTA function
COUNTBLANK function
COUNTIF function
DATE function
DATEDIF function
DATEVALUE function
DAY function
DAYS function
DAYS360 function
DEC2BIN function
DEC2HEX function
DEC2OCT function
DEGREES function
DOLLAR function
ERRORTYPE function
EVEN function
EXP function
EXACT function
FACT function
FALSE function
FIND function
FIXED function
FLOOR function
FORMULA function
FREQUENCY function
HEX2BIN function
HEX2DEC function
HEX2OCT function
HLOOKUP function
HOUR function
HYPERLINK function
IF function
INDEX function
INDIRECT function
INT function
ISBLANK function
ISERR function
ISERROR function
ISEVEN function
ISFORMULA function
ISLOGICAL function
ISNA function
ISNONTEXT function
ISNUMBER function
ISODD function
ISREF function
ISTEXT function
LARGE function
LEFT function
LEN function
LENB function
LN function
LOG function
LOG10 function
LOOKUP function
LOWER function
MATCH function
MAX function
MEDIAN function
MID function
MIN function
MINUTE function
MMULT function
MOD function
MODE function
MONTH function
N function
NA function
NETWORKDAYS function
NOT function
NOW function
OCT2BIN function
OCT2DEC function
OCT2HEX function
ODD function
OFFSET function
OR function
PI function
POWER function
PRODUCT function
PROPER function
RADIANS function
RAND function
RANDBETWEEN function
RANK function
REPLACE function
REPT function
RIGHT function
RIGHTB function
ROMAN function
ROUND function
ROUNDDOWN function
ROUNDUP function
ROW function
ROWS function
SEARCH function
SECOND function
SHEET function
SIN function
SINH function
SMALL function
SQRT function
STDEV function
STDEVP function
SUBSTITUTE function
SUBTOTAL function
SUM function
SUMIF function
SUMPRODUCT function
T function
TEXT function
TIME function
TIMEVALUE function
TODAY function
TRIM function
TRUE function
TRUNC function
TYPE function
UPPER function
VALUE function
VLOOKUP function
VAR function
VARA function
VARP function
VARPA function
WEEKDAY function
WEEKNUM function
WORKDAY function
YEAR function
Spreadsheets quick reference
Spreadsheets keyboard shortcuts
Working with presentations
Creating and uploading presentations
Creating presentations
Changing the default file format of presentations
Uploading presentations to share
Opening existing presentations in Connections Docs
Creating presentations from Content Navigator
File compatibility and working with files
File formats that are supported in presentations
Saving presentations
Checking a presentation into a library from Connections Docs
Checking a presentation into Content Navigator from Connections Docs
Downloading a presentation
Sharing presentations
Sharing presentations with people or communities
Setting access levels for presentations
Collaborating on presentations in real time
Co-editing in real time in presentations
About co-editing in presentations
Co-editing with others in presentations
Showing editor changes in a presentation
Collaborating with Connections Chat in presentations
Collaborating by using comments in presentations
About comments in presentations
Creating and acting on comments in presentations
Viewing comments in presentations
Searching comments in presentations
Formatting slides
Changing fonts in presentations
Changing line spacing in a slide
Inserting shapes
Selecting and moving objects
Copying and pasting objects
Rotating objects on a slide
Arranging the objects order
Distributing objects in a slide
Setting transparency for objects in presentations
Adding numbers or bullets to slides
Adding a link in a slide
Applying a slide layout
Spell-checking presentations
Printing presentations
Working with images in presentations
Inserting graphics in presentations
Moving and resizing images in presentations
Working with slides
Playing slide shows
Applying transitions between slides
Deleting slides
Adding slides
Moving slides
Duplicating slides
Working with tables in presentations
Creating tables in presentations
Adding rows and columns in presentations
Moving rows and columns in presentations
Resizing rows and columns in presentations
Aligning text in cells
Changing table styles in presentations
Defining table headers in presentations
Editing speaker notes
Presentations quick reference
Presentations keyboard shortcuts
Glossary
Notices
Supported browsers
Important limits in Connections Docs
Publishing a version of a file
What if I have a file conflict?
Reverting to last version
Accessibility features for IBM Connections Docs
Working with documents
Creating and importing documents
Creating documents
Creating documents from Content Navigator
Changing the default file format of documents
Uploading documents to share
Opening existing documents in Connections Docs
Opening password-protected Word files
File compatibility and working with files
File formats that are supported in documents
Saving documents
Checking a document into a library from Connections Docs
Checking a document into Content Navigator from Connections Docs
Downloading a document
Sharing documents
Sharing documents with people or communities
Setting access levels for documents
Collaborating on documents in real time
Co-editing in real time in documents
About co-editing in documents
Co-editing with others in documents
Showing changes by each editor in a document
Collaborating by using Connections Chat in documents
Collaborating by using comments in documents
About comments in documents
Creating and acting on comments in documents
Viewing comments in documents
Searching comments in documents
Editing documents
Formatting text in documents
Setting font effects
Making text superscript or subscript
Setting font size
Aligning text
Indenting text
Adding bullets or numbers in documents
Copying and applying formatting
Creating multilevel lists in documents
Inserting bookmarks
Inserting links
Creating headers and footers
Creating a table of contents
Inserting fields in documents
Spell-checking documents
Searching in documents
Setting up paragraph properties
Setting up page properties
Working with images in documents
Inserting images in documents
Setting image properties in documents
Creating and editing tables in documents
Creating tables in documents
Changing table styles in documents
Setting table properties in documents
Setting background colors for table cells
Aligning text in table cells in documents
Adding rows and columns in tables
Merging or splitting table cells
Resizing tables in documents
Adding titles to tables in documents
Documents quick reference
Documents keyboard shortcuts
Working with spreadsheets
Creating and importing spreadsheets
Creating spreadsheets
Changing the default file format of spreadsheets
Uploading spreadsheets to share
Importing existing spreadsheets
Importing text files to spreadsheets
Creating spreadsheets from Content Navigator
Opening password-protected Excel files
File compatibility and exporting spreadsheets
File formats supported in spreadsheets
Saving spreadsheets
Checking in a spreadsheet to a library from Connections Docs
Checking a spreadsheet into Content Navigator from Connections Docs
Downloading a spreadsheets
Sharing spreadsheets
Sharing spreadsheets with people or communities
Setting access levels for spreadsheets
Collaborating on spreadsheets in real time
Co-editing in real time in spreadsheets
About co-editing in spreadsheets
Co-editing with others in spreadsheets
Showing changes by each editor in a spreadsheet
Collaborating with Connections Chat in spreadsheets
Collaborating by using comments in spreadsheets
About comments in spreadsheets
Creating and acting on comments in spreadsheets
Viewing comments in spreadsheets
Searching comments in spreadsheets
Changing the look of your spreadsheets
Changing indents in spreadsheets
Aligning text in spreadsheet cells
Changing fonts in spreadsheets
Changing colors in spreadsheets
Changing borders in spreadsheets
Changing row height or column width
Restoring default formatting to spreadsheet cells
Managing sheets in spreadsheets
Hiding and showing sheets in spreadsheets
Moving sheets in spreadsheets
Inserting sheets in spreadsheets
Sheets and cells protection
Formatting numbers
Entering and editing data
Data editing basics
Finding and replacing cell contents
Adding a hyperlink in a cell
Removing the link from a hyperlink
Using autofill to fill a range
Moving data by dragging in spreadsheets
Merging or splitting sheet cells
Spell-checking spreadsheets
Working with images in spreadsheets
Inserting images in spreadsheets
Moving and resizing images in spreadsheets
Setting image properties in spreadsheets
Working with charts in spreadsheets
Chart types in spreadsheets
Column charts
Bar charts
Pie charts
Area charts
Line charts
Scatter charts
Inserting charts in spreadsheets
Moving and resizing charts in spreadsheets
Copying charts in spreadsheets
Changing data source ranges
Setting chart properties in spreadsheets
Managing data ranges
Sorting data
Using instant filters
Adding data validation in spreadsheets
Freezing rows and columns in spreadsheets
Hiding rows and columns
Showing rows and columns
Referencing cells from another sheet
Copying data and images in spreadsheets
Naming a range
Finding or editing named ranges
Removing a named range
Relative and absolute references
Using formulas in calculations
About formulas and functions
List of functions
Grouped by category
Array functions
Inline array constants in formulas
Date and time functions
Engineering function
Information functions
Logical functions
Mathematical functions
Spreadsheet functions
Statistical functions
Text functions
ABS function
ACOS function
ACOSH function
ADDRESS function
AND function
ASIN function
ASINH function
ATAN function
ATAN2 function
ATANH function
AVERAGE function
AVERAGEA function
BASE function
BIN2DEC function
BIN2HEX function
BIN2OCT function
CEILING function
CHOOSE function
CHAR function
CODE function
COLUMN function
COLUMNS function
COMBIN function
CONCATENATE function
CONVERT function
COS function
COSH function
COUNT function
COUNTA function
COUNTBLANK function
COUNTIF function
DATE function
DATEDIF function
DATEVALUE function
DAY function
DAYS function
DAYS360 function
DEC2BIN function
DEC2HEX function
DEC2OCT function
DEGREES function
DOLLAR function
ERRORTYPE function
EVEN function
EXP function
EXACT function
FACT function
FALSE function
FIND function
FIXED function
FLOOR function
FORMULA function
FREQUENCY function
HEX2BIN function
HEX2DEC function
HEX2OCT function
HLOOKUP function
HOUR function
HYPERLINK function
IF function
INDEX function
INDIRECT function
INT function
ISBLANK function
ISERR function
ISERROR function
ISEVEN function
ISFORMULA function
ISLOGICAL function
ISNA function
ISNONTEXT function
ISNUMBER function
ISODD function
ISREF function
ISTEXT function
LARGE function
LEFT function
LEN function
LENB function
LN function
LOG function
LOG10 function
LOOKUP function
LOWER function
MATCH function
MAX function
MEDIAN function
MID function
MIN function
MINUTE function
MMULT function
MOD function
MODE function
MONTH function
N function
NA function
NETWORKDAYS function
NOT function
NOW function
OCT2BIN function
OCT2DEC function
OCT2HEX function
ODD function
OFFSET function
OR function
PI function
POWER function
PRODUCT function
PROPER function
RADIANS function
RAND function
RANDBETWEEN function
RANK function
REPLACE function
REPT function
RIGHT function
RIGHTB function
ROMAN function
ROUND function
ROUNDDOWN function
ROUNDUP function
ROW function
ROWS function
SEARCH function
SECOND function
SHEET function
SIN function
SINH function
SMALL function
SQRT function
STDEV function
STDEVP function
SUBSTITUTE function
SUBTOTAL function
SUM function
SUMIF function
SUMPRODUCT function
T function
TEXT function
TIME function
TIMEVALUE function
TODAY function
TRIM function
TRUE function
TRUNC function
TYPE function
UPPER function
VALUE function
VLOOKUP function
VAR function
VARA function
VARP function
VARPA function
WEEKDAY function
WEEKNUM function
WORKDAY function
YEAR function
Spreadsheets quick reference
Spreadsheets keyboard shortcuts
Working with presentations
Creating and uploading presentations
Creating presentations
Changing the default file format of presentations
Uploading presentations to share
Opening existing presentations in Connections Docs
Creating presentations from Content Navigator
File compatibility and working with files
File formats that are supported in presentations
Saving presentations
Checking a presentation into a library from Connections Docs
Checking a presentation into Content Navigator from Connections Docs
Downloading a presentation
Sharing presentations
Sharing presentations with people or communities
Setting access levels for presentations
Collaborating on presentations in real time
Co-editing in real time in presentations
About co-editing in presentations
Co-editing with others in presentations
Showing editor changes in a presentation
Collaborating with Connections Chat in presentations
Collaborating by using comments in presentations
About comments in presentations
Creating and acting on comments in presentations
Viewing comments in presentations
Searching comments in presentations
Formatting slides
Changing fonts in presentations
Changing line spacing in a slide
Inserting shapes
Selecting and moving objects
Copying and pasting objects
Rotating objects on a slide
Arranging the objects order
Distributing objects in a slide
Setting transparency for objects in presentations
Adding numbers or bullets to slides
Adding a link in a slide
Applying a slide layout
Spell-checking presentations
Printing presentations
Working with images in presentations
Inserting graphics in presentations
Moving and resizing images in presentations
Working with slides
Playing slide shows
Applying transitions between slides
Deleting slides
Adding slides
Moving slides
Duplicating slides
Working with tables in presentations
Creating tables in presentations
Adding rows and columns in presentations
Moving rows and columns in presentations
Resizing rows and columns in presentations
Aligning text in cells
Changing table styles in presentations
Defining table headers in presentations
Editing speaker notes
Presentations quick reference
Presentations keyboard shortcuts
Glossary
Notices
Bookmarks
What can you do with Bookmarks?
Getting started and installing the bookmark button
What's new in Bookmarks?
Creating a bookmark
Using tags
Managing tags
Adding a bookmark to another IBM Connections application
Viewing bookmarks
Refining the bookmarks list
Searching for bookmarks
Creating a single bookmark view
Viewing business cards
Notifying other users about a bookmark
Flagging a bookmark as broken
Adding bookmarks to your watchlist
Subscribing to a Bookmarks feed
Creating a feed from a Bookmarks view
Adding a bookmark list to a web site
Copying a bookmark
Importing bookmarks from a web browser
Exporting bookmarks to a file
Working with your bookmarks
What can you do with Bookmarks?
Getting started and installing the bookmark button
What's new in Bookmarks?
Creating a bookmark
Using tags
Managing tags
Adding a bookmark to another IBM Connections application
Viewing bookmarks
Refining the bookmarks list
Searching for bookmarks
Creating a single bookmark view
Viewing business cards
Notifying other users about a bookmark
Flagging a bookmark as broken
Adding bookmarks to your watchlist
Subscribing to a Bookmarks feed
Creating a feed from a Bookmarks view
Adding a bookmark list to a web site
Copying a bookmark
Importing bookmarks from a web browser
Exporting bookmarks to a file
Working with your bookmarks
Home page
What is the Home page?
What's new in the Home page?
Getting started with IBM Connections version 5.5
Frequently asked questions about the Home page
Using the activity stream views
Updating your status message from the Home page
Following tags
Using the My Page view
What are apps?
Adding apps to your Home page
Managing Home page apps
Home page apps
Using the Recommendations app on the Home page
Using the To Do List app
Using the Events app
Using the Activities app
Using the calendar in the Activities app
Using the My Activities app
Using the calendar in the My Activities app
Using the Public Activities app
Using the Blogs app
Using the Bookmarks app
Using the My Bookmarks app
Using the My Watchlist app
Using the Popular Bookmarks app
Using the Recent Bookmarks app
Using the Communities app
Using the My Communities app
Using the My Organization Communities app
Using the My Files app
Using the Files Shared with Me app
Using the Profiles app
Using the My Profile app
Using the My Network app
Using the My Wikis app
Using the Latest Wikis app
Using the Popular Wikis app
Home page views
Subscribing to a Home page feed
What is the Home page?
What's new in the Home page?
Getting started with IBM Connections version 5.5
Frequently asked questions about the Home page
Using the activity stream views
Updating your status message from the Home page
Following tags
Using the My Page view
What are apps?
Adding apps to your Home page
Managing Home page apps
Home page apps
Using the Recommendations app on the Home page
Using the To Do List app
Using the Events app
Using the Activities app
Using the calendar in the Activities app
Using the My Activities app
Using the calendar in the My Activities app
Using the Public Activities app
Using the Blogs app
Using the Bookmarks app
Using the My Bookmarks app
Using the My Watchlist app
Using the Popular Bookmarks app
Using the Recent Bookmarks app
Using the Communities app
Using the My Communities app
Using the My Organization Communities app
Using the My Files app
Using the Files Shared with Me app
Using the Profiles app
Using the My Profile app
Using the My Network app
Using the My Wikis app
Using the Latest Wikis app
Using the Popular Wikis app
Home page views
Subscribing to a Home page feed
Mail and Calendar
What is Connections Mail?
What’s new in Connections Mail?
Mail Quick Reference
Calendar Quick Reference
Social features
Email is more interactive
Attach or share files
Use contacts from Connections, Notes, or Outlook contacts
Troubleshooting and more information
Accessibility features for IBM Connections Mail
What is Connections Mail?
What’s new in Connections Mail?
Mail Quick Reference
Calendar Quick Reference
Social features
Email is more interactive
Attach or share files
Use contacts from Connections, Notes, or Outlook contacts
Troubleshooting and more information
Accessibility features for IBM Connections Mail
Product legal notices
Notices
Notices
Profiles
Profiles overview
What's new in Profiles?
Use Profiles to connect with people
Update your status
Update your profile
Add links to your profile
Follow someone
Post messages or comments
Remove content from your Recent Updates
Grow your network
Invite a person into your network
Accept network invitations
View network contacts
Delete people from your network
Discover people
Finding things in common
See who IBM Connections recommends to you
See how you are connected to someone
Subscribe to feeds
Search for a person
Download vCard contact details
Tagging profiles
Understanding profile tags
Tagging your profile
Tagging other people
Using the Organization Tags collection
Profiles overview
What's new in Profiles?
Use Profiles to connect with people
Update your status
Update your profile
Add links to your profile
Follow someone
Post messages or comments
Remove content from your Recent Updates
Grow your network
Invite a person into your network
Accept network invitations
View network contacts
Delete people from your network
Discover people
Finding things in common
See who IBM Connections recommends to you
See how you are connected to someone
Subscribe to feeds
Search for a person
Download vCard contact details
Tagging profiles
Understanding profile tags
Tagging your profile
Tagging other people
Using the Organization Tags collection
View information in information center
Viewing information in the information center
Preparing to use information center
Supported browsers for the information center
Displaying information in your preferred language
Navigating in the information center
Searching the information center
Advanced search techniques
Performing a quick search
Setting the appropriate scope
Using the existing scope
Modifying the existing scope
Creating a new scope
Finding information by using the index view
Printing topics in the information center
Setting bookmarks in the information center
Accessibility features in the information center
Frame structure used in the information center
Keyboard shortcuts and accelerators
Viewing information in the information center
Preparing to use information center
Supported browsers for the information center
Displaying information in your preferred language
Navigating in the information center
Searching the information center
Advanced search techniques
Performing a quick search
Setting the appropriate scope
Using the existing scope
Modifying the existing scope
Creating a new scope
Finding information by using the index view
Printing topics in the information center
Setting bookmarks in the information center
Accessibility features in the information center
Frame structure used in the information center
Keyboard shortcuts and accelerators