C

Capitalize each word option, Changing case

caret (^), entering from keyboard, Inserting symbols, international characters, and other special characters

case of text, changing in Excel, Copying cells containing formulas and pasting only their resulting values

Category Name option, of Format Data Labels task pane, Manipulating chart elements

cell ranges, selecting and naming spreadsheet, Selecting and naming cell ranges

cell references vs. static values in formulas, Using functions

Cell Styles button, Formatting with styles

cells, spreadsheet, Changing column widths, Changing column widths, Changing column widths, Using formatting to alter the appearance of data, Introducing Flash Fill, Moving and adjusting cells, Moving and adjusting cells, Copying one or more cells to many, Using the AutoSum button and built-in function, Inserting functions, Using relative, fixed, and mixed cell references, Handy financial functions, Combining text from multiple cells into one string, Removing extra spaces, Removing extra spaces, Copying cells containing formulas and pasting only their resulting values, Copying cells containing formulas and pasting only their resulting values, Changing the case of text, Formatting in cells

copying and pasting range of, Copying cells containing formulas and pasting only their resulting values

copying one or more cells to many, Copying one or more cells to many

creating bottom border in, Changing column widths

extending series with autofill, Using formatting to alter the appearance of data

finalizing entry in, Changing column widths

format for email and web addresses, Introducing Flash Fill

formatting, Changing column widths, Formatting in cells

maximum number of characters in, Moving and adjusting cells

maximum number of rows, Using the AutoSum button and built-in function

moving and adjusting, Moving and adjusting cells

pasting formulas as resulting values, Removing extra spaces

restricting entries in, Changing the case of text

using references, Inserting functions

validating entries, Using relative, fixed, and mixed cell references

working with text in, Handy financial functions, Combining text from multiple cells into one string, Removing extra spaces, Copying cells containing formulas and pasting only their resulting values

changing case of text, Copying cells containing formulas and pasting only their resulting values

combining into one string, Handy financial functions

pasting formulas as resulting values, Removing extra spaces

removing extra spaces, Combining text from multiple cells into one string

Centered Overlay option, in Chart Title option list, Manipulating chart elements

centering text, Adding and formatting a table

Change Case command, Changing case

Change Chart Type button, Creating and modifying a chart, Manipulating chart elements

Change Chart Type dialog box, Creating and modifying a chart

Change File Type option, Creating PDF files in Word

changing, Exploring the Office environment, Sharing files with others from SharePoint Online or SkyDrive, Formatting placeholders on the slide master, Formatting placeholders on the slide master, Formatting placeholders on the slide master, Creating a custom slide layout, Creating and formatting SmartArt diagrams, Entering and organizing data, Changing column widths, Copying cells containing formulas and pasting only their resulting values, Changing your search scope

bullet size or color, Formatting placeholders on the slide master

bulleted list text into SmartArt graphics, Creating and formatting SmartArt diagrams

case of text in Excel, Copying cells containing formulas and pasting only their resulting values

font size, Formatting placeholders on the slide master

Office Theme, Exploring the Office environment

permissions on shared files, Sharing files with others from SharePoint Online or SkyDrive

presentation to widescreen format, Creating a custom slide layout

search scope in, Changing your search scope

spacing before and after paragraph levels of bulleted text, Formatting placeholders on the slide master

widths of columns, Entering and organizing data

widths of spreadsheet rows, Changing column widths

character formats, Setting section formatting, Using styles for paragraph and character formats, Exploring other character formats

exploring, Exploring other character formats

resetting, Using styles for paragraph and character formats

using styles for, Setting section formatting

characters, international, Inserting symbols, international characters, and other special characters

Chart Elements button, Creating and modifying a chart, Adding a slicer to a PivotChart, Manipulating chart elements, Manipulating chart elements

Chart Elements list, Manipulating chart elements, Manipulating chart elements

Axes option in, Manipulating chart elements

Chart Title option in, Manipulating chart elements

Chart Elements list, seeing icons next to, Inserting and formatting charts

chart elements, double-clicking, Manipulating chart elements

Chart Filters tool (funnel icon), Inserting and formatting charts

Chart Styles button, Creating and modifying a chart, Adding a slicer to a PivotChart

Chart Title option, in Chart Elements, Manipulating chart elements

Chart Tools Design tool tab, Inserting charts

charts, Identifying new shared features in Office Home and Student 2013, Inserting graphics, videos, charts, and diagrams, Working with documents in the new Read Mode, Adding and formatting a table, Identifying what’s new in Excel 2013, Identifying what’s new in Excel 2013, Creating charts and graphics, Creating and modifying a chart, Adding a slicer to a PivotChart, Manipulating chart elements, Manipulating objects

