Cover image for Special edition using Microsoft Excel 2002
Title:
Special edition using Microsoft Excel 2002
Author:
Blattner, Patrick.
Personal Author:
Publication Information:
Indianapolis, Ind. : Que, [2001]

©2001
Physical Description:
xxii, 953 pages : illustrations ; 24 cm
General Note:
Includes index.
Language:
English
ISBN:
9780789725110
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Central Library HF5548.4.M523 U86 2001 Adult Non-Fiction Central Closed Stacks
Searching...

On Order

Summary

Summary

There is a focus on applying real-world techniques to solve everyday business problems in this edition. It will provide the most extensive coverage ever found in one book on Microsoft Excel's functions, as well as professional modeling, charting, and formula techniques. No other Excel book on the market provides as much essential intermediate to advanced-level coverage.

Topics covered will include:

Building Charts with Excel Professional Charting techniques Using Formulas and Functions Using PivotTables & PivotCharts Creating Gantt Charts Combining Excel with Other Office Applications


Author Notes

Patrick Blattner has authored Special Edition Using Microsoft Excel 2000, Microsoft Excel 2000 Functions in Practice, and Special Edition Using Microsoft Word and Excel in Office 2000. He has written about Excel in PC Computing Magazine and has spoken about it on ZDTV's live call-in television show "Call for Help."

An Excel evangelist, he deals with real-world business information problems daily. He has made a career out of working for some of America's most respected companies. A member of The Academy of Interactive Arts and Sciences, he spent several years in interactive media development with Disney Interactive. Most recently, he is working in product development and strategy for AOL Time Warner's CompuServe brand.

Bill Bruns is a veteran of finance and data retrieval in the Information Age. For six years, he has been a technical editor for Que, working on at least 75 books related to the Internet, Web servers, HTML, and Office applications. Bill is the chief financial officer for Jacob Marlie Financial, Inc. (http://www.jacobmarlie.com), a Web-based invoicing and collections agency for fraternal organizations. He also serves in a volunteer capacity as chapter advisor and treasurer for the Gamma chapter of Tau Kappa Epsilon's Board of Advisors at the University of Illinois. Currently, he is the Assistant Director for Business Systems at the University of Illinois' College of Medicine.

Previously, he ran administrative computing at New York University's Tisch School of the Arts. Originally planning to work in television production, his interest turned to computers while working on an undergraduate internship at Square One TV, a children's mathematics show produced by the Children's Television Workshop in New York City. Bill holds bachelor's degrees in Telecommunications and English Literature from Indiana University, a Masters of Public Administration from New York University, and is a Certified Netware Engineer. Bill, his wife Debbie, his daughter Marlie, and his bearded dragon Cookie currently reside in Champaign, Illinois. You can reach him at bill@jacobmarlie.com.

Ken Cook operates his own software training and consulting business, which he formed in 1989 in the central New Jersey area. He specializes in developing Microsoft Office custom solutions and training Microsoft Office as well as sales automation software for Fortune 500 companies. Ken's writing experience includes developing a custom training curriculum for his clients. Prior to consulting, Ken worked for five years at Prince Manufacturing, where he held marketing and operations positions that exposed him to all facets of the corporate environment. Ken holds a Bachelor of Science degree in marketing from Syracuse University.

John Shumate is a Decision Support Consultant for Anteon Corporation of Fairfax, Virginia. He earned his bachelor's degree in Data Processing Management from Strayer College in Washington, DC and taught computer programming and systems analysis courses for George Washington University's Information Systems certificate program. He has 18 years of experience implementing business intelligence systems as a consultant for large businesses and Federal government agencies and has published over 30 articles on OLAP, data warehousing, and enterprise reporting as a long-time Contributing Editor to eWeek Magazine.


Table of Contents

Introduction
New Features and Enhancements in Excel 2002
How This Book Is Organized
Conventions Used in This Book
I Getting Started With Excel
1 Getting Around Excel
Starting and Exiting the Excel Program
Identifying Workbook Elements
Working with Workbooks
Understanding Cell Basics
Entering Text
Saving Excel Data
Controlling Your Worksheet View
Troubleshooting
Excel in Practice
2 Spreadsheet Basics
Selecting Cells
Selecting Columns and Rows
Selecting Noncontiguous Ranges
Selecting Ranges on Grouped Worksheets
Naming Ranges for Fast Access
Troubleshooting
Excel in Practice
3 Editing Spreadsheets
The Clipboard Viewer
Editing with the Keyboard
Creating a Data Series
Creating a Custom Fill Series
Creating a Custom Fill to Define Linear or Growth Trends
Creating a Custom List or Series
Replacing Data
Tracking Changes Made by Multiple Users
Using Comments to Explain Cell Content
Linking Excel Data
Troubleshooting
Excel in Practice
II Formatting and Printing Excel Worksheets
4 Applying Number and Date Formats
Applying Common Numeric Formats from the Toolbar Applying Built-In Formats
Creating Custom Formats
Applying Custom Currency
Working with Large Numbers
Pasting In Custom Characters
Creating Custom Conditions Codes
Repeating Characters
Excel in Practice
5 Formatting and Printing
Why Change the Formatting? Using the Formatting Toolbar
Using the Format Cells Dialog Box
Changing the Font, Point Size, and Font Styles
Working with Styles
Applying and Drawing Borders and Shading
Using AutoFormat to Enhance Your Worksheets
Using the Drawing Toolbar
Ordering, Grouping, Moving, and Resizing Drawn Objects
Combining Drawing Tools with Charts and Worksheets
Media Matrix
Media Plan
Slider Charts
Inclusion Matrix with Webdings
Printing a Worksheet
Previewing the Print Job
Using Page Break Preview
Working with Page Setup Options
Troubleshooting
Excel in Practice
III Using Formulas and Functions
6 Function Fundamentals
The Basic Parts of a Formula
Using the New AutoSum Feature
Editing Formulas
Writing Multiple Copies of a Formula
Using AutoCalculate for Quick Totals
Using Arithmetic Operators for Simple Math
Relative Versus Absolute Referencing
Using the Watch Window
Referencing Values in Other Worksheets and Workbooks
Troubleshooting
Excel in Practice
7 Database Functions
Database Functions Overview
Daverage
Dcount
Dget
Dmax
Dmin
Dproduct
Dsum
Getpivotdata
Troubleshooting
Excel in Practice
8 Date and Time Functions
Date and Time Functions Overview
Date
Days360
Edate
Month
Networkdays
Today
Weekday
Year
Troubleshooting
Excel in Practice
9 Engineering Functions
Engineering Functions Overview
Besseli
Bin2Dec
Complex
Convert
Dec2Bin
Delta
Gestep
Hex2Bin
Imconjugate
Impower
Improduct
Imsub
Imsum
Oct2Bin
Excel in Practice
10 Financial Functions
Financial Functions Overview
Accrint
Accrintm
Coupdaybs
Coupdays
Coupncd
Coupnum
Cumipmt
Disc
Duration
Fv
Ipmt
Mduration
Nper
Npv
Oddfprice
Pmt
Ppmt
Price
Pv
Rate
Received
Tbillprice
Tbillyield
Yield
Yieldmat
Excel in Practice
11 Information Functions

Google Preview