100 everyday Excel formulas with examples

100 everyday Excel formulas in 10 groups, one page each, from SUM, IF, VLOOKUP and XLOOKUP to date, text and finance functions. Every page shows the syntax, a worked example table with the result, how the formula reads and what it is good for.

➕ Basics: 12 formulas

🧮 Math: 8 formulas

🔀 Logic: 14 formulas

📊 Stats and ranking: 8 formulas

🔎 Lookup: 12 formulas

⚡ Dynamic arrays: 8 formulas

🔤 Text: 18 formulas

📅 Date and time: 12 formulas

💰 Finance: 4 formulas

✅ Checks: 4 formulas

Function names and Excel versions follow Microsoft's function list · example tables match the Excel app in Thai Smiles

Updated 17 November 2026 · by Black Sheep Barn

🤖
Posting...
Please wait a moment
Social VIP Classroom
Home
Thai Smiles Profile