Microsoft Excel 2010 on Demand (On Demand) （1ST）

Johnson, Steve/ Perspection, Inc. (COR)

Que Pub（2010/06発売）

• 製本 Paperback:紙装版/ペーパーバック版／ページ数 556 p.
• 言語 ENG
• 商品コード 9780789742773
• DDC分類 005.54

Full Description

What you need, when you need it!Need answers quickly? Microsoft Excel 2010 on Demand provides those answers in a visual step-by-step format. We will show you exactly what to do through lots of full color illustrations and easy-to-follow instructions.IncludesWorkshopsMCAS Exam PrepMore than 500 Essential Excel TasksInside the Book* Create workbooks more efficiently using the improved Ribbon interface* Use data-analysis tools and techniques for better decision making* Use organizing, processing, and presenting tools to create and analyze data* Integrate data from external sources and add hyperlinks* Use conditional formatting and Sparklines to visualize results* Add impact to your data with PivotTable and PivotChart reports* Organize information and add impact with clip art, SmartArt diagrams, tables, and charts* Use SharePoint to collaborate and share documents* Use the Excel Web App to view and edit documents in a browser* Prepare for the Microsoft Certified Application Specialist (MCAS) exam Bonus Online ContentRegister your book at queondemand.com to gain access to:* Workshops and related files* Keyboard shortcuts

Contents

