1. Processing Data with Excel¶

Processing Data with Excel¶

• 1.1. Storing Data in Excel
• 1.2. Formating Data
• 1.3. Common Spreadsheet Errors
• 1.4. Dates as Data
• 1.5. Quality Control
• 1.6. Exporting Data
• 1.7. Reading in Standard Data
• 1.8. Sorting and Filtering Data
• 1.9. Basic String Functions
• 1.10. Pivot Tables
• 1.11. Appending with the OFFSET() Function
• 1.12. Merge Tables with the MATCH() and INDEX() Functions
• 1.13. Application: Association Rules, i.e. Market Basket Analysis