Excel template for an I.T audit needed

[ExcelKid23]

Hey guys so with my current job I've been asked by my boss to do an audit of all the PC's in our office.


About 300 or so.


Mainly just need to list all the basic details like the make and model, location, operating system, hardware specs and software installed.
He want's it in an excel spreadsheet but I've got zero experience with Excel and how to do formulas and programming and make it look all fancy and easy to look up various information and put it all together with drop down menus etc...


Would anyone happen to have any examples I could use or already made templates?


It would be a huge help since I think my job is on the line.

 

[oldbrewer]

first of all make your headings

maybe id (1,2,3 etc) make, model, location, etc etc

put in 10 rows of pretend data

think about how to analyse

will put something on here in 10 minutes

 

[oldbrewer]

[TABLE="width: 928"]
<colgroup><col span="4"><col><col span="5"><col><col><col span="2"></colgroup><tbody>[TR]
[TD]id[/TD]
[TD]make[/TD]
[TD]model[/TD]
[TD]location[/TD]
[TD]purchased[/TD]
[TD]hard-disk[/TD]
[TD]ram[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]samsung[/TD]
[TD]slow[/TD]
[TD]office1[/TD]
[TD="align: right"]01/01/2013[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]location[/TD]
[TD]office2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]sony[/TD]
[TD]fast[/TD]
[TD]office3[/TD]
[TD="align: right"]01/04/2013[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]acme[/TD]
[TD]medium[/TD]
[TD]office2[/TD]
[TD="align: right"]01/07/2013[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Count of make[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]samsung[/TD]
[TD]fast[/TD]
[TD]office1[/TD]
[TD="align: right"]01/10/2013[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]make[/TD]
[TD]Total[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]sony[/TD]
[TD]medium[/TD]
[TD]office3[/TD]
[TD="align: right"]01/01/2014[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]acme[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]acme[/TD]
[TD]fast[/TD]
[TD]office2[/TD]
[TD="align: right"]01/04/2014[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]sony[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]samsung[/TD]
[TD]medium[/TD]
[TD]office1[/TD]
[TD="align: right"]01/07/2014[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Grand Total[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD]sony[/TD]
[TD]fast[/TD]
[TD]office3[/TD]
[TD="align: right"]01/10/2014[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD]acme[/TD]
[TD]medium[/TD]
[TD]office2[/TD]
[TD="align: right"]01/01/2015[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD]sony[/TD]
[TD]slow[/TD]
[TD]office2[/TD]
[TD="align: right"]01/04/2015[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 5"]a series of pivot tables will allow you to analyse[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 6"]in the one I made, you can select which office by a drop down[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]