Home Page Icon
Home Page
Table of Contents for
Index
Close
Index
by Mark Dodge Beth Melton Echo Swinford, and Ben M. Schorr
Microsoft Office Home and Student 2013: Step by Step
Microsoft Office Home and Student 2013: Step by Step
A Note Regarding Supplemental Files
Introduction
Who this book is for
How this book is organized
Download the practice files
Your companion ebook
Getting support and giving feedback
Errata
We want to hear from you
Stay in touch
I. Office Home and Student 2013 fundamentals
1. Getting comfortable in Office Home and Student 2013
Exploring the Office environment
Working with Office files
Recovering unsaved files and versions
Customizing the user interface
Customizing the Office environment
Customizing the Quick Access toolbar
Customizing the status bar
Customizing the ribbon
Choosing the right application for the task at hand
Key points
2. Using shared Office features
Identifying new shared features in Office Home and Student 2013
Applying Office themes
Inserting graphics, videos, charts, and diagrams
Inserting charts
Searching for online templates
Presenting Office documents online
Inserting online video
Key points
3. Sharing and collaborating
Defining the term cloud service
Signing in and managing 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
Opening files from the cloud
Syncing files with SkyDrive for offline use
Syncing with SkyDrive Pro
Syncing with SkyDrive for a Microsoft Account
Getting started with co-authoring
Key points
4. Using touch in Office
Getting comfortable with Office on a tablet
Looking at unsupported features
Using touch mode
Selecting content with touch
Working with ink in Office
Key points
II. Word 2013
5. Getting comfortable in Word 2013
Exploring the Word 2013 user interface
Modifying your document view
Changing other view options
Discovering what’s new in Word 2013
Key points
6. Navigating and reading documents
Navigating a document by scrolling and using keyboard shortcuts
Searching and navigating a document by using the Navigation pane
Collapsing and expanding document content
Working with documents in the new Read Mode
Exploring research tools in Read Mode
Key points
7. Editing and composing documents
Moving the cursor by using keyboard shortcuts
Selecting text by using the keyboard and mouse
Selecting text by using the keyboard
Selecting text by using the mouse
Using other selection methods
Using formatting marks during document composition
Inserting symbols, international characters, and other special characters
Inserting special characters
Using AutoCorrect
Composing documents faster by using building blocks
Key points
8. Formatting documents
Formatting documents more efficiently
Setting default document formatting for your documents
Setting section formatting
Using styles for paragraph and character formats
Exploring other paragraph formats
Exploring other character formats
Changing case
Managing pagination through formatting
Key points
9. Presenting information
Formatting simple lists by using bullets and numbering
Creating tabbed lists
Inserting tables
Enhancing tables
Key points
10. Finalizing documents
Correcting proofing errors
Inspecting documents before publishing
Marking documents as final
Creating PDF files in Word
Converting PDF files for editing
Printing documents
Key points
III. PowerPoint 2013
11. Getting comfortable in PowerPoint 2013
Getting started working with PowerPoint 2013
Exploring the PowerPoint 2013 tools
Discovering the new features in PowerPoint 2013
Key points
12. Designing and creating presentations
Creating a new presentation based on a theme or template
Applying a theme to an existing presentation
Customizing your file with colors, fonts, and effects
Theme fonts
Theme colors
Applying theme effects to your presentation
Applying background styles to your presentation
Formatting placeholders on the slide master
Adding graphics to the slide master and layouts
Creating a custom slide layout
Changing your presentation from a 16:9 format to a 4:3 format
Key points
13. Creating on-slide content
Choosing a slide layout and adding text in placeholders
Adding manual text boxes
Adding and formatting a table
Inserting and formatting charts
Creating and formatting SmartArt diagrams
Reusing slides and keeping their source formatting
Key points
14. Creating Office graphics
Adding and formatting shapes
Applying enhanced fills and effects
Creating your own shapes
Inserting, cropping, and formatting pictures
Key points
15. Adding animation and multimedia
Adding animation to text and shapes
Editing video and applying transitions
Inserting and playing online video
Saving your presentation as a video
Key points
16. Finalizing and presenting
Adding and renaming sections
Inserting comments
Printing slides and notes
Finalizing your presentation
Delivering a presentation
Practicing with Presenter view
Key points
IV. Excel 2013
17. Getting comfortable in Excel 2013
Starting Excel 2013
Identifying what’s new in Excel 2013
Using the new features in Excel
Other enhancements, improvements, and feature upgrades
Key points
18. Creating and editing worksheets
Entering and organizing data
Changing column widths
Using formatting to alter the appearance of data
Extending a series with AutoFill
Introducing Flash Fill
Selecting and naming cell ranges
Using column headers to define names
Moving around in the worksheet
Moving and adjusting cells
Moving and copying rows and columns
Copying one or more cells to many
Key points
19. Manipulating numbers and text
Creating, editing, and copying formulas
Using functions
Using the AutoSum button and built-in function
Inserting functions
Using relative, fixed, and mixed cell references
Using names in formulas and validating cell entries
Looking at useful functions
Handy math and trig functions
Handy logical functions
Handy text functions
Handy date and time functions
Handy lookup and reference functions
Handy financial functions
Working with text in Excel
Combining text from multiple cells into one string
Removing extra spaces
Copying cells containing formulas and pasting only their resulting values
Changing the case of text
Restricting cell entries
Key points
20. Analyzing data
Exploring a built-in template
Performing what-if analyses
Managing multiple what-if models
Using the Quick Analysis tools
Formatting conditionally
Analyzing data from another source
Filtering data with tables
Filter menu commands
Adding data to tables
Sorting data
Creating a custom sort list
Creating a PivotTable
Key points
21. Formatting worksheets
Applying number formatting
Formatting with styles
Creating custom themes
Formatting in cells
Working with custom number formats
Working with percentage formats
Working with fraction formats
Working with date formats
Protecting worksheets
Setting view options
Storing formats in templates
Key points
22. Manipulating workbooks and worksheets
Inserting rows and columns
Inserting and deleting cells
Working with panes and page layout options
Printing row and column labels on every page
Adjusting page breaks
Creating a multisheet workbook
Manipulating sheets
Summarizing a multisheet workbook
Working with sheet references
Managing multiple workbooks
Key points
23. Creating charts and graphics
Creating and modifying a chart
Adding a slicer to a PivotChart
Manipulating chart elements
Adding a timeline to a chart
Manipulating objects
Creating and sharing graphics
Using graphics elsewhere
Key points
V. OneNote 2013
24. Getting comfortable in OneNote 2013
Getting started with OneNote 2013
Exploring the OneNote interface
Identifying new and improved features in OneNote 2013
Key points
25. Working with notebooks, sections, and pages
Creating a notebook
Creating and organizing sections
Section groups
Creating and organizing pages
Creating subpages
Adding and organizing notes
Inserting images
Working with ink and shapes
Custom pens
Shapes
Erasing ink or shapes
Inserting space
Arranging shapes
Recovering deleted sections or pages
Key points
26. Using organizational tools
Using tags
Creating and customizing tags
Using styles to format your notes
Connecting OneNote to Outlook
Sending email messages to OneNote
Connecting appointments to OneNote
Annotating contacts
Connecting OneNote tasks to Outlook
Using hyperlinks to tie your notes together
Creating custom hyperlinks to other pages
Creating and organizing tables
Using the Insert Table feature
Searching your notes to find information quickly
Changing your search scope
Key points
27. Sharing notes with others
Creating a new notebook on SkyDrive
Moving a notebook to SkyDrive
Stopping sharing in SkyDrive
Using a file server to share notes
Stopping sharing on a file server
Sharing notes via SharePoint
Sharing notes with others during a meeting
Sending notes via email
Exporting to other formats
Key points
28. Using OneNote everywhere
Syncing your notes by using SkyDrive
Accessing your notes in a web browser
Using OneNote on your phone or tablet
Using OneNote on an iPhone or iPad
Using OneNote Mobile for Android
Using OneNote Mobile on a Windows Phone
Using OneNote with a Windows 8 tablet
Key points
29. Saving time with OneNote
Finding tags
Recording audio
Using Quick Notes
Using screen clipping
Using linked notes
Searching your images
Inserting a spreadsheet
Using the Napkin Math feature
Formatting with templates
Key points
A. About the authors
Index
About the Authors
Copyright
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Index
Next
Next Chapter
Index
B
Background Removal tab,
Inserting, cropping, and formatting pictures
Background Styles menu choice, in PowerPoint,
Applying background styles to your presentation
backgrounds,
Exploring the Office environment
,
Applying theme effects to your presentation
,
Inserting, cropping, and formatting pictures
,
Editing video and applying transitions
applying styles to presentations,
Applying theme effects to your presentation
playing audio file in presentations,
Editing video and applying transitions
preferred setting for,
Exploring the Office environment
removing from pictures in PowerPoint,
Inserting, cropping, and formatting pictures
Backstage pages,
Exploring the Office environment
,
Working with Office files
,
Working with Office files
,
Working with Office files
,
Working with Office files
,
Working with Office files
,
Working with Office files
,
Working with Office files
,
Recovering unsaved files and versions
,
Signing in and managing your Office account
,
Signing in and managing 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
,
Opening files from the cloud
Account,
Exploring the Office environment
,
Signing in and managing your Office account
,
Connecting cloud services to your Office account
Export,
Working with Office files
Info,
Working with Office files
,
Recovering unsaved files and versions
New,
Working with Office files
Open,
Working with Office files
,
Opening files from the cloud
Print,
Working with Office files
Save As,
Working with Office files
,
Saving files on SharePoint Online and SkyDrive
Share,
Working with Office files
,
Sharing files with others from SharePoint Online or SkyDrive
Sign in to Office,
Signing in and managing your Office account
Backstage view,
Exploring the Office environment
,
Exploring the Office environment
closing,
Exploring the Office environment
displaying,
Exploring the Office environment
Before spacing, in Paragraph dialog box,
Formatting placeholders on the slide master
Bezier Curves,
Creating your own shapes
Bing, searching from Research pane using,
Exploring research tools in Read Mode
Blank layout, in PowerPoint,
Applying enhanced fills and effects
Blank Workbook, creating,
Changing column widths
Blur field, in Format Shape pane,
Applying enhanced fills and effects
body fonts, in PowerPoint,
Theme fonts
bolding selected text,
Adding manual text boxes
Border button, in Excel,
Changing column widths
Border Painter command, in Word,
Discovering what’s new in Word 2013
Border Painter, in Word,
Discovering what’s new in Word 2013
Border Sampler command,
Enhancing tables
Border Sampler, in Word,
Discovering what’s new in Word 2013
Border Styles gallery,
Discovering what’s new in Word 2013
,
Enhancing tables
for tables in Word,
Discovering what’s new in Word 2013
on Table Tools Design tool tab,
Enhancing tables
borderless tables,
Enhancing tables
borders, removing from shapes,
Applying enhanced fills and effects
bottom page margins, toggling in Print Layout view,
Modifying your document view
brackets ([ ]),
Working with custom number formats
,
Working with date formats
adding to formatting code in Excel,
Working with custom number formats
as Excel date formatting code,
Working with date formats
Bring to Front menu option,
Inserting, cropping, and formatting pictures
,
Arranging shapes
in OneNote,
Arranging shapes
in PowerPoint,
Inserting, cropping, and formatting pictures
browser, accessing notes in,
Syncing your notes by using SkyDrive
building blocks,
Discovering what’s new in Word 2013
,
Composing documents faster by using building blocks
composing documents using,
Composing documents faster by using building blocks
in Word,
Discovering what’s new in Word 2013
Building Blocks Organizer dialog box,
Composing documents faster by using building blocks
built-in functions,
Using the AutoSum button and built-in function
,
Using the AutoSum button and built-in function
,
Using the AutoSum button and built-in function
AVERAGE,
Using the AutoSum button and built-in function
SUM,
Using the AutoSum button and built-in function
using,
Using the AutoSum button and built-in function
bullet points,
Formatting placeholders on the slide master
,
Formatting placeholders on the slide master
,
Choosing a slide layout and adding text in placeholders
,
Choosing a slide layout and adding text in placeholders
,
Creating and formatting SmartArt diagrams
changing list text into SmartArt graphic,
Creating and formatting SmartArt diagrams
changing size and color of,
Formatting placeholders on the slide master
changing spacing before and after paragraph levels of bulleted text,
Formatting placeholders on the slide master
creating second level bulleted text in slides,
Choosing a slide layout and adding text in placeholders
troubleshooting slide,
Choosing a slide layout and adding text in placeholders
bulleted lists,
Presenting information
,
Presenting information
about,
Presenting information
formatting,
Presenting information
Bullets gallery, in PowerPoint,
Formatting placeholders on the slide master
buttons,
Exploring the Office environment
,
Exploring the Office environment
,
Exploring the Office environment
,
Working with Office files
,
Applying Office themes
,
Inserting graphics, videos, charts, and diagrams
,
Inserting graphics, videos, charts, and diagrams
,
Opening files from the cloud
,
Looking at unsupported features
,
Working with ink in Office
,
Working with ink in Office
,
Working with ink in Office
,
Exploring the Word 2013 user interface
,
Exploring the Word 2013 user interface
,
Discovering what’s new in Word 2013
,
Searching and navigating a document by using the Navigation pane
,
Searching and navigating a document by using the Navigation pane
,
Searching and navigating a document by using the Navigation pane
,
Moving the cursor by using keyboard shortcuts
,
Using formatting marks during document composition
,
Inserting symbols, international characters, and other special characters
,
Formatting documents more efficiently
,
Exploring other character formats
,
Creating tabbed lists
,
Creating PDF files in Word
,
Creating PDF files in Word
,
Getting started working with PowerPoint 2013
,
Getting started working with PowerPoint 2013
,
Theme fonts
,
Formatting placeholders on the slide master
,
Formatting placeholders on the slide master
,
Adding graphics to the slide master and layouts
,
Choosing a slide layout and adding text in placeholders
,
Choosing a slide layout and adding text in placeholders
,
Choosing a slide layout and adding text in placeholders
,
Choosing a slide layout and adding text in placeholders
,
Adding manual text boxes
,
Inserting and formatting charts
,
Adding and formatting shapes
,
Applying enhanced fills and effects
,
Applying enhanced fills and effects
,
Applying enhanced fills and effects
,
Applying enhanced fills and effects
,
Applying enhanced fills and effects
,
Inserting, cropping, and formatting pictures
,
Inserting, cropping, and formatting pictures
,
Inserting, cropping, and formatting pictures
,
Inserting, cropping, and formatting pictures
,
Inserting, cropping, and formatting pictures
,
Inserting, cropping, and formatting pictures
,
Inserting, cropping, and formatting pictures
,
Inserting, cropping, and formatting pictures
,
Adding animation to text and shapes
,
Editing video and applying transitions
,
Printing slides and notes
,
Delivering a presentation
,
Delivering a presentation
,
Starting Excel 2013
,
Starting Excel 2013
,
Changing column widths
,
Moving and adjusting cells
,
Moving and adjusting cells
,
Using functions
,
Using functions
,
Using the AutoSum button and built-in function
,
Inserting functions
,
Copying cells containing formulas and pasting only their resulting values
,
Changing the case of text
,
Restricting cell entries
,
Managing multiple what-if models
,
Managing multiple what-if models
,
Using the Quick Analysis tools
,
Formatting conditionally
,
Formatting conditionally
,
Filtering data with tables
,
Adding data to tables
,
Adding data to tables
,
Creating a PivotTable
,
Applying number formatting
,
Formatting with styles
,
Creating custom themes
,
Protecting worksheets
,
Setting view options
,
Setting view options
,
Setting view options
,
Inserting rows and columns
,
Working with panes and page layout options
,
Adjusting page breaks
,
Manipulating sheets
,
Managing multiple workbooks
,
Creating and modifying a chart
,
Creating and modifying a chart
,
Creating and modifying a chart
,
Creating and modifying a chart
,
Adding a slicer to a PivotChart
,
Adding a slicer to a PivotChart
,
Adding a slicer to a PivotChart
,
Manipulating chart elements
,
Manipulating chart elements
,
Manipulating chart elements
,
Manipulating chart elements
,
Adding a timeline to a chart
,
Adding a timeline to a chart
,
Manipulating objects
,
Manipulating objects
,
Creating and sharing graphics
,
Creating and sharing graphics
,
Creating and sharing graphics
,
Creating and sharing graphics
,
Creating and sharing graphics
,
Using graphics elsewhere
,
Using graphics elsewhere
,
Using graphics elsewhere
,
Exploring the OneNote interface
,
Exploring the OneNote interface
,
Inserting space
,
Recovering deleted sections or pages
,
Creating and customizing tags
,
Connecting appointments to OneNote
,
Annotating contacts
,
Using OneNote on an iPhone or iPad
,
Using the Napkin Math feature
Align Objects,
Manipulating objects
,
Creating and sharing graphics
Animation pane,
Adding animation to text and shapes
Arrange,
Inserting, cropping, and formatting pictures
Arrange All,
Manipulating sheets
,
Managing multiple workbooks
Artistic Effects,
Inserting, cropping, and formatting pictures
AutoCorrect Options,
Adding data to tables
AutoSum,
Using functions
Border, in Excel,
Changing column widths
buttons,
Inserting, cropping, and formatting pictures
Cell Styles,
Formatting with styles
Change Chart Type,
Creating and modifying a chart
,
Manipulating chart elements
Chart Elements,
Creating and modifying a chart
,
Adding a slicer to a PivotChart
,
Manipulating chart elements
,
Manipulating chart elements
Chart Styles,
Creating and modifying a chart
,
Adding a slicer to a PivotChart
Collapse Field,
Creating a PivotTable
Color,
Applying enhanced fills and effects
,
Inserting, cropping, and formatting pictures
Comma Style,
Applying number formatting
Conditional Formatting,
Formatting conditionally
,
Formatting conditionally
Convert To Range,
Adding data to tables
,
Inserting rows and columns
Convert to Shapes,
Working with ink in Office
Create PDF/XPS,
Creating PDF files in Word
Crop,
Inserting, cropping, and formatting pictures
Data Validation,
Restricting cell entries
Decrease Decimal,
Using the AutoSum button and built-in function
Decrease Font Size,
Formatting placeholders on the slide master
Decrease List Level,
Choosing a slide layout and adding text in placeholders
Dock to Desktop,
Exploring the OneNote interface
Field Buttons,
Creating and modifying a chart
Fit Slide to Current Window,
Adding graphics to the slide master and layouts
Freeze Panes,
Working with panes and page layout options
From Beginning or From Current Slide,
Delivering a presentation
Group Objects,
Using graphics elsewhere
Help,
Exploring the Office environment
hiding filter,
Filtering data with tables
Increase Font Size,
Formatting placeholders on the slide master
Increase List Level,
Choosing a slide layout and adding text in placeholders
,
Choosing a slide layout and adding text in placeholders
Ink Comment,
Working with ink in Office
Insert Function,
Inserting functions
Insert Slicer,
Adding a slicer to a PivotChart
Insert Space,
Inserting space
Insert Timeline,
Adding a timeline to a chart
Layout Options, in Word,
Discovering what’s new in Word 2013
Layout, in PowerPoint,
Adding and formatting shapes
Linked Contact Notes,
Connecting appointments to OneNote
More Options,
Inserting and formatting charts
New Slide,
Choosing a slide layout and adding text in placeholders
,
Adding manual text boxes
Next,
Searching and navigating a document by using the Navigation pane
Notebook Recycle Bin,
Recovering deleted sections or pages
Orientation,
Adjusting page breaks
Outlook Tasks,
Annotating contacts
Page Templates,
Using the Napkin Math feature
Pictures,
Inserting graphics, videos, charts, and diagrams
Previous,
Searching and navigating a document by using the Navigation pane
Print,
Working with Office files
Protect Workbook,
Protecting worksheets
Publish,
Creating PDF files in Word
Recents, OneNote Mobile apps,
Using OneNote on an iPhone or iPad
Remove Background,
Inserting, cropping, and formatting pictures
Remove Gradient Stop,
Applying enhanced fills and effects
Reset Picture,
Inserting, cropping, and formatting pictures
Ribbon Display Options,
Exploring the Office environment
,
Exploring the Word 2013 user interface
,
Getting started working with PowerPoint 2013
,
Starting Excel 2013
,
Setting view options
in Excel,
Starting Excel 2013
,
Setting view options
in Office,
Exploring the Office environment
in PowerPoint,
Getting started working with PowerPoint 2013
in Word,
Exploring the Word 2013 user interface
Rule Lines,
Exploring the OneNote interface
Running Total,
Using the Quick Analysis tools
Save, green arrows on Quick Access Toolbar,
Opening files from the cloud
Screenshot,
Inserting, cropping, and formatting pictures
,
Using graphics elsewhere
See All Slides,
Delivering a presentation
Select All, in Excel,
Moving and adjusting cells
Send Backward,
Creating and sharing graphics
Set As Default, in Find Options dialog box,
Searching and navigating a document by using the Navigation pane
Shape Effects,
Manipulating objects
Shape Fill,
Applying enhanced fills and effects
Shape Options Effects,
Applying enhanced fills and effects
Shapes,
Creating and sharing graphics
,
Creating and sharing graphics
Show/Hide ¶,
Using formatting marks during document composition
,
Exploring other character formats
,
Creating tabbed lists
Slicer,
Manipulating chart elements
Slide Master,
Theme fonts
SmartArt,
Inserting graphics, videos, charts, and diagrams
Start Inking,
Working with ink in Office
Symbol,
Inserting symbols, international characters, and other special characters
Symbol, OneNote,
Creating and customizing tags
Synchronous Scrolling,
Setting view options
Text Effects,
Applying enhanced fills and effects
,
Creating and sharing graphics
Text Highlight Color,
Formatting documents more efficiently
Themes,
Applying Office themes
,
Creating custom themes
Timeline,
Adding a timeline to a chart
Touch Mode,
Looking at unsupported features
Trim Video,
Editing video and applying transitions
Undo,
Moving the cursor by using keyboard shortcuts
using,
Managing multiple what-if models
Values,
Copying cells containing formulas and pasting only their resulting values
,
Changing the case of text
in Paste Special,
Changing the case of text
in Paste Values group,
Copying cells containing formulas and pasting only their resulting values
View Side By Side,
Setting view options
What-If Analysis,
Managing multiple what-if models
Window control,
Exploring the Office environment
,
Exploring the Word 2013 user interface
,
Getting started working with PowerPoint 2013
,
Starting Excel 2013
in Excel,
Starting Excel 2013
in Office,
Exploring the Office environment
in PowerPoint,
Getting started working with PowerPoint 2013
in Word,
Exploring the Word 2013 user interface
Wrap Text,
Moving and adjusting cells
Zoom,
Using graphics elsewhere
Zoom to Page,
Printing slides and notes
“epsilon”,
Using functions
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset