This directory contains shared Excel files used across multiple sessions in the course.

Files Overview

Sales Data

  • sales_data.xlsx - Monthly sales data with multiple sheets
  • sales_q1_2024.xlsx - Q1 2024 sales report
  • sales_q2_2024.xlsx - Q2 2024 sales report

Employee Data

  • employees.xlsx - Employee information and demographics
  • employee_salaries.xlsx - Salary and compensation data

Financial Data

  • financial_report.xlsx - Sample financial statements
  • budget_2024.xlsx - Annual budget allocation

Product Data

  • products.xlsx - Product catalog with pricing
  • inventory.xlsx - Inventory levels and locations

Customer Data

  • customers.xlsx - Customer contact information
  • customer_orders.xlsx - Order history

Creating Sample Files

The sample files can be generated using the create_sample_data.py script in this directory.

python create_sample_data.py

This will create all the sample Excel files with realistic data for practice.

Usage Notes

  • These files are for educational purposes only
  • Data is randomly generated and not from real sources
  • Feel free to modify and experiment with these files
  • Backup copies are maintained in backups/ folder