Data Analysis Excel

Hi we would like an excel sheet to 1. Import data into a Raw Data tab 2. Press a button to run a macro that creates a "Clean data tab" cleans the Raw data. Each cleaning action will be noted on a Meta Data log. Cleaning actions will include removing columns that have no results across all rows. Removing rows that have no results across all columns, Verifying all data is in the correct data type and deleting those that are not, adding default data to any unfilled cells, filling in location names Once data is clean, create a "log data" tab with clean data logged 3. after cleaning the data, a "Deep Learning" tab will be generated. This will include getting the top 10 and bottom 10 results from the clean data for each element. 4. We will create a Data Mining Dashboard with the analysis requested. things like element ratios comparing elements anomaly detection Cases, Variables, Types of variables Matrix and Frequency Table Graphs and shapes of Distributions Mode, Median and Mean Range, Interquartile Range and Box Plot Variance and Standard Deviation Z-scores Contingency Table, Scatterplot, Pearson’s r Basics of Regression Elementary Probability Random Variables and Probability Distributions Normal Distribution, Binomial Distribution & Poisson Distribution Analysis of variance I have attached a rough draft