Databases and Lists
What is a Database?
External Database File
Excel Data List
Data Forms
Entering Data Form Data
Locating Data with the Data Form
Comparison Operators
Sorting a List
Push Button Sorting
Default Sort Assumptions
Custom Sort Orders
Defining a Custom List
Filtering a List
What is a Filter?
AutoFilters
Custom AutoFilters
Top 10 AutoFilters
Removing AutoFilter
Using Advanced Filter
Some Definitions
Criteria Range
And Condition
Or Condition
Subtotals
Setting Up Tables to be Subtotaled
Outline Controls
Outlines
Auto Outline
Manual Outlines
Database Functions
A Few Definitions
DSUM
DGET
DCOUNT
DCOUNTA
|
Analysis Tools
Add-Ins
Available Excel Add-Ins
Data Tables
Some Definitions
One Input Data Tables
Two Input Data Tables
Deleting Data Tables
PivotTables
Some Definitions
Creating PivotTables
Modifying PivotTables
Auditing Workbooks
Some Definitions
The Auditing Toolbar
Goal Seek
Solver
Array Formulas
Arrays
Some Definitions
Working with Array Constants
Scenarios, Views, and Reports
The Scenario Manager
Scenario Summaries
The View Manager
Reports
The Goody Box
AutoSum Stuff
Fill Handle Stuff
Right-Click Stuff
Selecting Stuff
|