Excel-For-Data-Analysis

This repository contains my practice exercises and projects related to data analysis using Microsoft Excel.

Advanced Excel

In Advanced Excel Sub repo u will find Day1 to Day_End and each excel file contains more than 4-5sheets in single excel file

Name		Name	Last commit message	Last commit date
Latest commit History 45 Commits
Advanced Excel For Data Analytics		Advanced Excel For Data Analytics
Lookups		Lookups
Data_Cleaned2_Duplication_Cases_Spaces_Left_Right_Flash_Fill.xlsx		Data_Cleaned2_Duplication_Cases_Spaces_Left_Right_Flash_Fill.xlsx
LOOKUP_ASSIGNMENTS_FOR_ALL.xlsx		LOOKUP_ASSIGNMENTS_FOR_ALL.xlsx
Measures_of_Dispersion_Variance_SD_MAX_Min.xlsx		Measures_of_Dispersion_Variance_SD_MAX_Min.xlsx
README.md		README.md
Variance_StandardDeviation.xlsx		Variance_StandardDeviation.xlsx
calculate_employee_net_pay_assignments_practice.xlsx		calculate_employee_net_pay_assignments_practice.xlsx
central_tendency_datasets.csv		central_tendency_datasets.csv
data_clearning_remove_duplication_spaces.csv		data_clearning_remove_duplication_spaces.csv
day1_basic_arithmetic_operations.xlsx		day1_basic_arithmetic_operations.xlsx
day1_basics.xlsx		day1_basics.xlsx
day2_Personal_Monthly_Expenditure.xlsx		day2_Personal_Monthly_Expenditure.xlsx
day3car_sales_data_jan_2024.csv.xlsx		day3car_sales_data_jan_2024.csv.xlsx
day4car_sales_data_jan_2024_using_functions.csv		day4car_sales_data_jan_2024_using_functions.csv
day4car_sales_data_jan_2024_using_functions.csv.xlsx		day4car_sales_data_jan_2024_using_functions.csv.xlsx
day5_Personal_Monthly_Expenditure.csv		day5_Personal_Monthly_Expenditure.csv
day5_Personal_Monthly_Expenditure.xlsx		day5_Personal_Monthly_Expenditure.xlsx