Ajay Anand
I am a Civil Engineer by education, a Highway Designer by profession, and a Coder by passion. After working on highway projects across India since 2007, I left my job in 2018 to start xlncad.com, sharing Excel and AutoCAD tips.
I’ve conducted Excel workshops, including one for the United Nations Environment Program (UNEP) in Geneva, and was honored with the Microsoft MVP Award in 2020 for my contributions to the Excel community.
I’d love to hear from you! Share your feedback in the comments. Thanks for visiting my channel—have a great day!
Ajay Anand
Ajay Anand
How to combine 3D models and Morph Transition in PowerPoint to create Awesome presentations, explained in Malayalam
https://youtu.be/43vhzj3gQTU
1 year ago | [YT] | 8
View 1 reply
Ajay Anand
Payslip Generator is an Excel Template which will generate the Payslips or Salaryslips of 1000+ Employees in a Single Mouse Click. With nominal customization, the same program can be used to generate Invoices / Bills / Timesheets etc.
my-store-b427d4.creator-spring.com/listing/payslip…
1 year ago (edited) | [YT] | 55
View 5 replies
Ajay Anand
Thank you😃❤️
2 years ago | [YT] | 141
View 16 replies
Ajay Anand
XL n CAD on Insta
www.instagram.com/ajayanand.xlncad/
2 years ago | [YT] | 53
View 0 replies
Ajay Anand
Maybe because of its' generic name, Excel Table is one of the most underused features of Excel. In this online course you will go through the essential things you need to know about the Table feature in Excel.
www.udemy.com/course/tables-in-excel/?referralCode…
Different methods to create Excel Table (including VBA)
-10 different advantages of using Excel Table
-How to use VLOOKUP on Excel Tables
-How to create Running Total using Excel Table
-How to AutoNumber Rows using Excel Table
-How to Connect Excel Tables
and more...
2 years ago (edited) | [YT] | 57
View 0 replies
Ajay Anand
Books on Microsoft Excel, VBA for Excel, Power Query, Power Pivot and Power BI
xlncad.com/excel-resources/
2 years ago | [YT] | 53
View 2 replies
Ajay Anand
The complete guide to Excel 2016, from John Walkenbach also known as Mr.Spreadsheet
amzn.to/3LKUZb1
- Master formulas, formatting, pivot tables, and more
- Get acquainted with Excel 2016's new features and tools
- Create functional spreadsheets that work
2 years ago | [YT] | 48
View 0 replies
Ajay Anand
How to link cells to Text boxes and Shape objects in Excel.
https://youtu.be/sEdFqcGdgDo
4 years ago | [YT] | 12
View 4 replies
Ajay Anand
A friendly discussion (technically an Interview) with the team @inspireedge5758 about the importance of Spreadsheet, especially #microsoftexcel, in our daily and business lives.
The 28-minute long video covers the inception of #XLnCAD, about my Excel Workshop at the United Nations Environment Program, Microsoft's recognition in the form of MVP Award, the necessity of integrating spreadsheets into the school curriculum, etc.,
It was a Great session and had fun 😍 working with a brilliant team.
Note that the interview is in 'Malayalam' (Official language of Kerala, India).
4 years ago | [YT] | 2
View 0 replies
Ajay Anand
The teaser of the Interview with Team @inspireedge5758
https://youtu.be/JC9RO5jnsvk
4 years ago | [YT] | 3
View 0 replies
Load more