Using Excel as Database
- Database Concepts
- Using Forms
- Database & Field Name Guidelines
- Sorting Data & Conditional Formatting
- Filtering Data & Advance Filter
- Data Validation
- Adding Subtotal and Pivot Table
- Summary
Click on the links below to watch videos of the same topic:
| 1. | Database Concepts |
| 2. | Using Forms |
| 3. | Form Operations |
| 4. | Filtering Data |
| 5. | Advance Filter |
| 6. | Sorting Data |
| 7. | Conditional Formatting |
| 8. | Data Validation |
| 9. | Adding Subtotal |
| 10. | Pivot Table |
Here are the links for questions/answers, exercises and worksheet with answer keys:
Comments