Ajay Anand - Invidious

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

View channel on YouTube

Switch Invidious Instance

Shorts

newest

oldest

popular

1:00

Convert Capital letters to Small letter using Flash Fill | Excel Tutorial

Ajay Anand

Shared 55 years ago

1.8K views

1:00

Extract Last Name using Flash Fill in Excel

Ajay Anand

Shared 55 years ago

5.4K views

1:00

Combine data from multiple columns using FLASH FILL in Excel

Ajay Anand

Shared 55 years ago

3.6K views

1:00

Current date in Google Sheets

Ajay Anand

Shared 55 years ago

1.3K views

1:00

Excel tip to Pad Text with a Character

Ajay Anand

Shared 55 years ago

6.1K views

1:00

Excel Trick to Convert to Numbers into Percentage

Ajay Anand

Shared 55 years ago

19K views

1:00

Excel trick to Pad Numbers with a character

Ajay Anand

Shared 55 years ago

5.4K views

1:00

Excel formula to Calculate Percentage of Marks

Ajay Anand

Shared 55 years ago

5.9K views

1:00

Star Rating in Google Sheets

Ajay Anand

Shared 55 years ago

4K views

1:00

Excel formula to calculate Percentage of Total

Ajay Anand

Shared 55 years ago

7.4K views

1:00

Excel trick to Pad Numbers with Zeros

Ajay Anand

Shared 55 years ago

7.1K views

1:00

Excel formula to calculate Percentage

Ajay Anand

Shared 55 years ago

4.4K views

1:00

Pad Numbers with Zeros | Microsoft Excel Trick

Ajay Anand

Shared 55 years ago

30K views

1:00

Excel formula to create Automatic Serial Numbers

Ajay Anand

Shared 55 years ago

34K views

1:00

Randomly sort a dataset in Excel #excelshorts

Ajay Anand

Shared 55 years ago

17K views

1:00

Find the Rank of only those students who have Passed #excelshorts

Ajay Anand

Shared 55 years ago

40K views

1:00

Conditional Formatting for Checkboxes in Google Sheets #excelshorts

Ajay Anand

Shared 55 years ago

10K views

1:00

Create Attendance register using Google Sheets

Ajay Anand

Shared 55 years ago

17K views

1:00

Excel formula for multiple match results #excelshorts

Ajay Anand

Shared 55 years ago

41K views

1:00

VLOOKUP into another worksheet #excelshorts

Ajay Anand

Shared 55 years ago

42K views

1:00

XLOOKUP into another worksheet

Ajay Anand

Shared 55 years ago

26K views

1:00

Convert Numbers into English Words using Microsoft Word

Ajay Anand

Shared 55 years ago

201K views

1:00

Get rid of Scientific Notation and display Numbers in proper format in Excel

Ajay Anand

Shared 55 years ago

553K views

1:00

Excel Custom Formatting Technique to display Variance with Symbols 🔺🔻

Ajay Anand

Shared 55 years ago

29K views

1:00

Custom Formatting Trick in Excel

Ajay Anand

Shared 55 years ago

21K views

1:00

Formula to find the Count of cells containing either A or B

Ajay Anand

Shared 55 years ago

37K views

1:00

Excel formula to find the Count of Text that Ends with a specific character

Ajay Anand

Shared 55 years ago

25K views

1:00

Excel formula to get the Count of Words that start with a specific letter

Ajay Anand

Shared 55 years ago

17K views

1:00

Excel Formula to find the Count of 3 letter Words

Ajay Anand

Shared 55 years ago

31K views

1:00

XLOOKUP Function in Google Sheets

Ajay Anand

Shared 55 years ago

143K views

1:00

Custom Formatting Trick in Excel

Ajay Anand

Shared 55 years ago

43K views

1:00

Create your own Digital Clock in Windows

Ajay Anand

Shared 55 years ago

23K views

1:00

Excel Shortcut to Insert a New Row between every record #ExcelShorts

Ajay Anand

Shared 55 years ago

144K views

1:00

Excel trick to insert SubTotals #excelshorts

Ajay Anand

Shared 55 years ago

295K views

1:00

Quick Analysis Tool in Excel to calculate Running Total #excelshorts

Ajay Anand

Shared 55 years ago

51K views

1:00

Fill Blanks in Excel #excelshorts

Ajay Anand

Shared 55 years ago

305K views

1:00

Excel Formula to Calculate Percentage change #excelshorts

Ajay Anand

Shared 55 years ago

126K views

1:00

Increase by n percentage in Excel #excelshorts

Ajay Anand

Shared 55 years ago

164K views

1:00

Hide Zeros in Excel #shorts

Ajay Anand

Shared 55 years ago

86K views

1:00

Keyboard Shortcut to Shift Rows and Columns in Excel

Ajay Anand

Shared 55 years ago

55K views

1:00

3 different methods to Combine data in Excel

Ajay Anand

Shared 55 years ago

42K views

1:00

Round down Time to the nearest 30 minutes

Ajay Anand

Shared 55 years ago

23K views

1:00

Custom Formatting trick to Hide Numbers in Excel

Ajay Anand

Shared 55 years ago

75K views

1:00

Excel Formula to Round Time to the nearest 15 minutes

Ajay Anand

Shared 55 years ago

18K views

1:00

Excel formula to Count Dates that fall in the given Year

Ajay Anand

Shared 55 years ago

71K views

1:00

Custom Number formatting Trick in Excel

Ajay Anand

Shared 55 years ago

53K views

1:00

Count of Sundays between two Dates

Ajay Anand

Shared 55 years ago

32K views

1:00

Excel Trick to Hide Text

Ajay Anand

Shared 55 years ago

47K views