|
Course Overview
• Create formulas,
calculate values, and analyze data
• Present information visually with graphics, charts, and diagrams
• Build PivotTable dynamic views—even easier with new data tables
• Reuse information from databases and other documents
• Share spreadsheets for review and manage changes
• Create macros to automate repetitive tasks and simplify your work
Your all-in-one learning experience includes:
• Files for building skills and practicing the book’s lessons
• Fully searchable eBook
• Bonus quick reference to the Ribbon, the new Microsoft Office
interface
• Windows Vista Product Guide eReference—plus other resources on CD
Target Audience
Beg/Int
Microsoft Press Book Details 432
pages, 1 companion CD
Course Outline
1 What's New in Excel 2007?
Becoming Familiar with the New User Interface
Managing Larger Data Collections
Using the New Microsoft Office File Format
Formatting Cells and Worksheets
Managing 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
2 Setting up a workbook
Creating Workbooks
Modifying Workbooks
Modifying Worksheets
Customizing the Excel 2007 Program Window
3 Working with Data and Data
Tables
Entering and Revising Data
Moving Data Within a Workbook
Finding and Replacing Data
Correcting and Expanding Upon Worksheet Data
Defining a Table
4 Performing Calculations on Data
Naming Groups of Data
Creating Formulas to Calculate Values
Summarizing Data That Meets Specific Conditions
Finding and Correcting Errors in Calculations
5 Changing Document
Appearance
Formatting Cells
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 6 Focusing on Specific Data
Using Filters
Limiting Data That Appears on Your Screen
Manipulating List Data
Defining Valid Sets of Values for Ranges of Cells 7 Reordering and Summarizing
Data
Sorting Data Lists
Organizing Data into Levels
Looking Up Information in a Data List
8 Combining Data from Multiple Sources
Using Data Lists as Templates for Other Lists
Linking to Data in Other Worksheets and Workbooks
Consolidating Multiple Sets of Data into a Single Workbook
Grouping Multiple Sets of Data
9 Analyzing Alternative Data
Sets
Defining and Editing 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
10 Creating Dynamic Lists
with PivotTables
Analyzing Data Dynamically with PivotTables
Filtering, Showing, and Hiding PivotTable Data
Editing PivotTables
Formatting PivotTables
Creating PivotTables from External Data 11 Creating Charts and
Graphics
Creating Charts
Customizing the Appearance of Charts
Finding Trends in Your Data
Creating Dynamic Charts Using PivotCharts
Creating Diagrams by Using SmartArt 12 Printing
Adding Headers and Footers to Printed Pages
Preparing Worksheets for Printing
Printing Data Lists
Printing Parts of Data Lists
Printing Charts
13 Automating Repetitive Tasks with Macros
Introducing Macros
Creating and Modifying Macros
Running Macros When a Button is Clicked
Running Macros When a Workbook Is Opened
14 Working with Other
Microsoft Office System Programs
Including Microsoft Office System Documents in Excel 2007
Worksheets
Storing Excel 2007 Documents as Parts of
Other Microsoft Office System Documents
Creating Hyperlinks
Pasting Charts into Other Documents
15 Collaborating with
Colleagues
Sharing Data Lists
Managing Comments
Tracking and Managing Colleagues' Changes
Protecting Workbooks and Worksheets
Authenticating Workbooks
Saving Workbooks for the Web |