Mastering Excel
A Problem-Solving Approach
2nd Edition
Published on 21. June 2002
Book
Paperback/Softback
352 pages
978-0-471-20323-0 (ISBN)
Description
Assumes no initial understanding or experience with spreadsheets. Teaches how to use EXCEL and to solve real problems. Emphasizes concepts that underly use of EXCEL in problem solving as well as keystrokes and mouse clicks necessary to use EXCEL. Renowned collection of exercises. Wide range of exercises--enabling the testing of principles in a variety of formats.
More details
Edition
2nd Revised edition
Language
English
Place of publication
New York
United States
Publishing group
John Wiley and Sons Ltd
Target group
College/higher education
Professional and scholarly
Edition type
Revised edition
Dimensions
Height: 234 mm
Width: 192 mm
Thickness: 13 mm
Weight
566 gr
ISBN-13
978-0-471-20323-0 (9780471203230)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Content
Part I: Fundamentals Introduction Creating simple worksheets Changing the appearance of the worksheet Simple functions and the Fill operations Operations on cells Relative vs. absolute addressing Common operations Workbooks with multiple worksheets The problem-solving process Part II: 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