Databases and Lists
What is a Database?
External Database File
Excel Data List
Data Forms
Entering Data Form Data
Locating Data with Data Form
Comparison Operators
Sorting a List
Push Button Sorting
Default Sort Assumptions
Left to Right Sort
Custom Sort Orders
Defining a Custom List
Filtering a List
What is a Filter?
AutoFilter
Custom AutoFilter
Top 10 AutoFilter
Removing AutoFilter
Using Advanced Filter
Some Definitions
Criteria Range
And Condition
Or Condition
Subtotals
Preparing a Table for Subtotals
Outline Controls
Outlines
Auto Outline
Manual Outlines
Database Functions
A Few Definitions
DSUM, DGET,
DCOUNT, & DCOUNTA
Data Validation
Controlling Numeric Entry
Validation Lists
Extending Validation Criteria
Custom Validation Criteria
Error Alert Styles
Validation Limitations
|
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 a PivotTable
Modifying the PivotTable
Formatting PivotTables
Auditing Workbooks
Some Definitions
The Auditing Toolbar
Tracing Precedents & Dependents
Tracing Errors
The Auditing Toolbar and Data Validation
Goal Seek
Solver
Scenarios, Views, and Reports
The Scenario Manager
Scenario Summaries
Custom Views
Reports
Appendix
Array Formulas
Some Definitions
Working with Array Constants
Goodies
AutoSum Stuff
Fill Handle Stuff
Right-Click Stuff
Selecting Stuff - A Selection Trick
|