
It allows you to easily manage tabular data with the help of its layout which is divided into rows and columns. It comes as a part of Microsoft Office Suite and can be purchased for unlimited use. You can choose available templates or choose blank document in order to create custom spreadsheets. These spreadsheets can be related to business data analysis, stock reports, calendars, products inventory, timetables, performance tracking, project planning and much more. You can use its Free online version via internet or download the paid version for using advanced features offline. The conclusion of the whole Job Training process is this application will be useful for UPT TIK UPGRIS in monitoring the availability of warehouse goods.Microsoft Excel is the software offered by Microsoft Corporation and enables you to easily manage spreadsheet files. At the end of the Job Training, the software has been successfully created which is equipped with documentation of the finished software results.

The final stage is testing which focuses on the software both logically and functionally and ensures that all parts have been tested. The third stage is coding using Visual Basic for Application from Excel. The second stage is designing the application interface design. The first stage is analysis of the system to be made.

During software development, the methodology used is waterfall.

The features in the system include a form for inputting available items, an added item form and an outgoing goods form, then a report feature to search for item data using the search feature. The software is a system for managing warehouse inventory at UP TIK. Practice Fieldwork that is done is making software.

Field work practice is carried out at the UPGRIS Information and Communication Technology Development Technical Implementation Unit (UPT PTIK), which provides services and facilities for the academic community, including the function of processing the computerized system of the PGRI University in Semarang, from Septemto October 15 2020.
