Databases and Lists
What is a Database?
Databases & Spreadsheets Similarities
External Database File
Excel Database List
The Data Form
Entering Data Form Data
Locating Data with Data Form
Comparison Operators
Sorting a List
Push Button Sorting
Default Sort Assumptions
Sorting With Data, Sort...
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 Conditions
Or Conditions
Subtotals
Preparing a Table for Subtotals
Outline Controls
Database Functions
A Few Definitions
DSUM(database,field,criteria)
DGET(database, field, criteria)
DCOUNT(dbase,field,criteria)
DCOUNTA(database,field,criteria)
Data Validation
Controlling Numeric Entry
Validation Lists
Extending Validation Criteria
Custom Validation Criteria
Error Alert Styles
Validation Limitations
|
Analysis Tools
Add-Ins
Data Tables
Some Definitions
One Input Data Tables
Two Input Data Tables
Deleting Data Tables
PivotTables and PivotCharts
Some Definitions
Creating a PivotTable
Modifying the PivotTable
Controlling PivotTable Display
Formatting PivotTables
PivotTable AutoFormat
Creating a PivotChart
Auditing Workbooks
Some Definitions
The Auditing Toolbar
Tracing
Tracing Errors
Auditing Toolbar & Data Validation
Goal Seek
Solver
Scenarios, Views, and Reports
The Scenario Manager
Scenario Summaries
Custom Views
Reports
Appendix A - Array Formulas
Appendix B - Goodies
AutoSum Stuff
Fill Handle Stuff
Right-Click Stuff
Selecting Stuff
A Range Selection Trick
Appendex C - Outlines
|