📅 2024-07-16 — Session: Enhanced Excel and Google Sheets Formula Techniques
🕒 19:30–20:10
🏷️ Labels: Excel, Google Sheets, VLOOKUP, Formulas, Data Validation
📂 Project: Dev
⭐ Priority: MEDIUM
Session Goal:
The session aimed to enhance data retrieval and validation techniques in Excel and Google Sheets using advanced formula functions.
Key Activities:
- VLOOKUP with IF Statement in Excel: Explored using the VLOOKUP function combined with an IF statement to retrieve data based on student IDs, including detailed examples and explanations.
- Troubleshooting VLOOKUP Column Index: Addressed issues with the column index and data range in Excel’s VLOOKUP function, ensuring accurate data retrieval from specified ranges.
- Using IFERROR with VLOOKUP in Google Sheets: Implemented the IFERROR function with VLOOKUP in Google Sheets to gracefully handle errors by returning a hyphen when no match is found.
- Google Sheets Formula for Exam Grade Approval: Developed a formula to check exam grades, returning ‘APROBADO’ if conditions are met, using IF and AND functions.
- Excel Formula Modification for Numeric Comparison: Modified formulas using the ISNUMBER function to ensure numeric-only comparisons, enhancing data validation.
Achievements:
- Successfully integrated advanced Excel and Google Sheets functions to improve data retrieval and validation processes.
Pending Tasks:
- Further refinement of formula templates for broader application scenarios.