Welcome to Excel Guide — your comprehensive reference for mastering Microsoft Excel! This repository serves as a central hub, collecting all specialized Excel topics, cheat sheets, and formula guides, each organized into its own module for easy navigation and learning.
Below you'll find links to all related repositories, each covering a specific aspect of Excel. Click on any topic to jump directly to its dedicated guide!
| Icon | Repository | Description |
|---|---|---|
| 📘 | Excel-1 | Ranges, AutoFill, Flash Fill, Auto Fit, Paste Special, SEQUENCE and TEXTSPLIT formulas |
| 📝 | Excel-2 | Basic formulas and functions + more (COUNT, SUM, IF, AVERAGE, COUNTIF, SUMIF, VLOOKUP, MIN, MAX, SUMPRODUCT, MOD, ABS, PRODUCT, SQRT, Named ranges, Paste Special) |
| 🔍 | Excel-3 | Find & Select, Replace, Go To Special, Delete Blank Rows, Row Differences, Wildcards |
| ✅ | Excel-4 | Data validation, Drop-down tables |
| ⌨️ | Excel-5 | Shortcuts, Function Keys, Inserting/Deleting, Bullet Points |
| 🔗 | Excel-6 | Logical functions, IFS, SWITCH |
| 🕒 | Excel-7 | Date and Time functions |
| 🔤 | Excel-8 | Text functions: LEFT, RIGHT, MID, LEN, FIND, SUBSTITUTE, TRIM, Text To Columns, SEARCH, UPPER, LOWER, PROPER, EXACT, TEXT, CONCATENATE, TEXTJOIN, TEXTBEFORE, TEXTAFTER |
| 💰 | Excel-9 | Financial Functions: PMT, RATE, NPER, PV, FV, PPMT, IPMT, Compound Interest, CAGR, RRI, NPV, IRR, Depreciation Formulas, Profit Margins |
| 🗂️ | Excel-10 | Lookup & Reference Functions, VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, XMATCH, CHOOSE, OFFSET |
| 📈 | Excel-11 | Statistical Functions: AVERAGE, AVERAGEIF, MEDIAN, MODE, STDEV, MIN, MAX, LARGE, SMALL, Weighted Average, Moving Average, RAND, RANDARRAY, RANK, Percentiles and Quartiles, Box and Whisker Plot, FORECAST, FREQUENCY |
| 🔢 | Excel-12 | Round Numbers in Excel |
| Excel-13 | Sort Data in Excel | |
| 🧹 | Excel-14 | Filter Data, Advanced Filter, Subtotal, Data Form, Remove Duplicates, Outlining Data, SUBTOTAL function, Unique Values, UNIQUE function, FILTER function |
| 🖍️ | Excel-15 | Conditional Formatting, Blank cells, Duplicates, Heatmap, Data bars |
| 📊 | Excel-16 | Charts, Sparklines, Combination Chart, Gantt Chart, Thermometer Chart |
| 🧮 | Excel-17 | Pivot Tables, Grouping, Multi-level Pivot Tables, Multiple Report Filter Fields, Frequency Distribution, Pivot Charts, Slicers, Calculated Field/Item, GETPIVOTDATA function |
| 📝 | Excel-18 | Tables, Quick Analysis Tool, Structured References, Table as Source Data |
| 🧪 | Excel-19 | What-If Analysis, Goal Seek, Data Tables, Solve Quadratic Equation |
| 🧮 | Excel-20 | Solver, Sensitivity Analysis |
| 📊 | Excel-21 | Analysis ToolPak, Histogram, Descriptive Statistics, Moving Average, Exponential Smoothing, Correlation Analysis, Regression Analysis |
- Comprehensive coverage of Excel topics
- Quick links to deep-dive repositories
- Cheat sheets, examples, and best practices
- Beginner to advanced techniques included
- Browse the table above for the topic you need help with.
- Click the repository link to explore detailed guides, examples, and resources.
- Clone or download any repo for offline reference.
Found something missing or want to add new Excel tips?
Feel free to open issues or pull requests in the relevant repository!
These excellent resources were used as references for creating the modules in this project. Make sure to check them out!
Happy Excelling!
Maintained by Kuba27x