Mastering Excel: A Problem-Solving Approach
Rights Contact Login For More Details
More About This Title Mastering Excel: A Problem-Solving Approach
English
Not just another how-to book, this book goes beyond teaching how to use Excel by demonstrating how to use it for problem solving. From basics through the advanced, it explains the concepts that underlie the keystrokes and emphasizes how they can be used to solve real problems. Pencil and paper exercises enable readers to gain experience with spreadsheets before getting to the computer.
English
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.
