What do you want to do in Excel?
By Ajay Anand · 7× Microsoft Excel MVP · 500K+ YouTube subscribers · Watch on YouTube →
Popular: XLOOKUP Lakh and crore Remove duplicates Numbers to words WhatsApp from Excel
XL n CAD is a free Excel tutorial site by Microsoft Excel MVP Ajay Anand, for students, office professionals and data analysts, with step-by-step guides to formulas, functions, Power Query, VBA macros, Word, PowerPoint and AutoCAD.
Free tools that run in your browser
No sign-up and no upload: your files stay on your computer.
Learn with me in English or Malayalam
Free videos every week on YouTube, and full courses on Udemy when you want to go step by step.
Most read guides
- Find the day name from a dateFormula
- Create an organizational chartCharts
- Connect Google Sheets to ExcelPower Query
- Stock prices with STOCKHISTORYFunction
- 10 ways to create serial numbersFormula
- Find common values in two listsFormula
- Convert numbers to wordsFormula
- Remove duplicates, 7 waysData
- VLOOKUP from two or more tablesFormula
- Import X, Y, Z coordinates to AutoCADAutoCAD
Get the free Excel Shortcuts PDF
202 tested keyboard shortcuts in 16 categories, in one PDF you can print or keep on your phone. Enter your email and it arrives in a minute.
No spam. You’ll also get occasional Excel tips by email. Unsubscribe anytime.
I’m Ajay Anand, a civil engineer who has taught Excel full time since 2018, and a Microsoft Excel MVP seven years running. More about me
Need a loan, tax or construction calculator? Try Quick Easy Calculators, our sister site.