Skills for Success with Office 2010, Volume 1
Pearson
978-0-13-284032-3 (ISBN)
- Titel ist leider vergriffen;
keine Neuauflage - Artikel merken
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. Robert L. Ferrett recently retired as the Director of the Center for Instructional Computing at Eastern Michigan University, where he provided computer training and support to faculty. He has authored or co-authored more than 70 books on Access, PowerPoint, Excel, Publisher, WordPerfect, Windows, and Word. He has been designing, developing, and delivering computer workshops for more than two decades. Catherine Hain is an instructor at Central New Mexico Community College in Albuquerque, New Mexico. She teaches computer applications classes in the Business and Information Technology School, both in the classroom and through the distance learning office. Catherine holds a bachelor's degree in Management and Marketing and a master's degree in Business Administration. Alicia Vargas is an Associate Professor of Business Information Technology at Pasadena City College on California. She holds a bachelor's and a master's degree in Business Education from California State University, Los Angeles and has authored numerous textbooks and training materials on Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. Shelley Gaskin, Series Editor for the GO! Series, is a professor of business and computer technology at Pasadena City College in Pasadena, California. She holds a master's degree in business education from Northern Illinois University and a doctorate in adult and community education from Ball State University. Dr. Gaskin has 15 years of experience in the computer industry with several Fortune 500 companies and has developed and written training materials for custom systems applications in both the public and private sector. She is also the author of books on Microsoft Outlook and word processing.
Common Features
Chapter 1 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 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
Collaboration 1: Share SkyDrive Files and Folders
Word
Chapter 1 Create Documents with Word 2010
Skill 1 Create New Documents and Enter Text
Skill 2 Edit Text Use Keyboard Shortcuts
Skill 3 Select Text
Skill 4 Insert Text from Other Documents
Skill 5 Change Fonts, Font Sizes, and Font Styles
Skill 6 Insert and Work with Graphics
Skill 7 Check Spelling and Grammar
Skill 8 Use the Thesaurus and Set Proofing Options
Skill 9 Create Document Footers
Skill 10 Work with the Print Page and Save Documents in Other Formats
More Skills 11 Split and Arrange Windows
More Skills 12 Insert Symbols
More Skills 13 Use Collect and Paste to Create a Document
More Skills 14 Insert Screen Shots into Documents
Chapter 2 Format and Organize Text
Skill 1 Set Document Margins
Skill 2 Align Text and Set Indents
Skill 3 Modify Line and Paragraph Spacing
Skill 4 Format Text Using the Format Painter
Skill 5 Find and Replace Text
Skill 6 Create Bulleted and Numbered Lists
Skill 7 Insert and Format Headers and Footers
Skill 8 Insert and Modify Footnotes
Skill 9 Add Citations
Skill 10 Create Bibliographies
More Skills 11 Record AutoCorrect Entries
More Skills 12 Use AutoFormat to Create Numbered Lists
More Skills 13 Format and Customize Lists
More Skills 14 Manage Document Properties
Chapter 3 Work with Graphics, Tabs, and Tables
Skill 1 Insert Pictures from Files
Skill 2 Resize and Move Pictures
Skill 3 Apply Pictures Using Styles and Artistic Effects
Skill 4 Set Tab Stops
Skill 5 Enter Text with Tab Stops
Skill 6 Apply Table Styles
Skill 7 Create Tables
Skill 8 Add Rows and Columns to Tables
Skill 9 Format Text in Table Cells
Skill 10 FormatTables
More Skills 11 Insert Text Boxes
More Skills 12 Format with WordArt
More Skills 13 Create Tables from Existing Lists
More Skills 14 Insert Drop Caps
Chapter 4 Apply Special Text, Paragraph, and Document Formats
Skill 1 Create Multiple-Column Text
Skill 2 Insert a Column Break
Skill 3 Apply and Format Text Effects
Skill 4 Use and Create Quick Styles
Skill 5 Add Borders and Shading to Paragraphs and Pages
Skill 6 Insert and Format Clip Art Graphics
Skill 7 InsertSmartArt Graphics
Skill 8 FormatSmartArt Graphics
Skill 9 Create Labels Using Mail Merge
Skill 10 Preview and Print Mail Merge Documents
More Skills 11 Create Resumes from Templates
More Skills 12 Create Outlines
More Skills 13 Prepare Documents for Distribution
More Skills 14 Preview and Save Documents as Web Pages
Integration 1: Format Research Papers and Include Information from the Web
Integration 2: Use Excel Data in Word Mail Merge
Collaboration 2: Create Flyers using Word Web App
Excel
Chapter 1 Create Workbooks with Excel 2010
1.1 Create and Save New Workbooks
1.2 Enter Worksheet Data and Merge and Center Titles
1.3 Construct Addition and Subtraction Formulas
1.4 Construct Multiplication and Division Formulas
1.5 Adjust Column Widths and Apply Cell Styles
1.6 Use the SUM Function
1.7 Copy Formulas Using the Fill Handle
1.8 Format, Edit, and Check the Spelling of Data
1.9 Create Footers and Change Page Settings
1.10 Display and Print Formulas and Scale Worksheets for Printing
More Skills 11 Create New Workbooks from Templates
More Skills 12 Use Range Names in Formulas
More Skills 13 Change the Theme
More Skills 14 Manage Document Properties
Chapter 2 Create Charts
Skill 1 Open Existing Workbooks and Align Text
Skill 2 Construct and Copy Formulas Containing Absolute Cell References
Skill 3 Format Numbers
Skill 4 Create Column Charts
Skill 5 Format Column Charts
Skill 6 Create Pie Charts and Chart Sheets
Skill 7 Apply 3-D Effects and Rotate Pie Chart Slices
Skill 8 Explode and Color Pie Slices and add Text Boxes
Skill 9 Update Charts and Insert WordArt
Skill 10 Prepare Chart Sheets for Printing
More Skills 11 Add and Edit Comments
More Skills 12 Change Chart Types
More Skills 13 Copy Excel Data to Word Documents
More Skills 14 Fill Series Data into Worksheet Cells
Chapter 3 Manage Multiple Worksheets
Skill 1 Work with Sheet Tabs
Skill 2 Enter and Format Dates
Skill 3 Clear Cell Contents and Formats
Skill 4 Move, Copy, Paste, and Paste Options
Skill 5 Work with Grouped Worksheets
Skill 6 Use Multiple Math Operators in a Formula
Skill 7 Format Grouped Worksheets
Skill 8 Insert and Move Worksheets
Skill 9 Construct Formulas that Refer to Cells in Other Worksheets
Skill 10 Create Clustered Bar Charts
More Skills 11 Create Organization Charts
More Skills 12 Create Line Charts
More Skills 13 Set and Clear Print Areas
More Skills 14 Insert Hyperlinks
Chapter 4 Use Excel Functions and Tables
Skill 1 Use the SUM and AVERAGE Functions
Skill 2 Use the MIN and MAX Functions
Skill 3 Move Ranges with Functions, Add Borders, and Rotate Text
Skill 4 Use the IF Function
Skill 5 Apply Conditional Formats with Custom Formats, Data Bars, and Sparklines
Skill 6 Use Find and Replace and Insert the NOW Function
Skill 7 Freeze and Unfreeze Panes
Skill 8 Create and Sort Excel Tables
Skill 9 Use the Search Filter in Excel Tables
Skill 10 Convert Tables to Ranges, Hide Rows and Columns, and Format Large Worksheets
More Skills 11 Apply Conditional Color Scales with Top and Bottom Rules
More Skills 12 Use the Payment (PMT) Function
More Skills 12 Create PivotTable Reports
More Skills 14 Use Goal Seek
Integration 3: Import Word Tables into Excel Worksheets
Integration 4: Insert and Link Excel Tables and Charts into Word Documents
Integration 5: Refer to Cells in other Workbooks
Collaboration 3: Create Excel Web App Workbooks
Access
Chapter 1 Work with Databases and Create Tables
Skill 1 Open and Organize Existing Databases
Skill 2 Enter and Edit Table Data
Skill 3 Create Forms and Enter Data
Skill 4 Filter Data in Queries
Skill 5 Create, Preview and Print Reports
Skill 6 Create Databases and Tables
Skill 7 Change Data Types and Other Field Properties
Skill 8 Create Tables in Design View
Skill 9 Relate Tables
Skill 10 Enter Data in Related Tables
More Skills 11 Compact and Repair Databases
More Skills 12 Import Data from Excel
More Skills 13 Work with the Attachment Data Type
More Skills 14 Work with the Hyperlink and Yes/No Data Types
Chapter 2 Manage Datasheets and Create Queries
Skill 1 Find and Replace Data
Skill 2 Filter and Sort Datasheets
Skill 3 Use the Simple Query Wizard
Skill 4 Format Datasheets
Skill 5 Add Date and Time Criteria
Skill 6 Create Queries in Design View
Skill 7 Add Calculated Fields to Queries
Skill 8 Work with Logical Criteria
Skill 9 Add Wildcards to Query Criteria
Skill 10 Group and Total Queries
More Skills 11 Export Queries to Other File Formats
More Skills 12 Find Duplicate Records
More Skills 13 Find Unmatched Records
More Skills 14 Create Crosstab Queries
Chapter 3 Create Forms
Skill 1 Use the Form Wizard
Skill 2 Format Forms in Layout View
Skill 3 Use Forms to Modify Data
Skill 4 Use the Blank Form Tool
Skill 5 Customize Form Layouts
Skill 6 Add Input Masks
Skill 7 Apply Conditional Formatting
Skill 8 Create One-to-Many Forms
Skill 9 Enter Data Using One-to-Many Forms
Skill 10 Create Forms from Queries
More Skills 11 Validate Fields
More Skills 12 Add Combo Boxes to Forms
More Skills 13 Create Multiple Item Forms
More Skills 14 Create Macros
Chapter 4 Create Reports
Skill 1 Create Reports and Apply Themes
Skill 2 Modify Report Layouts
Skill 3 Prepare Reports for Printing
Skill 4 Use the Blank Report Tool
Skill 5 Group and Sort Reports
Skill 6 Format and Filter Reports
Skill 7 Create Labels Reports
Skill 8 Use the Report Wizard
Skill 9 Modify Layouts in Design View
Skill 10 Add Totals and Labels to Reports
More Skills 11 Export Reports to Word
More Skills 12 Export Reports to HTML Documents
More Skills 13 Create Parameter Queries
More Skills 14 Create Reports for Parameter Queries
Integration 6: Print Envelopes from Access Queries
Integration 7: Export Access Data to Word Documents
Collaboration 4: Create Windows Live Groups and OneNote Documents
PowerPoint
Chapter 1 Getting Started with PowerPoint 2010
Skill 1 Open, View, and Save Presentations
Skill 2 Edit and Replace Text in Normal View
Skill 3 Format Slide Text
Skill 4 Check Spelling and Use the Thesaurus
Skill 5 Insert Slides and Modify Slide Layouts
Skill 6 Insert and Format Pictures
Skill 7 Organize Slides Using Slide Sorter View
Skill 8 Apply Slide Transitions and View Slide Shows
Skill 9 Insert Headers and Footers and Print Presentation Handouts
Skill 10 Add Notes Pages and Print Notes
More Skills 11 Type Text in the Outline Tab
More Skills 12 Use Keyboard Shortcuts
More Skills 13 Move and Delete Slides in Normal View
More Skills 14 Design Presentations for Audience and Location
Chapter 2 Format a Presentation
Skill 1 Create a New Presentation
Skill 2 Change Presentation Themes
Skill 3 Apply Font and Color Themes
Skill 4 Format Backgrounds with Styles
Skill 5 Format Slide Backgrounds with Pictures and Textures
Skill 6 Format Text with WordArt
Skill 7 Change Character Spacing and Font Color
Skill 8 Modify Bulleted and Numbered Lists
Skill 9 Move and Copy Text and Objects
Skill 10 Use Format Painter and Clear All Formatting Commands
More Skills 11 Edit Slide Master
More Skills 12 Save and Apply a Presentation Template
More Skills 13 Create Slides from a Microsoft Word Outline
More Skills 14 Design Presentations with Contrast
Chapter 3 Enhance a Presentation with Graphics
Skill 1 Insert Slides from Other Presentations
Skill 2 Insert, Size, and Move Clip Art
Skill 3 Modify Picture Shapes, Borders, and Effects
Skill 4 Insert, Size, and Move Shapes
Skill 5 Add Text to Shapes and Insert Text Boxes
Skill 6 Apply Gradient Fills and Group and Align Graphics
Skill 7 Convert Text to SmartArt Graphics and Add Shapes
Skill 8 Modify Smart Art Layouts, Colors, and Styles
Skill 9 Insert Video Files
Skill 10 Apply Video Styles and Adjust Videos
More Skills 11 Compress Pictures
More Skills 12 Save Groups as Picture Files
More Skills 13 Change Object Order
More Skills 14 Design Presentations Using Appropriate Graphics
Chapter 4 Present Data Using Tables, Charts, and Animation
Skill 1 Insert Tables
Skill 2 Modify Table Layouts
Skill 3 Apply Table Styles
Skill 4 Insert Column Charts
Skill 5 Edit and Format Charts
Skill 6 Insert Pie Charts
Skill 7 Apply Animation Entrance and Emphasis Effects
Skill 8 Modify Animation Timing and Use Animation Painter
Skill 9 Remove Animations and Modify Duration
Skill 10 Navigate Slide Shows
More Skills 11 Prepare Presentations to be Viewed Using PowerPoint Viewer
More Skills 12 Insert Hyperlinks in a Presentation
More Skills 13 Create Photo Albums
More Skills 14 Design Presentations with Appropriate Animation
Integration 8: Copy and Paste Objects between Office Documents
Integration 9: Send PowerPoint Handouts to Word
Integration 10: Create Hyperlinks to Office Documents
Collaboration 5: Edit Presentations Using PowerPoint Web App
| Erscheint lt. Verlag | 9.2.2012 |
|---|---|
| Sprache | englisch |
| Maße | 217 x 276 mm |
| Gewicht | 1150 g |
| Themenwelt | Informatik ► Office Programme ► Office |
| ISBN-10 | 0-13-284032-4 / 0132840324 |
| ISBN-13 | 978-0-13-284032-3 / 9780132840323 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
