XL n CAD: Excel Tutorials, Free Tools and Courses by Ajay Anand.

7× Microsoft Excel MVP · 500,000+ learners

Excel, explained simply

Free tutorials on functions, formulas, macros and Power Query, with practice files and free online tools. In English and Malayalam.

Start learning ExcelExplore my courses
  • 7× Microsoft Excel MVP
  • 500K+ YouTube subscribers
  • 2 languages: English and Malayalam
  • Teaching Excel since 2018
Start here

What do you want to learn?

Pick a topic. Every guide has clear examples, and most come with a practice file.

fxExcel FunctionsEvery function explained, with examples and practice files =Excel FormulasReady-made formulas for everyday problems VBAExcel Macros100+ VBA macros you can copy and use CtrlShortcuts200+ keyboard shortcuts, by task PQPower QueryClean and combine data without formulas ₹CalculatorsSIP, EMI, GST and age, with the Excel formula ⚙Free ToolsPDF to Excel, invoices, QR codes and more CADAutoCADCommands, aliases and AutoCAD macros

Learning in Malayalam? See Excel in Malayalam. Need a loan, tax or construction calculator? Try Quick Easy Calculators, our sister site.

Ajay Anand

Hi, I’m Ajay Anand

Civil Engineer · 7× Microsoft Excel MVP

I worked in highway design from 2007 to 2017. Since 2018 I have been teaching Excel full time, on YouTube in English and Malayalam, on Udemy, and here on xlncad.com.

More about me
Courses

Learn with me, step by step

Full video courses on Udemy, with exercises and practice files. Lifetime access.

Ajay Anand with the Excel logoMalayalam

Microsoft Excel: Beginner to Professional

Learn Excel step by step, from the basics to formulas, PivotTables and dashboards.

View on Udemy
Ajay Anand with the Excel logoEnglish

Excel: Beginner to Confident User

The English edition, taught the same way as my videos, in short lessons.

View on Udemy
WMalayalamAjay Anand

Learn Microsoft Word in Malayalam

Format documents, tables and reports quickly and professionally in Word.

View on Udemy
Most read

Popular Excel tutorials

  1. Find the Day Name From a Date
  2. Create an Organizational Chart
  3. Connect Google Sheets to Excel
  4. STOCKHISTORY: Stock Prices in Excel
  5. 10 Ways to Create Serial Numbers
  6. Find Common Values Between Two Lists
  7. Convert Numbers to Words
  8. Remove Duplicates in Excel (7 Ways)
  9. VLOOKUP From Two or More Tables
  10. Import X, Y, Z Coordinates to AutoCAD
Free videos

Watch on YouTube, in English or Malayalam

Short, practical Excel videos every week, from quick tips to full projects.

English channelMalayalam channel
200K+English subscribers
300K+Malayalam subscribers
WeeklyNew videos
FreeAlways