Excel for Data Analysis

This repository documents my learning journey with Excel as part of my Data Analyst preparation.

I am learning how Excel can be used to organize, clean, analyze, and visualize data, and how to turn raw data into useful insights.

What I Am Learning

Excel Fundamentals

• Excel interface and workbooks
• Worksheets, rows, columns, cells, and ranges
• Entering and organizing data
• Formatting data
• Working with tables

Formulas & Functions

• Basic mathematical formulas
• Relative and absolute cell references
• SUM
• AVERAGE
• COUNT
• MIN and MAX
• Logical functions
• Text functions
• Date functions
• Lookup functions

Data Cleaning & Preparation

• Identifying and fixing data errors
• Handling missing values
• Removing duplicates
• Cleaning text data
• Working with dates
• Preparing raw data for analysis

Data Analysis

• Sorting and filtering
• PivotTables
• Aggregating data
• Finding patterns and trends
• Comparing different groups of data
• What-if analysis
• Forecasting
• Moving averages
• Trendlines

Data Visualization

• Creating charts
• Choosing appropriate charts
• Presenting data clearly
• Communicating insights through visualizations

Courses

I am using the following courses to build my Excel skills:

1. Introduction to Excel
2. Data Preparation in Excel
3. Data Analysis in Excel

Repository Structure

excel-for-data-analysis/
│
├── README.md
│
├── 01-Introduction-to-Excel/
│   └── practice
│
├── 02-Data-Preparation-in-Excel/
│   └── practice
│
├── 03-Data-Analysis-in-Excel/
│   └── Practice
│
├── Certification/Statement of accomplishement/
│   └── Introduction to excel certificate.pdf
│   └── Introduction to excel certificate.png
│
├── Datasets/
│   └── Demo
│   └── Workbooks  
│
├── License

What I Will Add

As I learn, I will add:

• My own learning notes
• Excel practice files
• Small data analysis exercises
• Excel projects
• Examples of data cleaning and analysis
• Data visualizations
• Insights from analyzed datasets

Goal

The goal is to become comfortable using Excel as a practical data analysis tool and build a strong foundation before moving deeper into other Data Analyst tools such as SQL, Python, Pandas, and data visualization.

Learning Progress

• Excel Fundamentals
• Formulas & Functions
• Data Cleaning & Preparation
• Data Analysis
• PivotTables
• Data Visualization
• Excel Projects