Introduction xviiChapter 1 Getting Started with Excel 1Starting Excel 2 New!Viewing the Excel Window 3Using the Ribbon 4 New!Choosing Commands 5 New!Working with Toolbars 6 New!Choosing Dialog Box Options 8Using the Status Bar 9Creating a Blank Workbook 10Creating a Workbook Using a Template 11Opening an Existing Workbook 12Converting an Existing Workbook 14Using Task and Window Panes 15Moving Around the Workbook 16Arranging Windows 18Getting Help While You Work 20Saving a Workbook 22Saving a Workbook with Different Formats 24Checking Compatibility 26Checking Accessibility 27 New!Documenting Workbook Properties 28Switching Views 29Recovering a Workbook 30 New!Maintaining and Repairing Office 32Getting Updates on the Web 33Closing a Workbook and Quitting Excel 34Chapter 2 Basic Workbook Skills 35Making Label Entries 36Selecting Cells 37Selecting Rows, Columns, and Special Ranges 38Entering Labels on a Worksheet 40Entering Values on a Worksheet 42Entering Values Quickly with AutoFill 44Editing Cell Contents 46Clearing Cell Contents 47Understanding How Excel Pastes Data 48Storing Cell Contents 49Copying Cell Contents 50 New!Moving Cell Contents 52 New!Inserting and Deleting Cell Contents 54Finding and Replacing Cell Contents 56Correcting Cell Contents with AutoCorrect 58 New!Inserting Information the Smart Way 60 New!Checking Spelling 62Changing Proofing Options 63Using Custom Dictionaries 64Inserting Symbols 66Finding the Right Words 67Inserting Research Material 68Translating Text to Another Language 69Undoing and Redoing an Action 70Chapter 3 Working with Formulas and Functions 71Understanding Formulas 72Creating a Simple Formula 74Creating a Formula Using Formula AutoComplete 76Editing a Formula 78New!Understanding Cell Referencing 80Using Absolute Cell References 81Using Mixed Cell References 82Using 3-D Cell References 83Naming Cells and Ranges 84Entering Named Cells and Ranges 86Managing Names 88Simplifying a Formula with Ranges 90Displaying Calculations with the Status Bar 91Calculating Totals with AutoSum 92Performing One Time Calculations 94Converting Formulas and Values 96Correcting Calculation Errors 97Correcting Formulas 98Auditing a Worksheet 100Locating Circular References 101Performing Calculations Using Functions 102Creating Functions 103Creating Functions Using the Library 104 New!Calculating Multiple Results 105Using Nested Functions 106Using Constants and Functions in Names 108Chapter 4 Modifying Worksheets and Workbooks 109Selecting and Naming a Worksheet 110Inserting and Deleting a Worksheet 111Moving and Copying a Worksheet 112Hiding and Unhiding Worksheets and Workbooks 114Selecting a Column or Row 116Hiding and Unhiding a Column or Row 117Inserting a Column or Row 118Deleting a Column or Row 119Adjusting Column Width and Row Height 120Freezing and Unfreezing a Column or Row 122Splitting a Worksheet into Panes 123Showing and Hiding Workbook Elements 124Zooming the View In and Out 125Creating Custom Views 126Saving a Workspace Layout 127Creating a Template 128Opening a Template 129Changing a Template 130Chapter 5 Formatting a Worksheet 131Formatting Numbers 132Formatting Text 134Applying Conditional Formatting 136Applying Specialized Conditional Formatting 138Creating Conditional Formatting 140Clearing Conditional Formatting 141Managing Conditional Formatting 142Finding Conditional Formatting 143Creating Sparkline Formatting 144 New!Changing Data Alignment 146Controlling Text Flow 148Changing Data Color 149Adding Color and Patterns to Cells 150Adding Custom Colors 151Adding Borders to Cells 152Formatting Tabs and Background 154Copying Cell Formats 155Understanding Color Themes 156Viewing and Applying a Theme 157 New!Creating Theme Colors 158Choosing Theme Fonts 160Choosing Theme Effects 162Creating a Custom Theme 163Choosing a Custom Theme 164Applying and Creating Cell Styles 166Modifying a Cell Style 168Finding and Replacing Cell Formatting 170Chapter 6 Viewing and Printing Worksheets and Workbooks 171Setting Up the Page 172Adjusting Page Margins 174Adding Headers and Footers 176Inserting Page Breaks 178Customizing Worksheet Printing 180Setting the Print Area 182Previewing a Worksheet 183 New!Printing a Worksheet and Workbook 184 New!Creating a PDF Document 185Creating an XPS Document 186Chapter 7 Inserting and Modifying Graphics 187Locating and Inserting Clip Art 188 New!Inserting Media Clips 189Accessing Clip Art on the Web 190Organizing Clips into Categories 192Adding and Removing Clips 194Inserting a Picture 195Inserting a Picture Screen Shot 196 New!Adding an Artistic Style to a Picture 197 New!Adding a Quick Style to a Picture 198Applying a Shape to a Picture 199 New!Applying a Border to a Picture 200Applying Picture Effects 201Modifying Picture Size 202Compressing a Picture 204 New!Correcting a Picture 205 New!Recoloring a Picture 206 New!Cropping and Rotating a Picture 208 New!Removing a Picture Background 210 New!Creating WordArt Text 211Formatting WordArt Text 212Applying WordArt Text Effects 214Modifying WordArt Text Position 215Creating SmartArt Graphics 216 New!Using the Text Pane with SmartArt Graphics 218Modifying a SmartArt Graphic 220Resizing a SmartArt Graphic 221Formatting a SmartArt Graphic 222Formatting a Shape in a SmartArt Graphic 224Adding Pictures to a SmartArt Graphic 226 New!Creating an Organization Chart 227Modifying an Organization Chart 228Chapter 8 Drawing and Modifying Shapes 229Drawing and Resizing Shapes 230Inserting Multiple Shapes 232Adding Text to a Shape 233Drawing Lines and Arrows 234Creating and Editing Freeforms 236Copying and Moving Objects 237 New!Adding a Quick Style to a Shape 238Adding a Quick Style to Shape Text 239Applying Color Fills 240Applying Picture Fills 242Applying Texture Fills 243Applying Gradient Fills 244 New!Applying Shape Effects 246Adding 3-D Effects to a Shape 248Adding 3-D Rotation Effects to a Shape 250Creating Shadows 251Aligning and Distributing Objects 252Connecting Shapes 254Selecting Objects Using the Selection Pane 255Changing Stacking Order 256Rotating and Flipping a Shape 257Grouping and Ungrouping Shapes 258Adding a Shape to the Clip Organizer 260Chapter 9 Creating and Modifying Charts 261Understanding Chart Terminology 262Choosing the Right Type of Chart 263Creating a Chart 264Editing a Chart 266Moving and Resizing a Chart 268Selecting Chart Elements 269Changing a Chart Type 270Changing a Chart Layout and Style 272 New!Formatting Chart Elements 274 New!Changing Chart Gridlines and Axes 276Changing Chart Titles 278Changing Chart Labels 280Pulling Out a Pie Slice 282Formatting Chart Data Series 283Formatting Chart Text 284Formatting Line and Bar Charts 285Changing the Chart Background 286Enhancing a Chart 287Editing Chart Data 288 New!Adding and Deleting a Data Series 290Saving a Chart Template 292Managing Chart Templates 294Chapter 10 Analyzing Worksheet Data 295Understanding Tables 296Creating a Table 297Formatting a Table 298Creating or Modifying a Table Style 299Formatting Table Elements 300Creating Calculations in a Table 301Working with Tables 302Removing Table Rows and Columns 304Entering Data in a Table Using a Drop-Down List 305Sorting Data in a Table 306Displaying Parts of a Table with AutoFilter 308 New!Creating Custom Searches 309Analyzing Data Using a PivotTable or PivotChart 310Updating a PivotTable or PivotChart 311Modifying a PivotTable 312 New!Formatting a PivotTable 313Working with PivotTable Data 314 New!Using Slicers to Filter a PivotTable 316 New!Charting a PivotTable 318 New!Creating Groups and Outlines 320Converting Text to Columns 321Adding Data Validation to a Worksheet 322Creating a Drop-Down List 323Exporting a Table to a SharePoint List 324Chapter 11 Building More Powerful Worksheets 325Using Data Analysis Tools 326Using the Euro Conversion 327Looking at Alternatives with Data Tables 328Asking "What If" with Goal Seek 329Creating Scenarios 330Using Solver 332 New!Using Lookup and Reference Functions 334Using Text Functions 336Summarizing Data Using Subtotals 337Summarizing Data Using Functions 338Using Date & Time Functions 340Using Logical Functions 342Using Financial Functions 343Using Math Functions 344Using Statistical Functions 345 New!Using Information Functions 346Using Compatibility Functions 347 New!Chapter 12 Protecting and Securing a Workbook 349Inspecting Workbooks 350Protecting a Worksheet 352Locking and Unlocking Worksheet Cells 354Adding Security Encryption to a Workbook 355Adding Password Protection to a Workbook 356Adding a Digital Signature 358Adding a Signature Line 360Avoiding Harmful Attacks 362Using the Trust Center 364 New!Selecting Trusted Publishers and Locations 365Setting Document Related Security Options 366 New!Setting Add-in Security Options 368Setting ActiveX Security Options 369Setting Macro Security Options 370Changing Message Bar Security Options 371Setting Privacy Options 372Setting External Content Security Options 374Working with Office Safe Modes 376Marking a Workbook as Read-Only 378Chapter 13 Reviewing and Sharing Workbook Data 379Sharing Workbooks 380Creating and Reading a Cell Comment 382Editing and Deleting a Cell Comment 383Tracking Changes 384Sending a Workbook for Review Using E-Mail 386Sending a Workbook by Internet Fax 387Working with XML 388 New!Creating an XML Data Map 390Exporting and Saving Data in XML 392Sharing Information Between Programs 394Exporting and Importing Data 396 New!Linking and Embedding Files 398 New!Consolidating Data 400Linking Data 402Getting External Data 403Managing Connections 404Getting Query Data from a Database 406Getting Data from Microsoft Access 408Getting Text Data 410Chapter 14 Publishing Data on the Web 411Opening a Workbook as a Web Page 412Previewing a Web Page 413Creating a Hyperlink 414Formatting a Hyperlink 416Changing Web Page Options 41714Saving a Worksheet as a Web Page 418Publishing a Web Page 420Copying a Web Table to a Worksheet 421Creating Refreshable Web Queries 422Getting Data from Web Queries 423Saving Web Queries 424Accessing Office Information on the Web 425Getting Documents from the Web 426Chapter 15 Tools for Working More Efficiently 427Getting General Excel Options 428Setting New Workbook Options 429Setting Editing Options 430 New!Setting Image and Chart Options 432 New!Setting Display View Options 433 New!Setting Workbook and Worksheet Display Options 434 New!Setting Advanced Options 436 New!Setting Formula Options 437Changing Advanced Document Properties 438Changing Research Options 439Customizing the Way You Create Objects 440Accessing Commands Not in the Ribbon 441Managing Pictures 442Using Multiple Languages 444 New!Chapter 16 Expanding Excel Functionality 445Viewing and Managing Add-ins 446Loading and Unloading Add-ins 448Enhancing a Workbook with VBA 450Viewing the Visual Basic Editor 452Setting Developer Options 453Understanding How Macros Automate Your Work 454Recording a Macro 455 New!Creating a Macro 456Running a Macro 457Controlling a Macro 458Adding a Digital Signature to a Macro Project 460Assigning a Macro to a Toolbar 461Saving a Workbook with Macros 462Opening a Workbook with Macros 463Inserting ActiveX Controls 464Using ActiveX Controls 466Setting ActiveX Control Properties 467Adding VBA Code to an ActiveX Control 468Playing a Movie Using an ActiveX Control 469Changing the Document Information Panel 470Chapter 17 Working Together on Office Documents 471Getting Started with Office Web Apps 472 New!Setting Up to Use Office Web Apps 474 New!Saving and Opening Documents with Windows Live 476 New!Comparing the Desktop App to Web App 478 New!Accessing Documents on Windows Live 480 New!Working with Folders on Windows Live 482Setting Folder Permissions on Windows Live 484Creating Office Documents on Windows Live 485 New!Working with Documents on Windows Live 486Downloading Documents from Windows Live 488Downloading or Saving Documents in Office Web Apps 490 New!Collaborating with Documents on Windows Live 492 New!Working with SharePoint Workspaces 494 New!Sharing Documents in a Groove Workspace 496 New!Inviting Others to a Groove Workspace 497 New!Saving a Document to a SharePoint Server 498 New!Using Office Mobile 2010 500 New!Workshops: Putting It All Together 501Project 1: Creating a Drop-Down List 501Project 2: Adding a Form Control 503Project 3: Adding Conditional Formatting 504Project 4: Creating a VBA Script 506Project 5: Creating a VBA Interface 508Want More Projects 513New Features 515 New!Microsoft Certified Applications Specialist 521Index 529