Exploring Microsoft Office 2007 Volume 1

by Grauer, Robert T.; Scheeren, Judy; Lockley, Maurie; Hulett, Michelle; Krebs, Cynthia

• ISBN13: 9780131575646
• ISBN10: 0131575643
• Edition: 1st
• Format: Paperback
• Copyright: 2008-01-01
• Publisher: Prentice Hall

Summary

The Exploring series helps students master theHow and Whyof performing tasks in Office to gain a greater understanding of how to use the individual applications together to solve business problems. Exploring titles featurePerfect pageswhere every step of every hands-on exercise as well as every end-of-chapter problem begins on a new page and has its own screen shot to make it easier to follow. Each chapter contains Hands-on Exercises, Capstone Exercises, and Mini-Cases for practicing and reviewing skills acquired.Exploring Microsoft Office Excel 2007 Comprehensive, 1/e, covers the following topics: introduction to Excel; using formulas, functions, and charts; working with large worksheets and tables; converting data to information; consolidating data and linking files; What-If analysis, forecasting, and amortization; employing templates, themes, and web pages; collaboration and macros; data analysis; VBA.Ideal for students and individuals seeking a comprehensive introduction to Excel 2007.

Table of Contents

Microsoft Office Word 2007

What Will Word Processing Do for Me?

Introduction to Word Processing Understanding Word Basics Using AutoText Viewing a Document Using the Mini Toolbar Hands-On

Introduction to Microsoft Word

Document Formatting Setting Margins and Specifying Page Orientation Inserting Page Breaks Adding Page Numbers Inserting Headers and Footers Creating Sections Inserting a Cover Page Using Find and Replace Commands Hands-On

Document Organization

The Final Touches Checking Spelling and Grammar Using Save and Backup Options Selecting Printing Options Customizing Word Hands-On

The Final Touches Summary Key Terms Practice Exercises Mid-Level Exercises Capstone Exercise Mini Cases

Gaining Proficiency: Editing and Formatting

Text Formatting Applying Font Attributes Through the Font Dialog Box Highlighting Text Controlling Word Wrapping with Nonbreaking Hyphens and Nonbreaking Spaces Copying Formats with the Format Painter Hands-on

Character Formatting

Paragraph Formats Setting Off Paragraphs with Tabs, Borders, Lists, and Columns Applying Paragraph Formats Hands-on

Paragraph formatting

Styles and Document References Creating and Modifying Styles Hands-on

Styles Table of Contents and Indexes Hands-on

Reference Pages Summary Key Terms Practice Exercises Mid-Level Exercises Capstone Exercise Mini Cases Microsoft Office Excel 2007

Introduction to Excel

Introduction to Spreadsheets Defining Worksheets and Workbooks Using Spreadsheets Across Disciplines Planning for Good Workbook and Worksheet Design Identifying Excel Window Components Entering and Editing Data in Cells Hands-On

Introduction to Microsoft Excel

Mathematics and Formulas Describing and Using Symbols and the Order of Precedence Displaying Cell Formulas Inserting and Deleting Rows and Columns Using Cell Ranges, Excel Move, Copy, Paste and Paste Special, and AutoFill Hands-On

Jakes Gym Continued

Workbook and Worksheet Enhancements Managing Worksheets Formatting Worksheets Hands-On

Formatting Jake's Gym Worksheet

Page Setup and Printing Selecting Page Setup Options for Printing Managing Cell Comments Hands-On

Printing Jake's Gym Worksheet Summary Key Terms Multiple Choice Practice Exercises Mid-Level Exercises Capstone Exercise Mini Cases

Microsoft Excel: Formulas and Functions

Formula Basics Creating and Copying Formulas Using Relative and Absolute Cell Addresses Hands-On

Smithtown Hospital Radiology Department Payroll

Function Basics Using AutoSum Inserting Basic Statistical Functions Using Date Functions Hands-On

Completing the Smithtown Hospital Radiology Department

Logical and Lookup Functions Using the IF Function Using the VLOOKUP Function Hands-On

Athletic Department Eligibility Gradebook

Financial Functions

Table of Contents provided by Publisher. All Rights Reserved.