📖 Overview This repository contains an Excel workbook where I’ve documented and practiced a wide range of Excel formulas. The goal of this project is to build a strong foundation in spreadsheet problem‑solving, data analysis, and automation using Excel’s built‑in functions. ✨ Features
- Collection of commonly used Excel formulas
- Examples of how each formula works
- Notes on syntax and use cases
- Practical exercises for learning and revision 🧮 Functions Covered Some of the key formulas included:
- Mathematical & Statistical: SUM, AVERAGE, ROUND, COUNT, MAX, MIN
- Logical: IF, AND, OR, NOT
- Lookup & Reference: VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP
- Text Functions: LEFT, RIGHT, MID, LEN, CONCATENATE, TEXT
- Date & Time: TODAY, NOW, DATEDIF, EDATE, EOMONTH
- Error Handling: IFERROR, ISNA, ISERROR (You can expand this list with the exact formulas you’ve practiced in your file.) 🎯 Purpose
- To strengthen my Excel skills through hands‑on practice
- To create a personal reference guide for future projects
- To share my learning journey with others who want to improve their Excel knowledge 🚀 How to Use
- Download the Excel file from this repository.
- Open it in Microsoft Excel (or Google Sheets for most formulas).
- Explore the examples and try modifying them to see how the formulas behave. đź“Ś Future Plans
- Add more advanced formulas (e.g., ARRAYFORMULAS, POWER QUERY, PIVOT TABLES)
- Include real‑world datasets for practice
- Document step‑by‑step problem‑solving approaches