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]

id

make

model

location

purchased

hard-disk

ram

1

samsung

slow

office1

01/01/2013

20

2

location

office2

2

sony

fast

office3

01/04/2013

30

2

3

acme

medium

office2

01/07/2013

40

2

Count of make

4

samsung

fast

office1

01/10/2013

30

5

make

Total

5

sony

medium

office3

01/01/2014

40

5

acme

3

6

acme

fast

office2

01/04/2014

30

5

sony

1

7

samsung

medium

office1

01/07/2014

40

5

Grand Total

4

8

sony

fast

office3

01/10/2014

50

10

9

acme

medium

office2

01/01/2015

50

10

10

sony

slow

office2

01/04/2015

75

10

a series of pivot tables will allow you to analyse

in the one I made, you can select which office by a drop down

<colgroup><col span="4"><col><col span="5"><col><col><col span="2"></colgroup><tbody>
</tbody>