View Exercises-in-Excel on GitHub

Exercises-in-Excel

Project Overview

In this project, I am using Excel to work on various tasks such as:

  • Control structures in ms excel
  • Descriptive statistics
  • Using Ms Excel as a Database tool

1) Control structures in ms excel

To see the raw data from all the exercises and the tasks in question use this Link Check the solution is this File

shot1

2) Descriptive statistics

In this exercise, I calculate many statistics using functions as min, max,
average, var.p and validate them using the data analysis tool!
Also, I calculated and plotted CDF,PDF Check the solution Here

sho2

3) Using Ms Excel as a Database tool

In this one I used the functions vlookup,index,match,offset as well as
data validation methods. Check the solution Here

shot3