Knowledge Base – Excel, SQL, Python

Excel – knowledge base

• SEARCH in Excel. How it works including examples.
• IFERROR in Excel. How it works including examples.

---

---

SQL – knowledge base

• DENSE_RANK in SQL. How it works including examples.
• CASE WHEN in SQL. How it works including examples.
• CAST in SQL. How it works including examples.

---

---

Python – knowledge base

• read_csv in pandas in Python – how does it work?

---

---

Statistics – knowledge base

• soon 🙂

---

---