Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.

Small databases of a few rows, to a few thousand rows, can often be created more quickly and easily in Microsoft Excel, than by using a dedicated database system. Excel is available as a stand-alone ...

Create a report using charts: Select Insert > Recommended Charts, then choose the one you want to add to the report sheet. Create a report with pivot tables: Select Insert > PivotTable. Select the ...

Quit the data-search struggle by organizing your raw data into a Microsoft Excel spreadsheet. Rather than manually scrolling through a list of disorganized records, use Excel's built-in tools to find ...

If you have a number of Microsoft Excel worksheets that contain related data, you'll likely need to create a report that consolidates and summarizes the data. If those worksheets are laid out ...