Aswin SivakumarChanging Text into Date MM/DD/YY into DD-MM-YYYY 📅In Today’s article, we are going to discuss why sometimes Excel file shows the set of dates either in the wrong format such as “MM-DD-YYYY”…Feb 17, 2023Feb 17, 2023
Aswin SivakumarYear & Month Calculation by Text Manipulation 📅 & 🔠In Today’s article, we are going to discuss how can add the two cells containing Year & Month details in “05Y08M” (Text Format), this is…Feb 15, 2023Feb 15, 2023
Aswin SivakumarHorizontal & Vertical Look-up 📄In our day-to-day Excel works, we may come across situations where we require the value which is an intersection of both Horizontal &…Feb 13, 2023Feb 13, 2023
Aswin SivakumarCONCAT Date and other Text or numbers 📅 & 📝If you have tried to join the Date and other elements such as Text or Numerical Values from different cells into one single cell using…Feb 10, 2023Feb 10, 2023
Aswin SivakumarFilling up Blank cells in between the data 📜We may come across data tables with blank cells in some of the columns (Blank rows with heading on the top of each set). Below Image for…Feb 9, 20231Feb 9, 20231
Aswin SivakumarFull Potential of Paste Special Feature 📋In Today’s article, we are going deep dive into various options available in the Paste Special feature in Microsoft Excel. Paste Special is…Feb 8, 2023Feb 8, 2023
Aswin SivakumarError in VLOOKUP while looking up Values ⚠Sometimes while using the VLOOKUP function for looking up (lookup_value) Numbers, we may end up getting an #N/A error. The Reason may be…Feb 6, 2023Feb 6, 2023
Aswin SivakumarFull Potential of SUMIF & SUMIFSThe Most underrated functions of Microsoft Excel were SUMIF & SUMIFS, yes you read it right there are basically two SUMIF functions one…Feb 4, 2023Feb 4, 2023
Aswin SivakumarAutoCorrect Feature, Real-Time Saver ⌛If you take close look at your regular task in a day, you may notice the high-frequency usage of some words such as names of your…Jan 30, 2023Jan 30, 2023
