Tutorials for Excel functions and VBA are available here. The language is kept simple throughout — no prior programming experience needed. More tutorials are added regularly, so keep visiting.
📐Excel Functions
| 1 | VLOOKUP — Look up data from a large data range in Excel | Read Tutorial → |
| 2 | IF, AND, OR — Get data based on multiple criteria | Read Tutorial → |
| 3 | SUMIF & COUNTIF — Conditional summing and counting | Read Tutorial → |
| 4 | SUMPRODUCT — Advanced array-based calculations | Coming soon |
| 5 | String Manipulation & Concatenation — LEFT, MID, RIGHT, LEN, & | Coming soon |
💻Visual Basic for Applications (VBA)
| 1 | First Day with Excel VBA — A very basic introduction to programming | Coming soon |
| 2 | Working with Cells & Ranges — Copying and moving data | Coming soon |
| 3 | Moving from Cell to Cell — Various navigation methods | Coming soon |
| 4 | Cell Data Analysis — Reading and categorising cell contents | Coming soon |
| 5 | Looping & Decision Making — For loops, Do While, If statements | Coming soon |
| 6 | Arrays — Storing and processing multiple values | Coming soon |
📬
Suggest a tutorial topic. Is there an Excel or VBA topic you'd like explained? Send an email with the topic and your use case — it may be added to the list.