New Perspectives on Microsoft Excel 2010 Comprehensive

by Parsons, June Jamrich; Oja, Dan; Ageloff, Roy; Carey, Patrick

• ISBN13: 9780538742917
• ISBN10: 0538742917
• Format: Paperback
• Copyright: 2010-10-21
• Publisher: Cengage Learning

Summary

With the New Perspectives' critical-thinking, problem-solving approach, students will gain a comprehensive understanding of MICROSOFT OFFICE EXCEL 2010 and will learn how to take advantage of the flexibility it offers. Case-based tutorials challenge students to apply what they are learning to real-life tasks, preparing them to easily transfer skills to new situations. With New Perspectives, students understand why they're learning what they're learning and are better situated to retain skills beyond the classroom.

Table of Contents

Getting Started with Microsoft Office 2010

Getting Started with Excel

Formatting a Workbook

Working with Formulas and Functions

Working with Charts and Graphics

Working with Excel Tables, PivotTables, and PivotCharts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions, Conditional Formatting, and Filtering

Developing an Excel Application

Developing a Financial Analysis

Performing What-If Analyses

Connecting to External Data

Expanding Excel with Visual Basic for Applications

Additional Cases

Appendices

Working with Text Functions and Creating Custom Formats

Integrating Excel with Other Windows Programs

Creating a Shared Workbook

Working with Enhanced Formatting Tools

Table of Contents provided by Publisher. All Rights Reserved.