Developed Data Manipulation Techniques in Excel and Google Sheets

1 min read

📅 2024-10-14 — Session: Developed Data Manipulation Techniques in Excel and Google Sheets

🕒 18:30–20:15
🏷️ Labels: Google Sheets, Excel, Data Manipulation, Formulas
📂 Project: Dev
⭐ Priority: MEDIUM

Session Goal

The session aimed to develop and refine data manipulation techniques in Excel and Google Sheets, focusing on replicating functionalities similar to Pandas in Python.

Key Activities

  • Simulated the ‘stack’ functionality from Pandas in Google Sheets using ARRAYFORMULA, FLATTEN, and FILTER functions.
  • Proposed improvements to the data structure of Individualized Study Plans (PEI) to enhance efficiency by adopting a ‘long’ format.
  • Developed methods to retrieve the latest date from datasets in both Google Sheets and Excel using formulas like FILTER, SORT, INDEX, and addressed common formula errors.
  • Provided corrected formulas and troubleshooting tips for common errors in Google Sheets and Excel, including syntax issues and formula parsing errors.

Achievements

  • Successfully created and documented methods for complex data manipulation tasks in Google Sheets and Excel.
  • Enhanced understanding of formula application and error resolution in spreadsheet software.

Pending Tasks

  • Further exploration of optimizing data retrieval methods and error handling in larger datasets.

Graph View

Backlinks