๐Ÿ“… 2024-07-16 โ€” Session: Enhanced Excel and Google Sheets Formulas

๐Ÿ•’ 19:30โ€“20:10
๐Ÿท๏ธ Labels: Excel, Google Sheets, VLOOKUP, Data Validation, Formulas
๐Ÿ“‚ Project: Dev
โญ Priority: MEDIUM

Session Goal

The session aimed to enhance data retrieval and validation techniques using Excel and Google Sheets formulas.

Key Activities

  • VLOOKUP with IF Statement in Excel: Developed a method to retrieve data based on student IDs using VLOOKUP combined with IF statements.
  • Troubleshooting VLOOKUP Column Index: Identified and corrected issues with the column index and data range in Excelโ€™s VLOOKUP function.
  • IFERROR with VLOOKUP in Google Sheets: Implemented error handling in Google Sheets using IFERROR to manage unmatched data scenarios.
  • Formula for Exam Grade Approval: Created a Google Sheets formula to evaluate and approve exam grades based on specific criteria.
  • Excel Formula Modification for Numeric Comparison: Adjusted Excel formulas to ensure numeric comparisons are accurately performed using ISNUMBER.

Achievements

  • Successfully developed and tested multiple formulas in both Excel and Google Sheets to enhance data processing capabilities.

Pending Tasks

  • Further testing of the formulas in larger datasets to ensure robustness.
  • Documentation of the new formulas for future reference.

Tags

Excel, Google Sheets, VLOOKUP, IFERROR, Data Validation, Formulas