Enhanced Spreadsheet Formula Techniques

📅 2024-08-13 — Session: Enhanced Spreadsheet Formula Techniques

🕒 04:20–05:20
🏷️ Labels: Google Sheets, Excel, Formulas, Data Analysis, Troubleshooting
📂 Project: Dev
⭐ Priority: MEDIUM

The goal of this session was to enhance proficiency in using spreadsheet formulas across Google Sheets and Excel for various data manipulation tasks.

Explored the use of the EXACT function in Google Sheets for string comparison and provided an alternative using the IF function for case-insensitive matches.
Provided a troubleshooting guide for formula syntax and cell references in spreadsheets, focusing on the EXACT function.
Developed a formula in Google Sheets for date calculation using IF, SEARCH, and DATE functions.
Explained Excel formulas for calculating age differences using DATEDIF and TODAY() functions.
Demonstrated the use of IFERROR with SEARCH in Excel for error handling.
Combined IF and IFERROR functions in Excel to calculate age while handling errors.
Created a formula in Google Sheets to calculate the average of non-null values using ARRAYFORMULA, FILTER, and AVERAGE functions.

Successfully provided detailed guides and templates for various spreadsheet formula techniques in both Google Sheets and Excel.