Essential Worksheet and Cell Range Operations
by Lisa A. Bucki, Gavin Powell, Michael R. Irwin, Peter G. Aitken, Michael R. Groh,
Office 2007 Bible
- Copyright
- About the Authors
- Credits
- Acknowledgments
- Introduction
- Common Office Features
- Creating Documents with Word
- Making the Numbers Work with Excel
- Persuading and Informing with PowerPoint
- A First Look at PowerPoint 2007
- Creating a Presentation, Slides, and Text
- Working with Layouts, Themes, and Masters
- 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 Labels
- Controlling the Axes
- Formatting a Chart
- Rotating a 3-D Chart
- Summary
- Using SmartArt Diagrams, Clip Art, and Pictures
- Understanding SmartArt Types and Their Uses
- Inserting a Diagram
- Editing SmartArt Text
- Modifying SmartArt Structure
- Modifying a Hierarchy Diagram Structure
- Formatting a Diagram
- Choosing Appropriate Clip Art
- About the Clip Organizer
- Inserting Clip Art on a Slide
- Clip Art Search Methods
- Working with Clip Art Collections
- Understanding Raster Graphics
- Importing Image Files into PowerPoint
- Sizing and Cropping Photos
- Compressing Images
- Summary
- Building Animation Effects, Transitions, and Support Materials
- Delivering a Live Presentation
- Organizing Messages, Contacts, and Time with Outlook
- 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
- 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
- Working with Contacts
- Working with Appointments and Tasks
- Fundamentals of E-Mail
- Designing Publications with Publisher
- Tracking Detailed Data with Access
- An Introduction to Database Development
- Creating Access Tables
- Getting Started with Access 2007
- Creating a Database
- The Access 2007 Environment
- Creating a New Table
- Creating tblContacts
- Setting the Primary Key
- Printing a Table Design
- Saving the Completed Table
- Manipulating Tables in a Database Window
- Adding Records to a Database Table
- Navigating Records in a Datasheet
- Changing Values in a Datasheet
- Summary
- Creating and Entering Data with Basic Access Forms
- Selecting Data with Queries
- Understanding Queries
- Creating a Query
- Selecting Fields
- Displaying the Recordset
- Working with Fields
- Changing the Sort Order
- Displaying Only Selected Records
- Printing a Query’s Recordset
- Saving a Query
- Adding More Than One Table to a Query
- Working with the Table/Query Pane
- Adding Fields from More Than One Table
- Understanding Multi-Table Query Limitations
- Summary
- Presenting Data with Access Reports
- Gathering Information
- Sharing and Collaboration
Chapter 14. Essential Worksheet and Cell Range Operations
In This Chapter |
|
This chapter covers some basic information regarding workbooks, worksheets, and windows. You will discover tips and techniques to help you take control of your worksheets. Most of the work you do in Excel involves cells and ranges. Understanding how best to manipulate cells and ranges will save you time and effort. This chapter discusses a variety of techniques that you can use to master worksheets, cells, and ranges. The result? You’ll be a more efficient Excel user.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.