Microsoft Excel is one of the most well-known, and one of the most widely used, spreadsheet programs in the business world. This program can be used to create everything from simple household inventory lists to detailed personal and company budgets. Excel can also be used to create a user-friendly yet detailed audit report.
- Skill level:
Other People Are Reading
Things you need
- Microsoft Excel
- Audit paperwork
- Spreadsheet template
Gather all of your audit paperwork together and review it carefully. This information will be used to build the finished audit report.
Log on to your computer and open Microsoft Excel. Click on the "File" menu and choose "New" from the menu to open a new spreadsheet.
Download an audit report template from Microsoft.com or a third-party vendor. Microsoft uses a wide variety of templates to make building complex spreadsheets easier.
Double-click on the title from the audit spreadsheet template and replace the sample text with the name of your company. Add lines for the company address if you like.
Check the field names on the audit template and add any additional fields you need. To add a column to the spreadsheet template click on the "Insert" menu and choose "Column" from the list.
Enter the data from the audit paperwork and save the spreadsheet. Proofread the numbers in the spreadsheet and make any necessary corrections.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for