SOME IMPORTANT KEYS FOR EDIT YOUR EXCEL
Mini Excel Editor — Shortcuts, Formulas & Power Query Simulation
Golden Web Tools
Click any colored menu: it first shows the formula, then the explanation, then an example.
| Name | JoinDate | Gender | Amount | Remark |
|---|---|---|---|---|
| alice | 2024/1/5 | F | 1200.5 | good |
| BOB | 2024-02-10 | M | 800 | error |
| carol | 2024/3/15 | F | 2000 | ok |
| david | bad-date | 1500 | #N/A |
Log output...
—
① Formula / Shortcut
—
② Explanation
—
③ Example
—