Skip to content

New Perspectives on Microsoft Office Excel 2007

Spend $50 to get a free DVD!

ISBN-10: 0538745045

ISBN-13: 9780538745048

Edition: N/A

Authors: June Jamrich Parsons, Dan Oja, Roy Ageloff, Patrick Carey

List price: $110.95
Blue ribbon 30 day, 100% satisfaction guarantee!
Out of stock
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Customers also bought

Book details

List price: $110.95
Publisher: CENGAGE Learning
Publication date: 7/10/2009
Binding: DVD-ROM 
Size: 5.00" wide x 7.75" long x 0.25" tall
Weight: 0.088
Language: English

Getting Started with Excel
Understanding Spreadsheets
Planning a Workbook
Working with Formulas
Introducing Functions
Formatting a Workbook
Formatting Data
Formatting Worksheet Cells
Working with Table Styles
Introducing Conditional Formats
Working with Formulas and Functions
Understanding Cell References When Copying Formulas
Understanding Function Syntax
Working with AutoFill
Working with Logical Functions
Working with Financial Functions
Working with Charts and Graphics
Creating Charts
Working on Chart Design
Creating a Column Chart
Creating a Line Chart
Working with Excel Tables, PivotTables, and PivotCharts
Creating an Excel Table
Sorting Data
Filtering Data
Analyzing Data with PivotTables
Managing Multiple Worksheets and Workbooks
Grouping Worksheets
Using 3-D References to Add Values Across Worksheets
Linking Workbooks
Creating a Custom Workbook Template
Using Advanced Functions, Conditional Formatting, and Filtering
Creating Nested IF Functions
Using Lookup Tables and Functions
Summarizing Data Conditionally
Using Advanced Filtering
Developing an Excel Application
Naming Cells and Ranges
Validating Data Entry
Protecting a Worksheet and Workbook
Recording a Macro
Developing a Financial Analysis
Working with Loans and Mortgages
Projecting Future Income and Expenses
Auditing a Workbook
Performing What-If Analyses
Working with What-If Analysis and Goal Seek
Using Scenario Manager
Finding an Optimal Solution Using Solver
Connecting to External Data
Working with Text Files
Using the Query Wizard
Creating a Web Query
Expanding Excel with Visual Basic for Applications
Working with the Visual Basic Editor
Retrieving Information from the User
Creating a Message Box