Home Page Icon
Home Page
Table of Contents for
Cell Formula Basics
Close
Cell Formula Basics
by Sherry Gunter, Patrice-Anne Rutledge
Easy Office 2013
Title Page
Copyright Page
Table of Contents
Contents
About the Authors
Dedication
Acknowledgments
We Want to Hear from You!
Reader Services
It’s as Easy as 1-2-3
Introduction to Easy Office 2013
Who This Book Is For
How This Book is Organized
Part I. Microsoft Office 2013
Chapter 1. Getting Started with Microsoft Office 2013
Microsoft Office 2013 Start Screen (Word)
Using the Ribbon
Exploring Backstage View
Using the Quick Access Toolbar
Using the Mini Toolbar
Using Contextual Tabs
Using Task Panes
Chapter 2. Working with Office Applications
Getting Help
Setting Up Your Account
Opening a File
Using the Clipboard to Cut, Copy, and Paste
Saving a File to Your Computer
Saving as a PDF or an XPS Document
Sharing a File
Printing a File
Closing a File
Customizing Office
Chapter 3. Working with Text
Formatting Text on the Home Tab (Word)
Using the Font Dialog Box to Format Text
Aligning Text
Finding and Replacing Text
Inserting WordArt
Formatting WordArt
Checking Spelling
Chapter 4. Working with Pictures
Picture Tools–Format Tab
Inserting a Picture from Your Computer
Inserting an Online Picture from Office.com
Enhancing a Picture
Applying a Picture Style
Applying a Picture Border
Resizing a Picture
Cropping a Picture
Chapter 5. Working with Shapes, SmartArt, and Screenshots
Insert Tab
Inserting a Shape
Formatting a Shape
Inserting a SmartArt Graphic
Inserting a Screenshot
Chapter 6. Using Microsoft Office on the Web and Mobile Devices
Exploring SkyDrive
Getting Started with SkyDrive
Creating a New Folder
Managing Folders
Uploading Files to SkyDrive
Creating a New File in SkyDrive
Editing a File in SkyDrive
Part II. Microsoft Word 2013
Chapter 7. Creating a Document in Microsoft Word
Navigating the Word Program Screen
Starting a Blank Document
Starting a New Document
Selecting Text
Creating a Document from a Template
Creating Bullet and Number Lists
Changing Text Color
Applying Styles
Adding Quick Parts
Creating a Table
Creating a Quick Table
Applying a Table Style
Inserting Rows and Columns
Deleting Rows and Columns
Deleting a Table
Merging Table Cells
Splitting Table Cells
Chapter 8. Enhancing Word Documents
Adding Headers and Footers in Word
Inserting a Cover Page
Inserting a Blank Page
Inserting a Page Break
Inserting Page Numbers
Adding Headers and Footers
Editing Headers and Footers
Inserting a Text Box
Inserting a Drop Cap
Inserting a Date
Inserting a Symbol
Inserting a Hyperlink
Inserting a Bookmark
Chapter 9. Controlling Page Layout
Controlling Page Layout in Word
Changing Page Margins
Modifying Page Orientation
Changing Page Size
Creating Columns
Applying Page Borders
Adding Indents
Changing Line Spacing
Controlling Paragraph Spacing
Setting Tabs
Applying a Theme
Chapter 10. Reviewing and Viewing Word Documents
Review Tools in Word
Tracking Changes with Document Reviewers
Adding Comments
Viewing Document Markup
Accepting or Rejecting Changes
Exploring Document Views
Zooming In and Out of Documents
Part III. Microsoft Excel 2013
Chapter 11. Creating an Excel Workbook
Getting Started with Excel
Creating a Workbook from a Template
Creating a Blank Workbook
Navigating the Worksheet Screen
Entering Data
Inserting a New Row
Inserting a New Column
Deleting Rows and Columns
Inserting a New Worksheet
Renaming Worksheet Tabs
Deleting a Worksheet
Hiding a Worksheet
Protecting a Workbook with a Password
Chapter 12. Formatting Worksheet Data
Formatting Basics
Wrapping Text
Merging and Centering Text
Formatting Numbers
Applying Cell Styles
Formatting as a Table
Adjusting Column Width
Adjusting Row Height
Finding Data
Freezing Panes
Sorting Data
Filtering Data
Chapter 13. Working with Cell Formulas and Functions
Cell Formula Basics
Creating a Simple Formula
Copying Formulas Using Fill
Creating a Compound Formula
Creating an Absolute Reference in a Formula
Using the SUM Function
Using the AutoSum Button
Using the AVERAGE Function
Chapter 14. Working with Charts, PivotTables, and Sparklines
Chart and PivotTable Tools
Inserting a Chart
Applying a Chart Style
Modifying a Chart
Creating a PivotTable
Adding a Sparkline
Part IV. Microsoft PowerPoint 2013
Chapter 15. Creating and Managing PowerPoint Presentations
Getting Started with PowerPoint
Creating a New PowerPoint Presentation
Exploring Normal View
Adding Slides to Your Presentation
Adding a Slide with a Bullet List
Adding Sections to Your Presentation
Creating a Presentation Outline
Chapter 16. Editing and Formatting Presentations
PowerPoint Design Options
Applying a New Slide Layout
Applying a New Theme
Formatting a Slide’s Background
Organizing Your Presentation with Slide Sorter View
Copying and Moving Slides from One Presentation to Another
Deleting a Slide
Using Slide Masters
Inserting a Hyperlink to the Web
Inserting a Hyperlink to Another Slide in Your Presentation
Adding Headers and Footers
Creating Handouts in Microsoft Word
Printing Your Presentation
Chapter 17. Working with Audio, Video, and Animation
Animations Tab and Pane
Inserting Online Video
Inserting a Video Clip from Your Computer
Formatting Video Clips
Inserting an Audio Clip from Your Computer
Setting Slide Transitions
Animating Slide Objects
Customizing Animations on the Animation Pane
Chapter 18. Reviewing and Making Presentations
Slide Show Tab
Adding Comments
Managing Comments
Comparing Presentations
Setting Up a Slide Show
Rehearsing Timings
Recording Voice Narrations
Presenting Your Show
Presenting Online
Exploring Presenter View
Creating Videos from PowerPoint Presentations
Part V. Microsoft Outlook 2013
Chapter 19. Sending and Receiving Messages
Navigating the Outlook Program Screen
Add an Email Account
Exploring the Outlook Layout
Sending an Email Message
Receiving and Reading Your Email
Replying to a Message
Forwarding a Message
Attaching Files to a Message
Creating an Email Signature
Creating Email Rules to Manage Spam
Chapter 20. Organizing and Scheduling in Outlook
Navigating the Outlook Calendar
Viewing Your Contacts
Emailing a Contact
Adding a New Contact
Viewing the Calendar
Scheduling an Appointment
Scheduling a Meeting
Sharing Your Calendar
Creating a Task
Managing Tasks
Creating Notes
Subscribing to RSS Feeds
Part VI. Microsoft OneNote 2013
Chapter 21. Creating Notebooks
Adding Notes in Notebook
Creating a New Notebook
Adding a Page Title
Creating a Section
Moving a Section
Adding Notes
Adding Pages
Creating Subpages
Adding a Picture
Applying Tags
Inserting Links
Applying a Template
Change Notebook Views
Chapter 22. Enhancing and Managing Notebooks
Adding Video to a Notebook
Attaching Files
Inserting Tables
Recording Audio
Recording Video
Adding a Timestamp
Emailing a Page
Drawing in Your Notebook
Sending a Task to Outlook
Sending a File to OneNote
Glossary
Index
Check Out These Easy Titles
The Least You Need To Know
Ad Pages
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
Chapter 13. Working with Cell Formulas and Functions
Next
Next Chapter
Creating a Simple Formula
Cell Formula Basics
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