Part IV: Using Advanced
Excel Features

A number of Excel features can be fairly called “advanced” features if for no better reason than the ways in which they expand the definitions of what a spreadsheet program can do. The chapters in this part cover some useful features that you may not have used in the past but may find very valuable.

In This Part

Chapter 24

Customizing the Excel User Interface

Chapter 25

Using Custom Number Formats

Chapter 26

Using Data Validation

Chapter 27

Creating and Using Worksheet Outlines

Chapter 28

Linking and Consolidating Worksheets

Chapter 29

Excel and the Internet

Chapter 30

Protecting Your Work

Chapter 31

Making Your Worksheets Error Free