SharePoint farms are common in large and small businesses, and the ability to set up simple lists, document libraries, schedules and team sites make it a handy multipurpose tool. SharePoint lists support the business objectives and are also employed to track the resources used to support the business itself. All businesses use computers to perform their work, and these assets are often tracked for depreciation, warranty repairs, and replacement. How many pieces of equipment are out of warranty? What networking equipment is due for replacement? When was the inventory list last updated?
The built-in SharePoint views can be used to answer a few of these questions, but you can also use Excel with its database view and pivot-table feature to simplify the analysis of your current data.