Microsoft® Office Excel® 2007 Step by Step.

Format:

Book

Author/Creator:

Frye, Curtis D.

Contributor:

Frye, Curtis.

Series:

Step by step

Step by step Microsoft Office Excel 2007 step by step

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Business--Computer programs.

Electronic spreadsheets.

Microsoft Visual Basic for applications.

Business.

Local Subjects:

Business--Computer programs.

Electronic spreadsheets.

Microsoft Excel (Computer file).

Microsoft Visual Basic for applications.

Physical Description:

1 online resource (0 p.)

Edition:

1st edition

Other Title:

Excel 2007

Place of Publication:

Sebastopol : Microsoft Press, 2009.

Language Note:

English

System Details:

text file

Summary:

Experience learning made easy-and quickly teach yourself how to organize, analyze, and present data with Excel 2007. With Step By Step, you set the pace-building and practicing the skills you need, just when you need them! Create formulas, calculate values, and analyze dataPresent information visually with graphics, charts, and diagramsBuild PivotTable dynamic views-even easier with new data tablesReuse information from databases and other documentsShare spreadsheets for review and manage changesCreate macros to automate

Contents:

Microsoft® Office Excel® 2007 Step by Step; Acknowledgments; Features and Conventions; Using the Book's CD; Minimum System Requirements; Installing the Practice Files; Using the Practice Files; Uninstalling the Practice Files; Getting Help; Getting Help with Office Excel 2007; The Microsoft Business Certification Program; Becoming a Microsoft Certified Application Specialist-Microsoft 2007 Office System; Becoming a Microsoft Certified Application Professional; Taking a Microsoft Business Certification Exam; Certification; For More Information; Quick Reference

3. Working with Data and Data Tables4. Performing Calculations on Data; 5. Changing Document Appearance; 6. Focusing on Specific Data Using Filters; 7. Reordering and Summarizing Data; 8. Combining Data from Multiple Sources; 9. Analyzing Alternative Data Sets; 10. Creating Dynamic Lists with PivotTables; 11. Creating Charts and Graphics; 12. Printing; 13. Automating Repetitive Tasks with Macros; 14. Working with Other Microsoft Office System Programs; 15. Collaborating with Colleagues; 1. What's New in Excel 2007?; Managing Larger Data Collections; Using the New Microsoft Office File Format

Formatting Cells and WorksheetsManaging Data Tables More Effectively; Creating Formulas More Easily by Using Formula AutoComplete; Summarizing Data Using New Functions; Creating Powerful Conditional Formats; Creating More Attractive Charts; Controlling Printouts More Carefully; Key Points; 2. Setting Up a Workbook; Modifying Workbooks; Modifying Worksheets; Customizing the Excel 2007 Program Window; Arranging Multiple Workbook Windows; Adding Buttons to the Quick Access Toolbar; Key Points; 3. Working with Data and Data Tables; Moving Data Within a Workbook; Finding and Replacing Data

Correcting and Expanding Upon Worksheet DataDefining a Table; Key Points; 4. Performing Calculations on Data; Creating Formulas to Calculate Values; Summarizing Data That Meets Specific Conditions; Finding and Correcting Errors in Calculations; Key Points; 5. Changing Document Appearance; Defining Styles; Applying Workbook Themes and Table Styles; Making Numbers Easier to Read; Changing the Appearance of Data Based on Its Value; Adding Images to a Document; Key Points; 6. Focusing on Specific Data Using Filters; Manipulating List Data; Defining Valid Sets of Values for Ranges of Cells

Key Points7. Reordering and Summarizing Data; Organizing Data into Levels; Looking Up Information in a Data List; Key Points; 8. Combining Data from Multiple Sources; Linking to Data in Other Worksheets and Workbooks; Consolidating Multiple Sets of Data into a Single Workbook; Grouping Multiple Sets of Data; Key Points; 9. Analyzing Alternative Data Sets; Defining Multiple Alternative Data Sets; Varying Your Data to Get a Desired Result Using Goal Seek; Finding Optimal Solutions with Solver; Analyzing Data with Descriptive Statistics; Key Points; 10. Creating Dynamic Lists with PivotTables

Filtering, Showing, and Hiding PivotTable Data

Notes:

Description based upon print version of record.

Description based on publisher supplied metadata and other sources.

ISBN:

9780735635937

0735635935

OCLC:

609857092