Challenge No. 170: Given a N*N board with the Knight placed on the first block of an empty board.
Solved using:Excel, Python, and Python in Excel.
Excel Functions
Excel functions used in data analysis
Custom Grouping! Part 3
Challenge No. 109: Dates were grouped by sales trends, with each group extending until a drop in sales occurred.
Solved using:Excel, Google Sheets, Power Query, Python, Python in Excel, and R.
Top Products!
Challenge No. 96: In the Question table, daily sales information is provided.
Solved using:Excel, Google Sheets, Power Query, Python, R, and SQL.
Traveling Salesman Problem
Challenge No. 90: The Traveling Salesman Problem (TSP) is a well-known problem in mathematics used to determine the optimal travel path that visits all cities exactly once with the minimum cost.
Solved using:Excel, Power Query, Python, and R.
Subtotal Calculation!
Challenge No. 88: In the question table, sales info is provided.
Solved using:Excel, Power Query, Python, R, and SQL.
Highlight Merged Cells
Challenge No. 24: In Conditional Formatting write a formula to highlight the merged cells.
Solved using:Excel, R, and VBA.
Visualization!
Challenge No. 17: Efficiently visualize sales data using the least number of charts and slicers possible.
Solved using: Excel.
Presenting The Whole Result On The Unhide Cells!
Challenge No. 7: Filter rows with quantity equal to 9 and display the entire result in unhidden cells.
Solved using:Excel, and Power Query.