Learning Microsoft Office 2010 Deluxe Editions (Hard Cover) -- CTE/School

Learning Microsoft Office 2010 Deluxe Editions (Hard Cover) -- CTE/School

By: Catherine Skintik (author), Suzanne Weixel (author), Emergent Learning LLC (author), Faithe Wempen (author)Hardback

Up to 2 WeeksUsually despatched within 2 weeks


Prepare students for Microsoft (R) Office 2010!Learning Microsoft (R) Office 2010 features a student-friendly, step-by-step format with clear, full-screen shots to engage students and help them work independently. Learning Microsoft (R) Office 2010 provides hands-on exercises and applications to teach students the new features of Microsoft (R) Office 2010.


Deluxe Edition Learning Microsoft Office 2010 Part 1 Microsoft Office Basics Chapter 1: Using the Common Features of Microsoft Office 2010 About Business Technology * Disuss different input technologies including speech recognition, hand-writing recognition, and keyingAbout Microsoft Office 2010* Disucss operating system technologyUse the Mouse Navigate with Windows ExplorerCreate a FolderConventions Used in This BookLesson 1. Start and Exit Microsoft Office Programs Identify Common Screen Elements View Application OptionsEnter and Edit TextSave a FilePrint a FileClose a FileLesson 2. About Commands About the Ribbon Use the RibbonUse Access KeysLesson 3. Use the Quick Access ToolbarUse a Mini ToolbarUse Shortcut menusUse Dialog Box Options Use Task PanesLesson 4. Open an Existing File and Save it with a New NameFormatting and Viewing PagesFormatting TextUsing the Office ClipboardLesson 5. Use Window Controls ZoomScroll Use Multiple WindowsLesson 6. Use the Help Program Search for Help Use the Help Table of ContentsRecover a File Lesson 7. Copy and Move Files and FoldersCompressing FilesTypes of Business Documents (letters, memos, press releases, publications, spreadsheets, presentations, databases, e-mail, Web pages, reports, research papers, financial documents, etc.)Lesson 8. Determine the Risks and Rewards of Developing an IT StrategyAdjust IT Needs to Suit the EnvironmentIdentify Needed Equipment and SuppliesEstablish, Schedule, and Follow Maintenance ProceduresEnd of Chapter Projects Part 2 Word Chapter 1 Getting Started with Word 2010 Lesson 1. Start Word Explore the Word Window Show/Hide Marks Type in a DocumentMove the Insertion Point in a Document Type in the Header or FooterSave ChangesPreview and Print a DocumentLesson 2. Create a New Document Use Click and TypeApply a ThemeSelect a Built-In StyleClose a DocumentLesson 3. Exercise 11Open a Saved DocumentInsert and Overtype Text Change the Document ViewCorrect ErrorsUse Undo, Redo, and Repeat Save a Document with a New NameLesson 4. Select Text in a DocumentReplace Selected TextAlign Text Horizontally Align a Document Vertically Set Line SpacingSet Paragraph Spacing Lesson 5. Set and Modify TabsIndent TextInsert the Date and Time Format a Modified-Block Business LetterCreate an Envelope Lesson 6. About FontsChange the FontChange Font SizeApply Font StylesApply UnderlinesApply Text EffectsClear Formatting Lesson 7. Create Bulleted ListsCreateNumbered ListsCustomize BulletsSort Lesson 8. Insert and Resize PicturesScan a Picture for use in a DocumentMoving a PictureWrap Text Around a PictureApply Picture Styles and Artistic EffectsAdd a Page BorderLesson 9. Insert a Text BoxMove, Resize, and Format a Text BoxInsert a ShapeMove, Resize, and Format a ShapeLesson 10. Insert a SmartArt GraphicModify a SmartArt GraphicEnd of Chapter Projects Chapter 2 Editing Documents and Using Tables Lesson 11. Correct Spelling as You TypeCorrect Grammar as You TypeCheck Spelling and GrammarUse the ThesaurusUnderstand HyphenationLesson 12. Move TextUse Cut and PasteUse Paste PreviewUse Paste SpecialUse the Clipboard Task Pane Use Drag-and-Drop Editing Select Paste Formatting Options Move a Paragraph Lesson 13. Use Copy and PasteUse Drag-and-Drop Editing to CopyLesson 14. Create a Table Enter Data in a Table Select in a Table Change Table StructureFormat a TableLesson 15. Insert Existing Text into a Table CellSet Alignments within Table CellsCreate a Bullet List in a TableSet Cell Margins Align a Table on the Page Set Column Width and Row HeightLesson 16. Draw a TableMove and Resize Tables Merge and Split Cells Rotate Text in a CellWrap Text around a TableLesson 17. Perform Calculations in a Table Select Number Formats ina TableSort Rows in TableApply Cell Borders and ShadingLesson 18. Create a Custom Header LetterheadUse Find and ReplaceUse Document Map and Thumbnails?Use AutoCorrect Lesson 19. Creating a Document (resume) Based on a TemplateReplacing Template Placeholder TextRemoving Template ControlsRecognize Different File Types Save a Document as a Web PageEnd of Chapter Projects Chapter 3 Creating Reports and Newsletters Lesson 20. Use Uppercase Mode Change Case Manage Document Properties Lesson 21. Analyze Document ProductionSet MarginsSet Page Orientation Insert Page NumbersCheck the Word CountFormat a One-Page Report Lesson 22. Understanding Sources and Citations, including coverage of Plagiarism, Fair Use, Copyright Laws as relates to information producers such as authors, artists, and Website developers* Evaluate and select appropriate sources of information (e.g. print, video, electronic, and human) for a specific research problem or question.* Demonstrate the ability to use bookmarks and internet search engines to access information by identifying and conducting basic and advanced searches using internet/intranet search engines, directories, biographical dictionaries and thesauri.* Validate the accuracy of information during a research topic by reviewing each author's credentials, perspective, or bias.Footnotes and Endnotes Adding CitationsInsert a Page BreakControl Text FlowCreate a Reference PageLesson 23. Understand Desktop Publishing Create Newsletter Columns Set Column WidthInsert Column Breaks Balance ColumnsAnalyze Layout and DesignLesson 24. Insert Dropped Capitals Enhance a Document with Borders and ShadingLesson 25. Apply Font EffectsChange the Font Color Highlight Text Use the Format PainterLesson 26. Insert Symbols Insert a Captured ScreenLesson 27. Create Mailing Labels using the Mail Merge WizardEnd of Chapter Projects Chapter 4 Learning More about Mail MergeLesson 28. Mail Merge BasicsUse Mail MergeCreate a New Address ListUse Merge FieldsLesson 29. Merge with an Existing Address ListEdit an Address List Customize Merge Fields Merge Envelopes and Labels Create EnvelopesLesson 30. Sort Recipients in an Address List Select Specific RecipientsCreate a Directory with Mail MergeLesson 31. Filter RecipientsMerge to an E-mail Message End of Chapter Projects Chapter 5 Word and the World Wide Web Lesson 32. Understanding the Internet and the World Wide Web Create a Web Page Document in Word Use Web Layout View View a Web Page Document in a Browser Lesson 33. Open a Web Page Document in Word Use Web Page Titles Apply a Background Create HyperlinksLesson 34. Describe telecommunications skills needed to communicate effectively with peers, experts, teachers, and other audiences, e.g. using e-mail, e-learning, video conferencing, instant messaging, chat and blogs, newsgroups, net meetings.Send a Document as an E-mail AttachmentSave a Document as PDFCreate a Blog PostEnd of Chapter Projects Part 3 Excel Lesson 1 Getting Started with Excel 2010Lesson 1. Start Excel Name and Save a WorkbookExplore the Excel WindowExplore the Excel Interface Navigate the Worksheet Change Between Worksheets Change Worksheet Views Exit ExcelLesson 2. Create a New (Blank) WorkbookEnter Text and LabelsEdit TextUse Undo and Redo Clear Cell Contents Insert a Built-in Header or FooterSave a WorkbookPreview and Print a WorksheetClose a Workbook Lesson 3. Open an Existing Workbook and Save it with a New NameEnter and Edit Numeric Labels and ValuesUse AutoComplete Pick From List Use AutoCorrectCheck the Spelling in a WorksheetLesson 4. Choose a ThemeApply Cell Styles (Quick Styles) Apply Font Formats Merge and Center Across CellsApply Number Formats (financials)Lesson 5. Enter Dates Fill a SeriesAlign Data in a CellChange Column Width Wrap Text in CellsUse Keyboard ShortcutsLesson 6. Entering Data by Range Select RangesRange Entry Using Collapse ButtonLesson 7. Enter a FormulaUse the Sum FunctionEdit a Formula Copy a Formula Using the Fill HandleUse Arithmetic OperatorsLesson 8. Copy and Paste Data Copy FormatsCopy Formulas Containing a Relative Reference Copy Formulas Containing an Absolute ReferenceLesson 9. Insert and Delete Columns and RowsCut and Paste DataUse Drag-and-Drop Editing Lesson 10. Create a Column ChartDelete Unused Sheets in a WorkbookDisplay, Print, and Hide FormulasPreview and Print a Worksheet End of Chapter Projects Chapter 2 Working with Functions, Formulas, and Charts Lesson 11. Use Functions (SUM, AVERAGE, MEDIAN, MIN, and MAX)Insert a Function Use AutoCalculateLesson 12. Create an Excel TableSort and Filter an Excel TableConvert a Table to a Range Lesson 13. Use the NOW Function to Display a System Date Use Named RangesLesson 14. Understand IF Functions Nested IF Functions =SUMIF() and SUMIFS() Functions =COUNTIF() and COUNTIFS() Functions Lesson 15. Freeze Labels While Scrolling Split a Worksheet into PanesLesson 16. Apply Conditional Formatting (highlight cells rules and data bars)Use Find and ReplaceLesson 17. Move Data and Resolving a # # # # Error MessageRotate TextLesson 18. Print Titles Scale to Fit Lesson 19. Insert, Delete, Copy, Move, and Rename Worksheets Change the Color of a Worksheet Tab Hide SheetsGroup Worksheets for EditingFormat and Construct Formulas on Grouped WorksheetsLesson 20. Construct Formulas that Refer to Cells in Another Worksheet (create a Summary sheet)Change Values in a Detail Worksheet to Update a Summary WorksheetPrint All the Worksheets in a WorkbookEnd of Chapter Projects Chapter 3 Charting Data Lesson 21. Analyze Chart Basics Select Chart DataChart ElementsCreate Charts Change Chart Types Select a ChartResize, Copy, Move, or Delete a Chart Lesson 22. Calculate PercentagesUse Formula AutoCompleteCreate a Pie Chart with a Chart SheetLesson 23. Apply 3-D to a Pie ChartRotate Slices in a Pie ChartExplod and Coloring a Pie ChartFormat the Chart Area of a Pie ChartLesson 24. Insert a Text Box in a ChartUpdate a ChartInsert WordArt in a WorksheetPrepare and Printing a Chart SheetLesson 25. Change Data Series Orientation Format a ChartResize, Move, or Delete a Chart ObjectChange Chart Text Enhance Chart Background Format Category and Value Axes Lesson 26. Use Parentheses in a FormulaCalculatea Value After an IncreasePerform What-If AnalysisUse Paste SpecialCreate a Line Chart to Compare DataLesson 27. Print a Chart Publish Chart to the Internet/Intranet Lesson 28. Paste a Picture of a Chart Link a Chart Embed a Chart into a Word DocumentEdit a Linked or Embedded Chart Lesson 29. Create Organization ChartsCreate SmartArt End of Chapter Projects Chapter 4 Advanced Functions, PivotCharts, and PivotTables Lesson 30. Create Predictions and Estimations Use FORECASTUse TRENDUse GROWTH Lesson 31. Use the PMT Function Create What-If Data Tables Solve a Problem with Goal SeekUse Solver to Resolve Problems Lesson 32. Create Lookup FunctionsLesson 33. Create PivotTables and PivotChartsUse the PivotTable Field ListEnd of Chapter Projects Chapter 5 Advanced Printing, Formatting, and EditingLesson 34. Insert and Format GraphicsSave a Worksheet as a Web PageLesson 35. Copy Data from a Web PageCreate a Web Query Lesson 36. Link and Embed Excel Data Link DataEdit Linked DataEmbed Data Edit Embedded Data Lesson 37. Create a Workbook from a Template Change from Workbook to Workbook Compare Workbooks Lesson 38. Insert CommentsPrint Multiple Copies of a Workbook or WorksheetModify Page Setup Customize Headers and Footers Use Page Layout ViewLesson 39. Insert Page Breaks Use Page Break Preview Set the Print AreaRepeat Row and Column Labels Select Other Sheet Tab Options Lesson 40. Use Copy and Paste SpecialTranspose Data Combine Data with Copy and Paste SpecialLesson 41. Drag-and-Drop Data Between Workbooks Link Workbooks Lesson 42. Create 3-D Formulas Duplicate a Workbook Window End of Chapter Projects Part 4 Microsoft Office Access 2010CHAPTER 1: Getting Started with Access 2010Lesson 1. Plan a DatabaseProjects 1-2Exploring Database Concepts Analyzing a Database Management System Analyzing Access Objects and Database Organization Understanding How Access Tables are RelatedPlanning Database Tables and RelationshipsPlanning the Field TypesLesson 2. Create a Database with AccessProjects 3-4Starting Access and Create a New Blank DatabaseExploring the Access WindowCreating Table Fields in Datasheet ViewSaving, Closing, and Reopening a TableCreating Additional TablesClosing and Opening a DatabaseSaving a Copy of a DatabaseLesson 3. Modify and Add Data to a TableProjects 5-6Adding Records Editing Records Selecting Records Deleting RecordsLesson 4. Modify Fields in a DatasheetProjects 7-8Changing Field Properties from Datasheet ViewAdding a Field Renaming a FieldDeleting a FieldMoving a Column Hiding and Unhiding ColumnsChanging Datasheet Column Widths Freezing ColumnsLesson 5. Import and Protect DataProjects 9-10Import Data from Excel to an Existing TableImport Data from Excel to a New TablePreview and Print a TableOpen a Database Exclusively Set a Database Password Change Database PropertiesLesson 6. Use Table Templates and Design ViewProjects 11-12Create a New Database using a TemplateCreate a Table with a TemplateCreate a Table in Design View Set a Primary Key Change a Field's Data Type Modify a Field's PropertiesLesson 7. Create Other ObjectsProjects 13-14Use the Simple Query Wizard to Create a QueryCreate a QuickFormEnter Records using a FormEnter Records using a Multiple Items FormCreate and Modify a Quick ReportPreview and Print a ReportEnd-of-Chapter ExercisesProjects 15-16CHAPTER 2: Working with QueriesLesson 8. Managing Relationships Between TablesProjects 17-18Renaming a Table Relating TablesEnforcing Referential Integrity Showing related recordsPrinting a relationship reportLesson 9. Finding, Replacing, and Sorting DataProjects 19-20Finding DataReplacing DataSearching Using WildcardsSorting Records in a Table in Ascending or Descending OrderSorting Records in a Table Using Multiple FieldsRemoving a SortLesson 10. Filtering DataProjects 21-22Filtering by selectionFiltering for multiple selectionsFiltering with comparison operators Filtering by formSaving filter results as a queryLesson 11. Creating a Query in Design ViewProjects 23-24Understanding Data Analysis Exploring Data Mining Tools, Techniques, and EthicsUnderstanding Database Trends Understanding Queries Creating a New Select Query in Design ViewRunning a QuerySaving and Printing a QueryLesson 12. Creating a Multi-Table QueryProjects 25-26Creating a Query Based on More than One TableSorting Query ResultsReordering Fields in a QueryUsing All Fields of a TableCreating a new Query from an Existing Query Saving a Query with a Different NameLesson 13. Using Criteria in a QueryProjects 27-28Specify Text Criteria in a QuerySpecify Numeric Criteria in a QuerySpecify Criteria Using a Field Not Displayed in the Query ResultsUsing Null Criteria to Find Blank FieldsLesson 14. Using Comparison OperatorsProjects 29-30Using Comparison OperatorsUsing Wildcards and the Like OperatorUsing the Between...And Comparison OperatorUsing the In OperatorCombining CriteriaLesson 15. Using Calculated FieldsProjects 31-32Understanding Calculated FieldsCreating a Calculated Field in a TableUsing Calculated Fields in a QueryLesson 16. Summarizing Data in QueriesProjects 33-34Understanding Summary QueriesSummarizing with the Simple Query WizardSummarizing Data in Query Design View End-of-Chapter ExercisesProjects 35-36 CHAPTER 3: Working with Forms and ReportsLesson 17. Creating a Lookup ListProjects 37-38Creating a LookupCreating a Value ListLooking Up Field Values from Another TableCreating a Multivalued Field Lesson 18. Creating an Input MaskProjects 39-40Creating an Input Mask using the Input Mask WizardCreating an Input Mask using the Input Mask Properties BoxLesson 19. Creating and Using a FormProjects 41-42Understanding FormsCreating a Form with a WizardApplying a Theme to a Form Adding Records to a Table by Using a FormDeleting Records from a Table by Using a FormPrinting a FormLesson 20. Working with a Form in Layout ViewProjects 43-44Understanding Layout View Creating a Form in Layout View Sizing a ControlMoving Controls in the Layout Deleting a Control Adjusting the Control Margins and Control Padding Changing Control Formatting Lesson 21. Working with a Form in Design ViewProjects 45-46Exploring Design View and Resizing FieldsSelecting and Moving ControlsResetting Tab OrderChanging the Form SizeInserting an Unbound Label Creating a New Form in Design View Lesson 22. Working with Form SectionsProjects 47-48Understanding SectionsDisplaying and Resizing SectionsInserting a Form TitleAdding Date/Time CodesMoving Controls Between SectionsLesson 23. Creating a ReportProjects 49-50Understanding Access Reports Creating and Formatting a Report in Layout ViewCreating a Report Using the Report WizardModifying a Report in Design DivewWorking with Print Preview and Report ViewsPrinting a Report Lesson 24. Modifying a Report in Design ViewProjects 51-52Working with Headers and Footers Moving a Control Between Sections Adding Page Number Codes Adding Sorting and Grouping Adding a Calculated Field to a Report Lesson 25. Creating LabelsProjects 53-54Understanding Labels Using the Label WizardEnd-of-Chapter ExercisesProjects 55-56 Part 5 Microsoft Office PowerPointChapter 1 Getting Started with PowerPoint Lesson 1. Start PowerPointExplore the PowerPoint Window Understand Placeholders Enter Text Apply a ThemeCheck the Spelling in a PresentationPreview a Slide ShowPrint a Slide ShowSave and Close a PresentationLesson 2. Open an Existing Presentation and Save it with a New NameInsert New SlidesIncrease or Decrease List LevelsMove from Slide to SlideChange Slide LayoutLesson 3. Insert a Slide with a Different Slide LayoutInsert a Picture from a File Scan a Picture for use in a PresentationFormat Pictures using Styles and Artistic EffectsLesson 4. Insert a Slide from a Different PresentationInsert Headers and Footers including the Date, and Slide NumbersAdd Speaker NotesLesson 5. Find and Replace Text in a PresentationUse Undo and RedoSelect Text and Placeholders Change the Appearance of Text using Fonts, Font Sizes, Font Styles and Font ColorCopy Text Formatting Clear Formatting from a SelectionLesson 6. Align Text Adjust Line SpacingAdjust Paragraph SpacingUse AutoFit Options Move and Copy Text Adjust and Format Placeholders Lesson 7. Display and Edit Slides in the Slide PaneDisplay and Edit the Presentation OutlineView and Edit a Presentation in Reading ViewLesson 8. Copy, Duplicate and Delete SlidesRearrange SlidesDelete Slides in Slide Sorter ViewMove Slides in Slide Sorter ViewLesson 9. Identify Guidelines for Using Graphics, Fonts, and Special Effects in PresentationsAdd Slide TransitionsControl Slide AdvanceChapter 2 Working with Lists and GraphicsLesson 10. Change a Bullet List to a Numbered ListModify the Bullet List StyleRemove a Bullet Symbol from a Bullet PointLesson 11. Insert Clip ArtResize and Position Clip ArtChange the Shape of a PictureRemove the Background from a PictureLesson 12. Insert Symbols Insert and Format a Text BoxCreate Column Text in a Text BoxLesson 13. Use Rulers, Guides, and GridlinesDraw and Format ShapesAdd Text to ShapesLesson 14. Apply Shape Fills, Outlines and StylesApply Shape and Picture EffectsDuplicate ObjectsAlign and Distribute ObjectsLesson 15. Apply WordArt Styles to ExistingTextInsert and Format WordArt Lesson 16. Create a SmartArt Diagram from Bullet PointsAdd and Resize Shapes in a DiagramInsert a SmartArt Graphic using a Content LayoutChange the Diagram TypeChange the Color and Style of a DiagramLesson 17. Create a Photo AlbumChapter 3 Enhancing a PresentationLesson 18. Change Background StyleChange Theme Colors Change Theme Fonts Create New Theme Fonts Lesson 19. Create Slides from an Outline Hide Background GraphicsFormat a Slide Background with a PictureApply a Background Fill ColorReset the Slide BackgroundLesson 20. Apply Entrance EffectsSet Effect and Timing optionsApply Animation Effects with Animation PainterApply Animations to Objects and SmartArt GraphicsLesson 21. Analyze the Effectiveness of Multimedia Presentations (BIM supplement)Review input options: digital cameras, digital camcorders, scanners, etc. and copyright lawsInsert a VideoEdit a VideoApply Video StylesAdjust Video ColorInsert Sounds and Music Lesson 22. Insert a Table Format or Modify a Table Lesson 23. Insert a Column ChartFormat or Modify a Chart Animate a ChartChapter 4 Finalizing a PresentationLesson 24. Create Notes Pages and HandoutsChange Slide Size and OrientationPrint Presentation MaterialsLesson 25. Understand the Slide MasterCustomize Slide Master ElementsCreate a Custom LayoutWork with Notes and Handouts MastersLesson 26. Create a Presentation from a TemplateInsert or Link Excel Worksheet DataLesson 27. Create a Theme or Template Apply Custom Themes and Templates Create a Looping Presentation that Runs AutomaticallyLesson 28. Create a Custom Show Insert Links on SlidesInsert an Action Button Lesson 29. Rehearse Timings Hide SlidesSet Slide Show Options Control Slides During a Presentation Annotate Slides During a PresentationLesson 30. Send a Presentation for ReviewFinalize a Presentation Lesson 31. Package a Presentation for CD Broadcast a SlideshowPublish Slides

Product Details

  • ISBN13: 9780135108406
  • Format: Hardback
  • Number Of Pages: 960
  • ID: 9780135108406
  • weight: 2041
  • ISBN10: 0135108403

Delivery Information

  • Saver Delivery: Yes
  • 1st Class Delivery: Yes
  • Courier Delivery: Yes
  • Store Delivery: Yes

Prices are for internet purchases only. Prices and availability in WHSmith Stores may vary significantly