Learning Microsoft Office 2010, Advance... | WHSmith Books
Learning Microsoft Office 2010, Advanced Student Edition -- CTE/School

Learning Microsoft Office 2010, Advanced Student Edition -- CTE/School

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

Up to 2 WeeksUsually despatched within 2 weeks

Description

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.

Contents

Introduction viiMicrosoft Word 2010Chapter 1 Using Advanced Lists and Charts 2Lesson 1 - Inserting text Files and Blank Pages 4Lesson 2 - Creating and Editing Styles 10Lesson 3 - Managing Style Formatting 17Lesson 4 - Creating Multilevel Lists 23Lesson 5 - Inserting Charts 29End-of-Chapter Assessments 37 Chapter 2 Using Reusable Content and Markup Tools 40Lesson 6 - Translating Text and Customizing Word Options 42Lesson 7 - Using Advanced Find and Replace 51Lesson 8 - Using Building Blocks 60Lesson 9 - Inserting Fields from Quick Parts 67Lesson 10 - Creating Custom Themes 73Lesson 11 - Using Comments 79Lesson 12 - Tracking Changes 85Lesson 13 - Comparing Documents 92End-of-Chapter Assessments 101 Chapter 3 Using Advanced Tables and Graphics 106Lesson 14 - Customizing Table Styles 108Lesson 15 - Using Advanced Table Features 115Lesson 16 - Using Advanced Graphics 125Lesson 17 - Linking Text Boxes 134Lesson 18 - Creating WordArt and Watermarks 144End-of-Chapter Assessments 151 Chapter 4 Protecting Documents and Forms 156Lesson 19 - Creating Forms 158Lesson 20 - Protecting Documents 166Lesson 21 - Inspecting and Checking Documents 174Lesson 22 - Marking a Document as Final and Using Digital Signatures 179End-of-Chapter Assessments 187 Microsoft Excel 2010Chapter 1 Managing Large Workbooks and Using Advanced Sorting and Filtering 192Lesson 1 - Customizing the Excel Interface and Converting Text 195Lesson 2 - Formatting Cells 202Lesson 3 -Hiding and Formatting Workbook. 208Lesson 4 - Customizing Styles and Themes. 216Lesson 5 - Using Advanced Sort. 222Lesson 6 - Using Advanced Filtering. 229Lesson 7 - Customizing Data Entry. 241Lesson 8 - Using Find and Replace. 246Lesson 9 - Working with Hyperlinks. 252Lesson 10 - Saving Excel Data in a Different File Format. 260Lesson 11 - Working with Subtotals. 264End of Chapter Assessments . 273 Chapter 2 Creating Charts, Shapes, and Templates . 278Lesson 12 - Formatting Chart Elements. 280Lesson 13 - Formatting the Value Axis. 287Lesson 14 - Creating Stacked Area Charts . 295Lesson 15 - Working with Sparklines. 301Lesson 16 - Drawing and Positioning Shapes . 307Lesson 17 - Formatting Shapes . 312Lesson 18 - Enhancing Shapes with Text and Effects. 317Lesson 19 - Working with Templates. 323Lesson 20 - Protecting Data. 330End-of-Chapter Assessments. 336 Chapter 3 Using the Data Analysis, Scenario, and Worksheet Auditing Features . 340Lesson 21 - Inserting Functions and Using Logical Functions . 342Lesson 22 - Working with Absolute References and Using Financial Functions. 348Lesson 23 - Creating and Interpreting Financial Statements. 354Lesson 24 - Creating Scenarios and Naming Ranges. 361Lesson 25 - Finding and Fixing Errors in Formulas . 367Lesson 26 - Controlling Data . 374End-of-Chapter Assessments. 381 Microsoft Access 2010Chapter 1 Enhancing Queries. 384Lesson 1 - Creating Crosstab Queries. 386Lesson 2 - Creating Queries That Find Unmatched or Duplicate Records. 394Lesson 3 - Creating Queries That Prompt for Input . 399Lesson 4 - Creating Action Queries. 405Lesson 5 - Working with Advanced Query Options. 412End-of-Chapter Assessments. 420 Chapter 2 Customizing Forms and Reports . 422Lesson 6 - Working with Report Layouts. 425Lesson 7 - Working with Controls. 432Lesson 8 - Formatting Controls. 444Lesson 9 - Grouping, Sorting, and Filtering Report Data . 451Lesson 10 - Creating Special Forms and PivotTables. 458Lesson 11 - Working with Subforms and Subreports. 467Lesson 12 - Working with Charts . 475Lesson 13 - Creating Switchboards. 485Lesson 14 - Creating Navigation Forms. 492End-of-Chapter Assessments. 497 Chapter 3 Enhancing Tables and Working with Macros. 500Lesson 15 - Normalizing and Analyzing Tables. 502Lesson 16 - Using Advanced Field and Table Properties . 512Lesson 17 - Formatting and Correcting Datasheets. 519Lesson 18 - Creating Macros. 523End-of-Chapter Assessments. 529 Microsoft PowerPoint 2010Chapter 1 Working with Masters, Comments, Handouts, and Pictures . 532Lesson 1 - Advanced Slide Master Features . 534Lesson 2 - Working with Notes and Handouts . 540Lesson 3 - Working with Comments in a Presentation. 547Lesson 4 - Exporting Slide Handouts to Word. 553Lesson 5 - Working with Presentation Properties. 558Lesson 6 - Making a Presentation Accessible to Everyone . 564End-of-Chapter Assessments. 569 Chapter 2 Applying Advanced Graphic and Media Techniques. 574Lesson 7 - Advanced Picture Formatting. 576Lesson 8 - Advanced Multimedia Features. 583Lesson 9 - Working with Advanced Photo Album Features. 589Lesson 10 - Advanced Animation Features . 595Lesson 11 - Finalizing Slide Shows. 606Lesson 12 - Working with Actions. 612End-of-Chapter Assessments. 618 Chapter 3 Creating Presentations Using Tables and Charts . 622Lesson 13 - Drawing and Adjusting Tables. 624Lesson 14 - Formatting Tables. 632Lesson 15 - Formatting Charts. 639Lesson 16 - Adding Objects to Your Presentation. 644End-of-Chapter Assessments. 649Index . 654

Product Details

  • ISBN13: 9780135108413
  • Format: Mixed Media
  • Number Of Pages: 688
  • ID: 9780135108413
  • weight: 1302
  • ISBN10: 0135108411

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

Close