Browse » Home
Sunday, August 14, 2011
How to Make Excel Reports
1. Open the Excel program to display a new worksheet.
2. Click the “File” tab on the command ribbon to display a list of commands.
3. Click “New,” then a gallery of “Office.com Templates” appears.
4. Click the “Reports” link, then a list of folder icons appears.
5. Click the preferred folder such as “Financial Records,” “Logs” or “Human Resource Records.” A gallery of thumbnail images appears.
6. Click the preferred report image to display a larger image in the preview pane to the right.
7. Click “Download” in the right pane. The template copies to the new worksheet.
8. Click in a cell and type your data. Use the Excel editor commands to customize the look of this report. For example, select a 'Font' and 'Fill Color' command on the 'Home' tab.
9. Save this Excel Workbook. On the “Save As” dialog box, click a file location in the left pane. For example, “Desktop” or a named folder. Type a file name in the “File name” text box. Click “Save.”