Practical examples of using Excel and Access
This site provides help with Microsoft Excel
and Access. There are
examples of spreadsheet functions and database queries and programs.
Advice
is also given on spreadsheet testing, enhancing graphs, configuring
Excel and documenting databases.
 |
|
|
|
|
Excel functions and utilities |
- Practical examples of many functions
- Useful tips for your graphs
- Make web pages from Excel
- Configure Excel
- Check and map your spreadsheet
|
|
|
|
|
Access queries and programs |
- Twenty things to do with a query
- Examples of VBA programs
- Export data from Access
- an Office Leave database
|
|
|
|
|
Links |
- links to other useful web sites
|
|
"Some cause
happiness wherever they go - others whenever they go"
Oscar Wilde
|