Part III: Making the Numbers Work with Excel 2013
by Faithe Wempen, Dick Kusleika, Michael Alexander, John Walkenbach, Lisa A. Bucki
Office 2013 Bible: The Comprehensive Tutorial Resource
- Cover
- Contents
- Part I: Common Office Features
- Part II: Creating Documents with Word 2013
- Chapter 4: Diving Into Document Creation
- Chapter 5: Font/Character Formatting
- Chapter 6: Paragraph Formatting
- Chapter 7: Using Styles to Create a Great Looking Document
- Chapter 8: Controlling Document Appearance with Sections and More
- Chapter 9: Adding Tables and Graphics to a Document
- Getting a Quick Start with Quick Tables
- Table Basics
- Working with Table Layout and Design
- Adding a Shape
- Inserting a Picture from a File
- Adding an Online Picture
- Pasting or Snapping a Picture
- Manipulating Inserted Pictures (and Other Graphics)
- Creating WordArt
- Inserting SmartArt
- Arranging Pictures and Other Objects
- Using the Selection Pane
- Summary
- Chapter 10: Data Documents and Mail Merge
- Chapter 11: Managing Document Security, Comments, and Tracked Changes
- Part III: Making the Numbers Work with Excel 2013
- Chapter 12: Using Excel Worksheets and Workbooks
- Chapter 13: Entering and Editing Worksheet Data
- Chapter 14: Essential Worksheet and Cell Range Operations
- Chapter 15: Introducing Formulas and Functions
- Chapter 16: Working with Dates and Times
- Chapter 17: Creating Formulas That Count and Sum
- Chapter 18: Getting Started Making Charts
- Chapter 19: Communicating Data Visually
- Creating a Table
- Changing the Look of a Table
- Working with Tables
- About Conditional Formatting
- Conditional Formats That Use Graphics
- Working with Conditional Formats
- Introducing Sparklines
- Sparkline Types
- Creating Sparklines
- Customizing Sparklines
- Auto-Updating Sparklines
- Displaying a Sparkline for a Dynamic Range
- Summary
- Part IV: Persuading and Informing with PowerPoint 2013
- Chapter 20: A First Look at PowerPoint 2013
- Chapter 21: Creating a Presentation, Slides, and Text
- Starting a New Presentation
- Saving Your Work
- Setting Passwords for File Access
- Closing and Reopening Presentations
- Setting File Properties
- Creating New Slides
- Inserting Content from External Sources
- Managing Slides
- Using Content Placeholders
- Creating Text Boxes Manually
- Working with Text Boxes
- Summary
- Chapter 22: Working with Layouts, Themes, and Masters
- Chapter 23: Working with Tables and Charts
- Creating a New Table
- Moving around in a Table
- Selecting Rows, Columns, and Cells
- Editing a Table’s Structure
- Applying Table Styles
- Formatting Table Cells
- Understanding Charts
- Starting a New Chart
- Working with Chart Data
- Chart Types and Chart Layout Presets
- Working with Chart Elements
- Controlling the Axes
- Formatting a Chart
- Rotating a 3-D Chart
- Summary
- Chapter 24: Using SmartArt Diagrams, Clip Art, and Pictures
- Understanding SmartArt Types and Their Uses
- Inserting a SmartArt Graphic
- Editing SmartArt Text
- Modifying SmartArt Structure
- Modifying a Hierarchy Graphic Structure
- Formatting a SmartArt Graphic
- Saving a SmartArt Graphic as a Picture
- Choosing Appropriate Artwork
- Inserting Clip Art
- Understanding Raster Graphics
- Inserting Photos
- Sizing and Cropping Photos
- Adjusting and Correcting Photos
- Compressing Images
- Summary
- Chapter 25: Building Animation Effects, Transitions, and Support Materials
- Chapter 26: Delivering a Live Presentation
- Part V: Organizing Messages, Contacts, and Time with Outlook
- Chapter 27: Fundamentals of E-mail
- Setting Up Your E-mail Accounts
- Modifying Account Settings
- Using Outlook Profiles
- Composing and Sending Messages
- Reading and Replying to Messages
- Understanding the Inbox Display
- Understanding Files and Folders
- Outlook Data Files
- Working with Outlook Folders
- Deleting Items and Using the Deleted Items Folder
- Setting Options for an Individual E-mail Message
- Setting Global E-mail Options
- Summary
- Chapter 28: Processing and Securing E-mail
- Understanding Junk E-mail Filtering
- Setting Junk E-mail Options
- Blocking and Allowing Specific Addresses
- Understanding E-mail Rule Basics
- Creating a New Rule
- Some Rule Examples
- Managing Rules
- Protecting against Viruses
- Dealing with Attachments
- Macro Security
- Using Certificates and Digital Signatures
- HTML Message Dangers
- Summary
- Chapter 29: Working with Contacts
- Chapter 30: Working with Appointments and Tasks
- Chapter 27: Fundamentals of E-mail
- Part VI: Designing Publications with Publisher
- Part VII: Managing Information with Access and OneNote
- Chapter 33: An Introduction to Database Development
- Chapter 34: Creating Access Tables
- The Access Start Screen
- How to Create a Blank Desktop Database
- The Access 2013 Environment
- Creating an Example Table
- Setting the Primary Key
- Indexing Access Tables
- Printing a Table Design
- Saving the Completed Table
- Manipulating Tables
- Adding Records to a Database Table
- Navigating Records in a Datasheet
- Changing Values in a Datasheet
- Understanding Attachment Fields
- Summary
- Chapter 35: Creating and Entering Data with Basic Access Forms
- Chapter 36: Selecting Data with Queries
- Chapter 37: Presenting Data with Access Reports
- Chapter 38: Keeping Information at Hand with OneNote
- Who Needs OneNote and Why
- Touring OneNote
- Creating a Notebook
- Creating a Section
- Creating a Page
- Inserting Notes
- Inserting an Outlook Task
- Inserting a Picture or File
- Inserting a Screen Clipping
- Writing on a Page
- Using Linked Note Taking
- Using Send To OneNote
- Organizing, Finding, and Sharing
- Working with Notes in the Cloud
- Summary
- Part VIII: Sharing and Collaborating in the Cloud and Applications
- Appendix A: Customizing Office
- Appendix B: Optimizing Your Office Installation
- Appendix C: International Support and Accessibility Features
- Introduction
Part III
Making the Numbers Work with Excel 2013
IN THIS CHAPTER
Chapter 12 Using Excel Worksheets and Workbooks
Chapter 13 Entering and Editing Worksheet Data
Chapter 14 Essential Worksheet and Cell Range Operations
Chapter 15 Introducing Formulas and Functions
Chapter 16 Working with Dates and Times
Chapter 17 Creating Formulas That Count and Sum
Chapter 18 Getting Started Making Charts
Chapter 19 Communicating Data Visually
Let the number crunching begin in Part III, which covers calculating results and more in Excel 2013. You will learn how Excel organizes information on worksheets within workbooks, and how to make and format different types of cell entries, including labels and values. You’ll learn to organize worksheets and how to create and use named cell ranges to save time. The part moves on to the most powerful capabilities in Excel: the ability to use formulas and functions to perform simple calculations, sophisticated math, and formulas to calculate date and time information. The part closes out with two chapters showing you how to highlight your data visually, through charts, tables, conditional formatting, sparklines, and more.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.