adding slicers to PivotCharts, Creating and modifying a chart

adding timelines, Identifying what’s new in Excel 2013, Manipulating chart elements

creating and modifying, Creating charts and graphics

formatting, Identifying new shared features in Office Home and Student 2013

inserting in Office documents, Inserting graphics, videos, charts, and diagrams

inserting in PowerPoint, Adding and formatting a table

manipulating elements in, Adding a slicer to a PivotChart

manipulating objects in, Manipulating objects

Recommended Chart feature, Identifying what’s new in Excel 2013

viewing in Read Mode, Working with documents in the new Read Mode

circular text, making, Applying enhanced fills and effects

CLEAN() function, Handy logical functions

Clear Filter command, Filtering data with tables

Clear Formats option, Formatting with styles

cloud services, Identifying new shared features in Office Home and Student 2013, Identifying new shared features in Office Home and Student 2013, Sharing and collaborating, Defining the term cloud service, Signing in and managing your Office account, Signing in and managing your Office account, Connecting cloud services to your Office account, Connecting cloud services to your Office account, Connecting cloud services to your Office account, Connecting cloud services to your Office account, Saving files on SharePoint Online and SkyDrive, Sharing files with others from SharePoint Online or SkyDrive, Sharing files with others from SharePoint Online or SkyDrive, Sharing files with others from SharePoint Online or SkyDrive, Opening files from the cloud

(see also Office cloud accounts; SkyDrive)

about, Sharing and collaborating, Signing in and managing your Office account

changing permissions, Sharing files with others from SharePoint Online or SkyDrive

computer requirements to access, Defining the term cloud service

connecting to, Connecting cloud services to your Office account

Office 365, Connecting cloud services to your Office account

opening files from, Identifying new shared features in Office Home and Student 2013, Sharing files with others from SharePoint Online or SkyDrive

personal, Connecting cloud services to your Office account

saving files on, Identifying new shared features in Office Home and Student 2013, Saving files on SharePoint Online and SkyDrive

sharing files from, Sharing files with others from SharePoint Online or SkyDrive

signing into Office cloud account, Signing in and managing your Office account

syncing files for offline use with, Opening files from the cloud

Clustered Column thumbnail, Creating and modifying a chart

co-authoring Office documents, Getting started with co-authoring

Collapse All Headings option, Collapsing and expanding document content

Collapse Field button, Creating a PivotTable

collapsing ribbon, Customizing the Office environment

Collated print option, Printing documents

colon (:), entering from keyboard, Inserting symbols, international characters, and other special characters

Color button, Applying enhanced fills and effects, Inserting, cropping, and formatting pictures

in Format Shape pane, Applying enhanced fills and effects

under Picture Tools Format tab, Inserting, cropping, and formatting pictures

colors, Theme fonts, Theme colors, Applying background styles to your presentation, Formatting placeholders on the slide master, Adding and formatting shapes, Filtering data with tables

changing bullet color, Formatting placeholders on the slide master

Create New Theme Colors dialog box, Applying background styles to your presentation

customizing PowerPoint, Theme fonts

Sort by Color/Filter by Color commands, Filtering data with tables

theme vs. direct, Adding and formatting shapes

using absolute, Theme colors

Colors dialog box, in PowerPoint, Applying theme effects to your presentation

column headers, in Excel, using in defining names, Selecting and naming cell ranges

Column Width, as Read Mode option, Working with documents in the new Read Mode

COLUMN([reference]) functions, Handy date and time functions

columns, Inserting tables, Entering and organizing data, Moving and copying rows and columns, Manipulating workbooks and worksheets, Working with panes and page layout options, Using the Insert Table feature

changing widths of spreadsheet, Entering and organizing data

deleting OneNote table, Using the Insert Table feature

deleting Word table, Inserting tables

inserting in Excel, Manipulating workbooks and worksheets

moving and copying spreadsheet, Moving and copying rows and columns

printing column labels in Excel, Working with panes and page layout options

COLUMNS(array) functions, Handy date and time functions

comma (,), Working with custom number formats, Manipulating chart elements

as Excel formatting code, Working with custom number formats

using in custom number format code, Manipulating chart elements

Comma Style button, Applying number formatting

