Challenge No. 86: Align the names under their respective cities.
Solved using: Power Query.
LAMBDA
Creates custom reusable functions in Excel.
Subjects Taught Exclusively
Challenge No. 85: Column A lists down subjects taught by Female and Male Teachers.
Solved using: SQL.
Pascal Case to Snake Case
Challenge No. 84: Change Pascal Case to Snake Case.
Solved using: Python in Excel.
Lookup and Concat Data Using a Criteria
Challenge No. 19: Lookup Subjects where at least 2 students scored 90 and above Dynamic array function allowed, but Extra marks for Legacy Array Functions or PowerQuery Solution.
Solved using: Power Query.
Match Output to Picture
Challenge No. 83: Generate the output as shown in picture.
Solved using: SQL.
Random Selection! Part 2
Challenge No. 99: Randomly select 4 unique staff members using the following procedure:
1- Randomly select a department out of 5 departments with equal probability.
Solved using:Excel, Power Query, and R.
Reverse Words in String
Challenge No. 82: Reverse the Words in the string.
Solved using: SQL.
Extract Min and Max From
Challenge No. 79: Extract the maximum and minimum numbers from the strings.
Solved using: SQL.
Data Cleaning! Part 1
Challenge No. 98: In the Question table, historical sales values are provided in a single cell, including the Date, Product Name, and Quantity, but in a disorganized order.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (List.Transform, Text.Contains, Text.Split), Python, Python in Excel, and R.
Top 4 Winner and Runner-up
Challenge No. 78: — This week will be FIFA World Cup week.
Solved using: SQL.