Overview

This book covers the advanced concepts to round out complete proficiency with Excel. It delves into advanced formulas, pivot tables, charts, and much more. The book blends discussion with hands-on practice, and is written in a way that makes it feel as if the author is sitting with the student to guide them through the process.

Full Product Details

Author:   Karen J. Jolly
Publisher:   Pearson Education (US)
Imprint:   Scott Jones Publishing Inc., US
Edition:   5th edition
Dimensions:   Width: 21.30cm , Height: 2.00cm , Length: 27.60cm
Weight:   0.807kg
ISBN:  

9781576761489

ISBN 10:   1576761487
Pages:   448
Publication Date:   15 September 2006
Audience:   College/higher education ,  Tertiary & Higher Education
Format:   Paperback
Publisher's Status:   Out of Print
Availability:   Out of stock  

Table of Contents

Volume 2-Expert Concepts in Excel Chapter 11 Creating and Using Templates Business Math Workshop: Stocks, Bonds, and Portfolio Values Chapter 12 Creating Macros and Visual Basic Chapter 13 Integrating Excel with Other Applications Chapter 14 Exploring Additional Format, Audit, and Protection Topics Chapter 15 Editing and Enhancing Charts Business Math Workshop: Present Value Business Math Workshop: Future Value and Compound Interest Business Math Workshop: Determine Depreciation Chapter 16 Working with Advanced Functions Chapter 17 Nesting Functions and Advanced Lookup Tables Chapter 18 Advanced Features of List Management Chapter 19 Using Outline, Subtotal, and Conditional Formatting Features Chapter 20 Using Named Cells Chapter 21 Creating Pivot Tables and Pivot Charts, and ConsolidatingWorkbooks Chapter 22 Using Data Analysis Tools of Data Tables, Goal Seek, Solver, and Scenarios Chapter 23 Creating and Validating Forms, and Sharing Workbooks

Reviews

Author Information

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions