USD Business Analytics Club — Excel Guide

Welcome to the Excel Guide — a curated repository of hands-on Excel projects developed for members of the USD Business Analytics Club. These exercises are adapted from practical scenarios and include full video walkthroughs to help you master Excel for real-world business problems.

---

📁 Projects Overview

🔢 Project 1: Budget Projections

Plan and adjust budget forecasts with inflation and update scenarios.

🎥 Watch Video Walkthrough
📂 Folder: project_1_budget_projections

---

💍 Project 2: The Wedding Report

Create cost estimates and dashboards for a fictional wedding planning scenario.

🎥 Watch Video Walkthrough
📂 Folder: project_2_wedding_report

---

🧼 Project 3: Data Cleaning for Collection Analysis

Work with messy bibliometric data and practice cleaning and preparing journal metadata for analysis.

🎥 Watch Video Walkthrough
🔗 SCImago Journal Rankings
📂 Folder: project_3_data_cleaning

---

🔗 Project 4: Data Matching for Collection Analysis

Match and summarize SCImago data with institutional holdings to generate actionable reports.

🎥 Watch Video Walkthrough
📂 Folder: project_4_data_matching

---

📚 What You'll Learn

• ✅ Data cleaning using IF, COUNTIF, XLOOKUP, and INDEX/MATCH
• 📊 Scenario modeling and conditional formatting
• 📈 Dashboards using PivotTables and structured references
• 🔍 Matching external data sources like SCImago

👥 Who It's For

These projects are ideal for:

• USD Business Analytics Club members
• Students preparing for internships or analytics roles
• Anyone looking to strengthen their Excel and reporting skills

📝 How to Use

1. Choose a project folder.
2. Read the README.md inside (if available).
3. Open the Excel files and follow the linked video tutorial.
4. Try completing the project yourself and compare your approach.

---

Let’s build better Excel habits — one formula at a time.
– USD Business Analytics Club