Creates custom reusable functions in Excel.
Challenge No. 24: Put the applicants on either shortlist, longlist or disqualify them
Use the required technologies for long or shortlist
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
Challenge No. 103: This is the 3rd in series of Caesar’s Cipher Challenges.
Solved using: SQL.
Challenge No. 102: This is first part of 2 parts Italian Fiscal Code (Codice Fiscale) generation challenges.
Solved using: SQL.
Challenge No. 101: Divide the numbers given in column A by 7 and round it up.
Solved using: Python in Excel.
Challenge No. 100: The string contains only English alphabets.
Solved using: SQL.
Challenge No. 99: List the companies which have positive annual growth rate during all 3 period years and their Average Annual Growth Rate (AAGR) .
Solved using: Python.
Challenge No. 103: Today is 20/08/2024, and we’re calculating the average delivery time per product in days.
Solved using:Excel (AVERAGE, CHOOSECOLS, FILTER), Google Sheets, Power Query (Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Challenge No. 98: From column A, find 2 numbers which when summed give the sum as in column C.
Solved using: Python.
Challenge No. 97: Yesterday, I ended up posting a complex challenge.
Solved using: Python in Excel.
Challenge No. 96: Calculate the Turn Around Time (TAT) i.
Solved using: Python.
