Find a copy in the library
Finding libraries that hold this item...
Details
| Material Type: | Internet resource |
|---|---|
| Document Type: | Book, Internet Resource |
| All Authors / Contributors: |
Guy Hart-Davis |
| ISBN: | 0072263695 9780072263695 |
| OCLC Number: | 80169900 |
| Notes: | Includes index. |
| Description: | xxiv, 488 p. : ill. ; 24 cm. |
| Contents: | pt. I. Get started with Excel -- 1. Navigate the Excel screen -- Start Excel -- Understand the Excel system -- Understand worksheets and workbooks -- Open an existing workbook -- Navigate in workbooks and worksheets -- Select objects -- Get help with Excel -- 2. Configure Excel to suit your working needs -- Improve your view with splits, extra windows, hiding, zooming, and freezing -- Set options to make Excel easier to use -- Load and unload add-ins -- Configure AutoCorrect to save time and effort -- 3. Create spreadsheets and enter data -- Create a new workbook -- Save a workbook -- Create your own templates -- Enter data in worksheets -- Use AutoFill to enter data series quickly -- Use find and replace -- Recover your work if Excel crashes -- 4. Format worksheets for best effect -- Add, delete, and manipulate worksheets -- Format cells and ranges -- 5. Add graphics and drawings to worksheets -- Understand how Excel handles graphical objects -- Insert clip art, photographs, movies, and sounds in worksheets -- Work with shapes, AutoShapes, and WordArt -- Add pictures to worksheets -- Add SmartArt to worksheets -- 6. Check, lay out, and print worksheets -- Check the spelling in worksheets -- Set the print area -- Specify the paper size and orientation -- Scale the printout to fit the paper -- Use print preview to see how the printout will look -- Add effective headers and footers to worksheets -- Set and adjust page breaks -- Check and change margins -- Choose which items to include in the printout -- Repeat row titles or column titles on subsequent pages -- Print worksheets -- pt. II. Calculate, manipulate, and analyze data -- 7. Perform calculations with functions -- Understand functions -- Understand the components of a function -- Enter functions in worksheets -- Nest one function inside another function -- Edit a function in a worksheet -- Monitor calculations with the watch window -- Examples of functions in action -- 8. Create formulas to perform custom calculations -- Understand formula components -- Understand how Excel handles numbers -- Refer to cells and ranges in formulas -- Refer to other worksheets and other workbooks in formulas -- Try entering a formula -- Use range names and table names in formulas -- Use absolute, relative, and mixed references in formulas -- Work with array formulas -- Display formulas in a worksheet -- Hide formulas from other users -- Troubleshoot formulas -- 9. Organize data with Excel databases -- Understand what an Excel table is -- Create a table -- Rename the table -- Choose table styles and style options -- Enter data in a table -- Sort a table -- Remove duplicates from a table -- Find and replace data in a table -- Filter a table to find records that match criteria -- Use conditional formatting with tables -- Link an Excel worksheet to an external table -- Convert a table back to a range -- 10. Outline and consolidate worksheets -- Use outlining to create collapsible worksheets -- Consolidate multiple worksheets into one worksheet -- 11. Analyze data using PivotTables and PivotCharts -- Understand PivotTables -- Create a PivotTable framework using the PivotTable and PivotChart wizard -- Create the PivotTable on the framework -- Change, format, and configure the PivotTable -- Create PivotCharts from PivotTables -- Create a conventional chart from PivotTable data -- 12. Solve problems by performing what-if analysis -- Create data tables to assess the impact of variables -- Explore alternative data sets with scenarios -- Solve problems with goal seek -- Use the solver to manipulate two or more values -- pt. III. Share, publish, and present data -- 13. Create effective charts to present data visually -- Understand the basics of Excel charts -- Create a chart -- Lay out and format a chart -- Copy formatting from one chart to another -- Print charts -- Create custom chart types for easy reuse -- 14. Share workbooks and collaborate with colleagues -- Share a workbook by placing it on a shared drive -- Configure sharing on a workbook -- Restrict data and protect workbooks -- Work with comments -- Send workbooks via e-mail -- Track changes to a workbook -- 15. Using Excel's Web capabilities -- Understand saving directly to an Intranet site or Internet server -- Choose Web options to control how Excel creates Web pages -- Understand HTML, round tripping, and Web file formats -- Save a worksheet or workbook as a Web page -- Understand and use Excel's XML capabilities -- 16. Use Excel with the other Office applications -- Transfer data using the clipboard and Office clipboard -- Embed and link objects -- Insert Excel objects in Word documents -- Insert Excel objects in PowerPoint presentations -- Insert Word objects in worksheets -- Insert PowerPoint objects in worksheets -- pt. IV. Customize and program Excel -- 17. Customize Excel's interface -- Change the position of the quick access toolbar -- Customize the items on the quick access toolbar -- Customize the status bar -- 18. Use macros to automate tasks -- Understand what macros are and what they're for -- Configure Excel's macro virus-protection features -- Record a macro using the macro recorder -- Test and run a macro -- Delete a macro -- Sign a workbook with a digital signature -- Appendix. Keyboard shortcuts. |
| Series Title: | How to do everything with-- |
| Other Titles: | Microsoft Office Excel 2007 |
| Responsibility: | Guy Hart-Davis. |
| More information: |
Abstract:
Provides coverage of the new features of the spreadsheet program, covering such topics as upgrading one's system, configuration and customization, building spreadsheets, adding graphics, creating custom formulas, using PivotTable analysis, and using Web capabilities.
Reviews
Add a review and share your thoughts with other readers.
Be the first.
Add a review and share your thoughts with other readers.
Be the first.
Tags
Add tags for "How to do everything with Microsoft Office Excel 2007".
Be the first.