Dreadfully Ever After Sale

Recently Viewed clear list

Original Essays | September 30, 2014

Brian Doyle: IMG The Rude Burl of Our Masks

One day when I was 12 years old and setting off on my newspaper route after school my mom said will you stop at the doctor's and pick up something... Continue »
  1. $13.27 Sale Trade Paper add to wish list

    Children and Other Wild Animals

    Brian Doyle 9780870717543

Qualifying orders ship free.
List price: $100.50
New Spiral
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
10 Partner Warehouse General- General

Skills for Success With Microsoft Excel 2010 Complete - With CD (11 Edition)


Skills for Success With Microsoft Excel 2010 Complete - With CD (11 Edition) Cover


Synopses & Reviews

Publisher Comments:

Microsoft Office 2010 is here! And this new release is aimed at making users more productive and efficient than ever.


Master the SKILLS of Excel 2010 with Kris Townsend's Skills for Success with Excel 2010 Comprehensive.

Highly visual with bulleted, step-by-step instruction to give you the skills you need to succeed with all the features and components of Excel 2010.


Skills for Success is the Microsoft Excel 2010 textbook that recognizes how students learn today!


Skills for Success is the Microsoft Excel 2010 textbook that recognizes how students learn today

About the Author

Kris Townsend is an Information Systems instructor at Spokane Falls Community College in Spokane, Washington. Kris earned a bachelor's degree in both Education and Business, and a master's degre in Education. He has also worked as a public school teacher and as a systems analyst. Kris enjoys working with wood, snowboarding, and camping. He commutes to work by bike and enjoys long rides in the Palouse country south of Spokane.

Table of Contents

Start! Common Features of Office 2010

Skill 1   Start Word and Navigate the Word Window

Skill 2   Start Excel and PowerPoint and Work with Multiple Windows

Skill 3   Save Files in New Folders

Skill 4   Print and Save Documents

Skill 5   Open Student Data Files and Save Copies Using Save As

Skill 6   Type and Edit Text

Skill 7   Cut, Copy, and Paste Text

Skill 8   Format Text and Paragraphs

Skill 9   Use the Ribbon

Skill 10  Use Shortcut Menus and Dialog Boxes

More Skills

More Skills 11 Capture Screens with the Snipping Tool

More Skills 12  Use Microsoft Office Help

More Skills 13 Organize Files

More Skills 14 Save Documents to Windows Live SkyDrive


Chapter 1 Work with Database Management Systems

Skill 1 Open and Organize Existing Database

Skill 2 Use Forms to Enter Data

Skill 3 Modify Queries and Create Reports

Skill 4 Format Datasheets and Modify Fields

Skill 5 Modify Data in Datasheet View

Skill 6 Sort Table Data and Hide Datasheet Columns

Skill 7 Filter, Summarize, and Print Datasheets

Skill 8 Create Relational Databases from Templates

Skill 9 Add Records to Tables that Enforce Referential Integrity

Skill 10 Format Reports

More Skills

More Skills 11 Compact and Repair Databases

More Skills 12 Convert Databases to Other File Formats

More Skills 13 Work with the Attachment Data Type

More Skills 14 Work with the Hyperlink and Yes/No Data Types


Chapter 2 Build Relational Databases and Create Forms

Skill 1 Design Relational Databases and Create Tables

Skill 2 Create Forms and Enter Data

Skill 3 Set Field Properties

Skill 4 Import Data from Excel

Skill 5 Create Lookup Fields

Skill 6 Create Relationships that Enforce Referential Integrity

Skill 7 Import Access Tables and Add Calculated Fields

Skill 8 Create Many-to-Many Relationships

Skill 9 Create Forms and Subforms Using the Form Wizard

Skill 10 Format One-to-Many Forms

More Skills

More Skills 11 Validate Fields

More Skills 12 Create Indexes and Establish One-to-One Relationships

More Skills 13 Create Multiple Item Forms

More Skills 14 Create and Format Split Forms


Chapter 3 Create Queries and Reports

Skill 1   Create Queries Using the Simple Query Wizard

Skill 2   Create Query-Based Label Reports

Skill 3   Create Queries in Design View and Add Numeric Criteria

Skill 4   Create Reports Using the Report Wizard

Skill 5   Add Summary Data and Modify Report Layouts

Skill 6   Use Format Painter and Apply Conditional Formatting

Skill 7   Create Parameter Queries

Skill 8   Create Reports Based on Parameter Queries

Skill 9   Group, Sort, and Filter Reports

Skill 10  Export Queries as Web Pages

More Skills

More Skills 11  Create Crosstab Queries

More Skills 12  Export Data to Excel and Save Export Steps

More Skills 13 Use Queries to Find Duplicate Records

More Skills 14  Use Queries to Find Unmatched Records


Chapter 4 Design Advanced Database Objects

Skill 1   Add Logical Operators to Queries

Skill 2   Create Forms Based on Queries

Skill 3   Add Wildcards to Query Criteria

Skill 4   Add Calculated Fields and Filter and Sort Queries

Skill 5   Add Summary Statistics to Queries

Skill 6   Use the Blank Form Tool and Apply Conditional Formatting

Skill 7   Customize Form Layouts

Skill 8   Create Reports in Design View and Add Calculated Controls

Skill 9   Format Reports in Design View

Skill 10  Customize the Navigation Pane

