Challenge No. 234: Find the total leaves taken by the employees.
Solved using: Python.
Table.AddColumn
Adds a new column to a table with computed values in Power Query.
Calculate Shipped Fruit Value
Challenge No. 233: Calculate the Shipped and Non-shipped amounts (Quantity * Price) for all Fruits.
Solved using: Python.
Quantity Times Price Total
Challenge No. 231: Pivot the problem tables into result table.
Solved using: Python in Excel.
Reshape Wide Table Format
Challenge No. 224: Transpose the problem table into result table.
Solved using: Python.
List Subject Pass Students
Challenge No. 222: Marks for various tests are given in problem table.
Solved using: R.
Hierarchical Project Indexing
Challenge No. 221: Do the Indexing for project, task and activity.
Solved using: Python.
Distribute Activities by Month
Challenge No. 220: This challenge is contributed by Ahmad Syawal Ramli
Align the activities month-wise for each project.
Solved using: Python in Excel.
Calculate Monthly Payments
Challenge No. 217: Transpose the table as shown by showing the amount paid each month.
Solved using: Python in Excel.
Salesperson Commission Breakdown
Challenge No. 212: Find the total commission of each sales person and sort it descending on total amount.
Solved using: Python.
Group by Income Then Sort
Challenge No. 211: Append the groups one below the other and sort on Income descending, Name ascending within each group.
Solved using: R.