commands, Exploring the Office environment, Exploring the Office environment, Exploring the Office environment, Customizing the Office environment, Customizing the Office environment, Customizing the ribbon, Exploring the Word 2013 user interface, Exploring the Word 2013 user interface, Modifying your document view, Changing other view options, Discovering what’s new in Word 2013, Navigating a document by scrolling and using keyboard shortcuts, Exploring research tools in Read Mode, Changing case, Inserting tables, Enhancing tables, Starting Excel 2013, Starting Excel 2013, Extending a series with AutoFill, Selecting and naming cell ranges, Using relative, fixed, and mixed cell references, Restricting cell entries, Filtering data with tables, Filtering data with tables, Filtering data with tables, Filtering data with tables, Filtering data with tables, Filter menu commands, Filter menu commands, Filter menu commands, Adding data to tables, Adding data to tables, Formatting with styles, Working with panes and page layout options, Working with panes and page layout options, Printing row and column labels on every page, Manipulating sheets, Getting started with OneNote 2013

Account, Exploring the Office environment

adding commands from Quick Access Toolbar, Customizing the Office environment, Exploring the Word 2013 user interface, Starting Excel 2013, Getting started with OneNote 2013

in Excel, Starting Excel 2013

in Office, Customizing the Office environment

in OneNote, Getting started with OneNote 2013

in Word, Exploring the Word 2013 user interface

Border Painter command in Word, Discovering what’s new in Word 2013

Border Sampler, Enhancing tables

Change Case, Changing case

Clear Filter, Filtering data with tables

Control AutoCorrect Options, Adding data to tables

Create From Selection, Selecting and naming cell ranges, Using relative, fixed, and mixed cell references

in Defined Names group, Using relative, fixed, and mixed cell references

in Excel, Selecting and naming cell ranges

Date Filters, Filter menu commands

Define and Translate, Exploring research tools in Read Mode

Draw Table, Inserting tables

Excel worksheets Hide, Manipulating sheets

file tab, Excel, Starting Excel 2013

Filter by Color command, Filtering data with tables

Filter menu, Filtering data with tables

Flash Fill, in Excel, Extending a series with AutoFill

Freeze Panes, Working with panes and page layout options

keyboard access to, Formatting with styles

Lock Cell, Restricting cell entries

Number Filters, Filter menu commands

Page Width, Modifying your document view

Print Titles, Working with panes and page layout options, Printing row and column labels on every page

Remove Split, Changing other view options

removing commands from Quick Access Toolbar, Customizing the Office environment, Exploring the Word 2013 user interface

ribbon vs. Quick Access Toolbar, Customizing the ribbon

screen tips for, Exploring the Office environment

Scroll Here, Navigating a document by scrolling and using keyboard shortcuts

Sort, Filtering data with tables

Sort by Color, Filtering data with tables

split control on ribbon of, Exploring the Office environment

Stop Automatically Expanding Tables, Adding data to tables

Text Filters, Filter menu commands

comment indicator, in Word, Discovering what’s new in Word 2013

Compare Side by Side dialog box, Managing multiple workbooks

Compatibility Checker, PowerPoint, Finalizing your presentation

Compatibility Mode, in Word, Discovering what’s new in Word 2013

composing documents, Using formatting marks during document composition, Inserting symbols, international characters, and other special characters, Inserting symbols, international characters, and other special characters, Inserting symbols, international characters, and other special characters, Inserting symbols, international characters, and other special characters, Inserting symbols, international characters, and other special characters, Using AutoCorrect, Composing documents faster by using building blocks

inserting special characters, Inserting symbols, international characters, and other special characters

inserting symbols, Inserting symbols, international characters, and other special characters, Inserting symbols, international characters, and other special characters

using AutoCorrect, Inserting symbols, international characters, and other special characters, Using AutoCorrect

using building blocks, Composing documents faster by using building blocks

using formatting marks in, Using formatting marks during document composition

using international characters, Inserting symbols, international characters, and other special characters

Compress Pictures dialog box, Inserting, cropping, and formatting pictures

Computer & HD Displays option, Saving your presentation as a video

CONCATENATE() function, Handy logical functions, Handy financial functions

Conditional Formatting button, Formatting conditionally

conditional formatting features, Using the Quick Analysis tools

contacts, annotating contacts in OneNote, Connecting appointments to OneNote

Continuous section breaks, Setting section formatting

Control AutoCorrect Options, Using AutoCorrect

Control AutoCorrect Options command, Adding data to tables

Convert Text to Table dialog box, Inserting tables

Convert To Range button, Adding data to tables, Inserting rows and columns

Convert to Shapes button, Working with ink in Office

Copy Link to Page option, OneNote, Connecting OneNote tasks to Outlook

Copy Link To Paragraph option, OneNote, Using hyperlinks to tie your notes together

copying, Moving and copying rows and columns, Copying one or more cells to many, Creating, editing, and copying formulas, Removing extra spaces, Copying cells containing formulas and pasting only their resulting values

