Challenge No. 18: Dynamically generate a sales calendar for the month entered in F3, based on data from the given table.
Solved using:Excel, Power Query, and R.
MONTH
Returns the month number from a date in Excel.
Identify All-Season Products!
Challenge No. 14: Create a list of products sold in all the months throughout the year.
Solved using:Excel (COUNT, FILTER, LAMBDA), Power Query (Date.Month, List.Distinct, List.Transform), and R.
Calculate Average Inventory Level!
Challenge No. 8: The Question’s table outlines warehouse transactions with records for Initial value (warehouse product count), Add (purchased and incoming products), and Reduce (sold and outgoing products).
Solved using:Excel, and Power Query.