Macros, filters, formatting, data types, errors, and everything else beyond formulas — real guides on how to practice Excel online and actually get good at it, not just read about it.
This hub collects the Excel guides on Cellgrids in one place. Start with the basics, then move to formulas, lookups, pivot tables, dashboards and automation. Every guide uses plain English and an example you can try yourself.
New to Excel? Read how to use VLOOKUP, how to calculate percentage, and how to use IF, AND and OR. To total and count by condition, see SUMIF and COUNTIF. When formulas show errors, learn IFERROR with VLOOKUP.
Ready to practise? Open the free Excel practice sheet, browse the complete formulas list, learn Excel keyboard shortcuts, or prepare with Excel interview questions. If you want a guided path with tests and certificates, see our Excel courses and the guide to choosing the right course.
