Mastering Excel
A Problem Solving Approach
2nd Edition
Published on 10. August 1996
Book
Paperback/Softback
352 pages
978-0-471-16372-5 (ISBN)
Description
This text is a beginner's guide to using Excel to solve real problems. It emphasizes the concepts that underline the use of Excel in problem solving as well as the mouse clicks and keystrokes necessary to use Excel. Chapters include material on solving financial problems using the built-in financial functions, solving statistical problems using the analysis tool pack, and solving operations research and management science problems using the solver.
More details
Edition
2nd Revised edition
Language
English
Place of publication
New York
United States
Publishing group
John Wiley and Sons Ltd
Edition type
Revised edition
Illustrations
Illustrations
Dimensions
Height: 235 mm
Width: 190 mm
Weight
510 gr
ISBN-13
978-0-471-16372-5 (9780471163725)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Content
FUNDAMENTALS. Creating Simple Worksheets. Changing the Appearance of the Worksheet. Simple Functions and the Fill Operation. Operations on Cells. Relative vs. Absolute Addressing. Common Operations. Workbooks with Multiple Worksheets. The Problem Solving-process. FEATURES. Charts. Logical Functions. Functions Related to IF. Dates and Times. Financial Functions. RAND and Simulation. Data Management with Lists. Data Analysis using the Analysis ToolPak. Goal Seeking and the Solver. Index.