Skip to content

DevinXTian/Excel-Projects

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

9 Commits
Β 
Β 
Β 
Β 

Repository files navigation

πŸ“‘ Excel Data Analytics Portfolio

Welcome to my collection of data analytics projects, all conducted using Microsoft Excel. This repository serves as a showcase of my ability to transform raw data into actionable insights through advanced Excel techniques, including data manipulation, formula-based analyses, and visual storytelling.

Projects Overview

Each project listed below demonstrates a unique application of Excel tools to address real-world business questions and derive meaningful conclusions. Explore each project's dedicated folder to view detailed analyses, visualizations, and conclusions.

1. Coffee Business Analysis

Objective: Analyze customer orders and product details for a coffee business to identify trends and optimize operations.

  • Techniques Used: Index-Match, XLOOKUP, Pivot Tables
  • Key Insights: Developed strategic recommendations based on sales trends, customer behavior, and product performance.
  • View Project

About

Data Analytical Projects Using Excel

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors