Excel 2003 Volume II

Advanced Concepts in Excel

Karen J. Jolly (Autor)

Buch | Softcover

448 Seiten

2006 | 5th edition
Scott Jones Publishing Inc., US (Verlag)
978-1-57676-148-9 (ISBN)

Titel ist leider vergriffen;
keine Neuauflage

Artikel merken

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.

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

Erscheint lt. Verlag	15.9.2006
Sprache	englisch
Maße	213 x 276 mm
Gewicht	807 g
Themenwelt	Informatik ► Office Programme ► Excel
ISBN-10	1-57676-148-7 / 1576761487
ISBN-13	978-1-57676-148-9 / 9781576761489
Zustand	Neuware