Leading the way in Microsoft Office Development

Excel

Basic

 -

Getting Started

 -

Creating a Table

 -

Table Styles

 -

Table Tools - Design Tab

 -

Creating a List (2003)

 -

List Toolbar (2003)

Sorting

 -

Sorting

 -

Sorting - Custom

 -

Sorting - By Colour

Filtering

 -

Filtering

 -

Filtering - Dates

 -

Filtering - Text

 -

Filtering - Numbers

 -

Filtering - Number of Rows

 -

Filtering - Top 10

 -

Filtering - Custom

 -

Advanced Filter

 -

Advanced Filter - Copying

 -

Advanced Filter - Unique Records

Advanced

 -

Using Named Ranges

 -

Advanced Techniques

 -

Office Online

 -

Knowledge Base

Shortcut Keys

(Ctrl + Shift + A) - Applies a Filter to the current region.

(Alt + Down Arrow) - Display the Filter for the current column.

(Alt + Up Arrow) - Closes the Filter for the current column.

Tools > Options

(Edit tab, Extend data range formats and formulas) - Formulas that contain references to ranges will be automatically expanded when new cells are inserted to the right or below the existing range. This only works when cells are inserted immediately below or to the right of a referenced range.

Related Topics

 -

Cells & Ranges

 -

Database