Table
of Contents
Chapter
1
Introduction
Chapter 2
Creating simple worksheets
Chapter 3
Changing the appearance of
cells
Chapter 4
Simple functions and the Fill
operation
Chapter 5
Operations on cells
Chapter 6
Relative vs. absolute
addressing
Chapter 7
Common operations
Chapter 8
Workbooks with multiple
worksheets
Chapter 9
The problem-solving process
Chapter 10
Charts and trendlines
Chapter 11
Logical functions
Chapter 12
Functions related to IF
Chapter 13
Dates and times
Chapter 14
Financial functions
Chapter 15
Random numbers and simulation
Chapter 16
Data management with tables
Chapter 17
Analyzing data using the
Analysis ToolPak
Chapter 18
Solver
Chapter 19 Macros (new to Mastering Excel 2010)