Ravi Sir's Cards › Excel
IT Asset Management System in Excel
Revision card 1 for IT Asset Management System in Excel: Asset tag: ="IT-"&TEXT(ROW()-4,"000") gives IT-001; Warranty end date: =EDATE(D5,12*I5) gives 10-04-2027; Age in years: =ROUND((Setup!$B$3-D5)/365,2) gives 2.52. Includes an example data table.
Read card text
What this card says
1 for IT Asset Management System in Excel: Asset tag: ="IT-"&TEXT(ROW()-4,"000") gives IT-001
Warranty end date: =EDATE(D5,12*I5) gives 10-04-2027
Age in years: =ROUND((Setup!$B$3-D5)/365,2) gives 2.52. Includes an
Example
data table
Learn this in the lesson: IT Asset Management System in Excel: Asset Register, Assigned To, Warranty Alerts, Book Value, Repairs and Report