Formulae and Functions

The Office Interface

Excel Basics

Entering and Editing Data

Copying and Moving Cells

Filling Cells

Moving and Selecting in Excel

Working with Files

Styles

Number and Date Formats

Conditional Formatting

Download this chapter

Absolute and Relative References

Range Names

Cell Comments

Printing


Formatting worksheets

Multiple Worksheets

Consolidating Data

Data Validation

Protection

Templates

Tables-edited

Tables

Formatting Tables

Subtotals

Pivot Tables

IF Functions

The VLOOKUP Function

Other Lookup Functions

Date and Time Functions

Text Functions

Information Functions

Inspection and Error Functions
Conditional Statistics

The SUMPRODUCT Function

Dynamic Range Names

Grouping (Outlining)

Recording Macros

Charts

Advanced Charts

Array formulae

Scenarios

Data Tables

Goal-Seeking

The Excel Solver

Excel Short-Cut Keys