columns and rows on spreadsheets, Moving and copying rows and columns

formulas, Creating, editing, and copying formulas

formulas and pasting as resulting values, Removing extra spaces

one or more spreadsheet cells to many, Copying one or more cells to many

range of cells, Copying cells containing formulas and pasting only their resulting values

copying selected text or object, Adding manual text boxes

Count Numbers function, Using the AutoSum button and built-in function

COUNTIF() functions, Looking at useful functions

Create a Video setting, Saving your presentation as a video

Create From Selection command, Selecting and naming cell ranges, Using relative, fixed, and mixed cell references

in Defined Names group, Using relative, fixed, and mixed cell references

in Excel, Selecting and naming cell ranges

Create Graphic group, Creating and formatting SmartArt diagrams

Create New Building Block dialog box, Composing documents faster by using building blocks

Create New Theme Colors dialog box, Applying background styles to your presentation

Create PDF/XPS button, Creating PDF files in Word

Create PDF/XPS Document option, Creating PDF files in Word

creating, Working with Office files, Discovering what’s new in Word 2013, Composing documents faster by using building blocks, Creating tabbed lists, Creating PDF files in Word, Designing and creating presentations, Applying theme effects to your presentation, Adding graphics to the slide master and layouts, Adding and formatting shapes, Applying enhanced fills and effects, Printing slides and notes, Changing column widths, Creating, editing, and copying formulas, Sorting data, Creating a custom sort list, Formatting with styles, Creating charts and graphics, Manipulating objects, Identifying new and improved features in OneNote 2013, Creating a notebook, Creating a notebook, Creating subpages, Creating and customizing tags, Using hyperlinks to tie your notes together, Creating custom hyperlinks to other pages, Sharing notes with others, Using OneNote on an iPhone or iPad

blank document, Composing documents faster by using building blocks

bottom border in spreadsheet cells, Changing column widths

charts, Creating charts and graphics

coordinating documents across applications, Discovering what’s new in Word 2013

creating notebooks on SkyDrive, Sharing notes with others

creating notes in OneNote Mobile apps, Using OneNote on an iPhone or iPad

custom shapes, Applying enhanced fills and effects

custom slide layouts, Adding graphics to the slide master and layouts

custom sort list, Sorting data

custom themes in Excel, Formatting with styles

formulas, Creating, editing, and copying formulas

graphics in Excel, Manipulating objects

hyperlinks to pages in OneNote, Using hyperlinks to tie your notes together

new files, Working with Office files

notebooks, Creating a notebook

OneNote tables, Creating custom hyperlinks to other pages

pages in OneNote, Creating subpages

PDFs, Creating PDF files in Word, Printing slides and notes, Identifying new and improved features in OneNote 2013

in OneNote, Identifying new and improved features in OneNote 2013

in PowerPoint, Printing slides and notes

in Word, Creating PDF files in Word

perfect shapes, Adding and formatting shapes

PivotTables, Creating a custom sort list

presentations using theme variants, Designing and creating presentations

sections in OneNote, Creating a notebook

tables in Word, Creating tabbed lists

tags, OneNote, Creating and customizing tags

theme font set, Applying theme effects to your presentation

Crop button, from Picture Tools Format tab, Using graphics elsewhere

cropping pictures, in presentations, Inserting, cropping, and formatting pictures

cursor, Editing and composing documents, Inserting special characters

keyboard shortcuts for moving, Editing and composing documents

moving to beginning of sentence, Inserting special characters

Custom category, of Format Cells dialog box, Manipulating chart elements

custom keyboard shortcut, assigning to character or symbol, Inserting symbols, international characters, and other special characters

custom number format code, using comma (,) in, Manipulating chart elements

Custom Print option, Printing documents

Customize Quick Access Toolbar list, Customizing the Office environment

Customize Status Bar list, Customizing the status bar

Customize Status Bar menu, Using the AutoSum button and built-in function

Customize Status Bar options, Setting section formatting

customizing, Recovering unsaved files and versions, Customizing the Office environment, Customizing the status bar, Customizing the ribbon, Applying a theme to an existing presentation, Adding graphics to the slide master and layouts, Adding and formatting shapes, Applying enhanced fills and effects

PowerPoint fills, Adding and formatting shapes

PowerPoint themes, Applying a theme to an existing presentation

Quick Access Toolbar, Customizing the Office environment

ribbon, Customizing the ribbon

shapes, Applying enhanced fills and effects

slide layouts, Adding graphics to the slide master and layouts

status bar, Customizing the status bar

user interface, Recovering unsaved files and versions