More Skills

More Skills 11  Encrypt Database Files

More Skills 12  Specify Relationship Join Types

More Skills 13  Create Macros

More Skills 14  Create Switchboard


Chapter 5: Add Advanced Report Features

Skill 1   Format Reports in Design View

Skill 2   Format Page Numbers and Date Controls

Skill 3   Create a Query within a Report

Skill 4   Concatenate Fields in a Query

Skill 5   Hide Repeated Values

Skill 6   Create a Subreport Using a Wizard

Skill 7   Create a Subreport Using the Drag and Drop Method

Skill 8   Format a Subreport in its Own Window

Skill 9   Create a Pie Chart

Skill 10 Format the Chart Legend and Plot Area

More Skills

More Skills 11 Align Controls in a Report

More Skills 12 Insert a Hyperlink Control in a Report

More Skills 13 Modify Control Padding and Margins

More Skills 14 Add ActiveX Controls to a Report


Chapter 6: Add Advanced Form Features

Skill 1   Create Forms in Design View

Skill 2   Position Controls in Forms

Skill 3   Change Tab Order

Skill 4   Add Button Controls to Forms

Skill 5   Create Pop Up Forms

Skill 6   Create PivotChart Forms

Skill 7   Create PivotTable Forms

Skill 8   Create Navigation Forms

Skill 9   Modify Navigation Forms

Skill 10 Add Pages to Navigation Forms

More Skills

More Skills 11 Add Option Groups to Forms

More Skills 12 Apply Conditional Formatting to Forms

More Skills 13 Apply Special Effects to Form Controls

More Skills 14 Insert Web Browser Controls into Forms


Chapter 7: Optimize Tables and Create Macros

Skill 1   Create Tables in Design View

Skill 2   Analyze Tables to Improve Performance

Skill 3   Adapt Tables Created by the Table Analyzer

Skill 4   Format Field Properties

Skill 5   Work with the Date Data Type

Skill 6   Create Tables Using Queries

Skill 7   Format Table Datasheets

Skill 8   Create Tables from Application Parts

Skill 9   Work with Table Events

Skill 10 Insert Quick Start Fields

More Skills

More Skills 11 Create New Field Data Types

More Skills 12 Create Input Masks

More Skills 13 Adjust Columns and Rows

More Skills 14 Check for Spelling Errors


Chapter 8: Integrate Data with other Applications

Skill 1   Import Data from Text Files

Skill 2   Export Data to Excel

Skill 3   Link to External Data Sources

Skill 4   Prepare Worksheet Data for Importing in Access

Skill 5   Import Data from Excel

Skill 6   Export Tables into Word

Skill 7   Import XML Data

Skill 8   Export XML Data

Skill 9   Export Data to HTML Documents

Skill 10 Merge Data into Word Documents

More Skills

More Skills 11 Create an Import or Export Specification

More Skills 12 Import a SharePoint List

More Skills 13 Manage E-Mail Replies

More Skills 14 Export a Table to a PDF Document


Chapter 9: Build Macros and Write VBA Procedures

Skill 1   Build and Test Client Macros

Skill 2   Add Comments and Reorder Macro Actions

Skill 3   Add Conditions to Macros

Skill 4   Test Macros with Conditions

Skill 5   Add Command Buttons that Run Macros

Skill 6   Add Quick Access Toolbar Buttons and Convert Macros to VBA

Skill 7   Create VBA Procedures

Skill 8   Write and Debug VBA Code

Skill 9   Write VBA Statements and Work with Variables

Skill 10 Add Conditions to VBA Procedures

More Skills

More Skills 11 Build Macros that Send Reports via E-Mail

More Skills 12 Build Macros to Navigate Forms

More Skills 13 Run a Macro on Startup

More Skills 14 Create Custom Menus


Chapter 10: Administer Databases and Work with SQL

Skill 1 Set Database Properties

Skill 2 Modify Queries in SQL View

Skill 3 Secure and Encrypt Databases

Skill 4 Change User Account Settings

Skill 5 Create Group and User Accounts

Skill 6 Secure User Accounts

Skill 7 Edit and Test Permissions

Skill 8 Replicate Databases

Skill 9 Synchronize Replicated Databases

Skill 10 Copy and Reset Access Security Settings

More Skills

More Skills 11 Package and Sign Databases

More Skills 12 Add Smart Tags

More Skills 13 Document Databases

More Skills 14 Use the Security Wizard

Product Details

Townsend, Kris
Prentice Hall
Vavalides, Philip
Hain, Catherine
Spreadsheets - General
Business -- Computer programs.
Electronic spreadsheets
Personal Computers-Desktop Applications-Spreadsheets
Skills for Success
Publication Date:
July 2010
Spiral, comb or coil bound book
Grade Level:
College/higher education:
8.4 x 10.3 x 0.7 in 771 gr

Related Subjects

» Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

Skills for Success With Microsoft Excel 2010 Complete - With CD (11 Edition) New Spiral
0 stars - 0 reviews
$79.50 In Stock
Product details 400 pages Prentice Hall - English 9780135100509 Reviews:
"Synopsis" by , Skills for Success is the Microsoft Excel 2010 textbook that recognizes how students learn today!
"Synopsis" by , Skills for Success is the Microsoft Excel 2010 textbook that recognizes how students learn today
  • back to top
Follow us on...

Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.