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