  
    Excel: 
> Data > Get Data > From File > From Excel Workbook
  Select Multiple Items
     ws_data_2025
     ws_data_2026
  Transform Data 
  > Power Query Editor 
    > Navigator > Transform Data (Click)
      > Merge 
           Top Table    = ws_data_2025
           Bottom Table = ws_data_2026
           Join Kind = Left Outer
    > Check data quality
      > Dropdown 
      > Home > Transform > Replace Values
      > Ctrl+Click
      > Home > Remove Rows > Remove Duplicates
    > Close & Load       
  

  
    Excel: 
> File > Options > Add-ins ? Analysis ToolPak
  > Data > Analysis > Data Analysis
    > Descriptive Statistics
      > Input Range         = F:H     = Adjacent columns of numerical values
      > Grouped by          = Columns
      > Labels in First Row = Yes
      > New Worksheet Ply   = (Give it a name)
      > Summary statistics  = Yes
        > Mean
        > Standard Error
        > Median
        > Mode
        > Standard Deviation
        > Sample Variance
        > Kurtosis
        > Skewness
        > Range
        > Minimum
        > Maximum
        > Sum
        > Count
  

  
    Data Visualization: x1_Cat, x2_Cat, x3_Cat, y_Num
Excel: 
> Data Table > Ctrl + Select 1 Field Column + 3 Value Columns
  > Insert > Column or Bar Chart > Clustered Column

Contact