Title:
Mastering excel : a problem-solving approach
Personal Author:
Edition:
2nd ed.
Publication Information:
New York : John Wiley & Sons, 2003
ISBN:
9780471203230
Available:*
Library | Item Barcode | Call Number | Material Type | Item Category 1 | Status |
|---|---|---|---|---|---|
Searching... | 30000010018577 | HF5548.4.M523 G56 2003 | Open Access Book | Book | Searching... |
On Order
Summary
Summary
* 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.
Table of Contents
| Introduction |
| 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 |
| Charts |
| Logical Functions |
| Functions Related to IF |
| Dates and Times |
| Financial Functions |
| Random Numbers and Simulation |
| Data Management with Lists |
| Analyzing Data Using the Analysis ToolPak |
| Goal Seeking and Solver |
| Index |
