Get Access to World’s largest Template Library & Tools

How to Create a Report in Excel

Reports are supposed to make information sharing more efficient and convenient. They are useful in most scenarios, especially in business and finance. Budgeting involves coming up with income and expense reports. Project management requires furnishing a series of reports and other documents. Creating a report can sometimes be a daunting task. But thankfully, programs like Microsoft Excel come with ready-made templates to help make the task a little easier. The tutorial below offers a quick guide on how to create your own report for both your personal and business needs.

SUMMARY:

  • For Windows: Click the New document icon. Browse the available templates by typing Report in the search bar. Choose a template and click Create.
  • For Mac: Go to New, and type Report in the search bar. Pick a template and select Create.

How to Make a Report Using Templates in Microsoft Excel

There are all kinds of reports, with sales reports and expense reports as some of the most common. This simple tutorial will guide you in creating a report for all your business needs. Save more time and energy by taking advantage of the ready-to-use templates on Microsoft Excel.

1. Open the Microsoft Excel, then select New. In the search bar, type in ‘report’ to display all the available templates.

ascreenshot 2021 09 0

2. Choose a report template and click Create.

bscreenshot 2021 09 0

3. Keep or change the title of the report. The sample below is a detailed travel expense report. To edit, start by indicating your complete name, department, period date, and other key details. Click the cell to change the text inside.

revisedscreenshot 2021 09 02 172100

4. In the table, customize the date and description for each expense. Specific costs such as meals, lodging and transportation are indicated in the column header. You may opt to add or remove columns, whatever your preference is. Input all the respective expenses, and the table will automatically calculate the total for each row and column.

5. Save your Excel file once you’re done editing. You can choose to print out or share your report to others.

Note: If you are looking for a wider variety of templates, feel free to browse Template.net for dozens of free Excel schedule templates and designs.

How to Create a Report for Mac Using Microsoft Excel

Mac users can also customize their own report with the use of an Excel template. Just follow the basic steps below to get started!

1. On the menu bar located on the left, select New. Type in ‘report’, then pick a template and select Create.

screen shot 2021 09 03 at

2. Edit the title and input other key data, as needed. You can customize the text font, size, and color as well. The sample template below is a weekly sales report.

screen shot 2021 09 03 at

3. Edit the table by inputting all the corresponding values. You can also change the column titles as you see fit. Then indicate all sales amount for each day of the week. The total value is automatically adjusted whenever you change the numbers.

4. Save your Excel file after editing. You can either print out the report or share it with your contacts.

Simple Home School Report Card Template

simple home school report card templateDownload Now

Sample Report Gantt Chart Template

sample report gantt chart templateDownload Now

Sales Activity Report Layout

sales activity report sample templateDownload Now

Simple Report Gantt Chart Template

simple report gantt chart templateDownload Now

Modern Project Report Template

project report templateDownload Now

Modern School Report Card Template

school report card templateDownload Now

Progress Report Gantt Chart Template

progress report gantt chart templateDownload Now

Daily Cash Report Template

daily cash report templateDownload Now

Team Status Report Dashboard Template

team status report dashboard templateDownload Now

Annual Expense Report Template

annual expense report templateDownload Now

Research Report Gantt Chart Template

research report gantt chart templateDownload Now

Monthly Sales Activity Report Template

monthly sales activity report templateDownload Now

Editable Yearly Report Card Template

yearly report card templateDownload Now

Sales Report Area Chart Design

sales report area chartDownload Now

More in Blog

How to Make/Create a Schedule in Microsoft Word [Templates + Examples] 2023How To Create/Build a Checklist in Google Docs
How to Make a Snapchat Geofilter on PhotoshopHow to Make/Create a Family Tree in Google Docs [Templates + Examples] 2023
How to Make a Checklist in ExcelHow to Make a Family Tree in Excel
How to Create a Report in ExcelHow to Make a Planner in Excel
How to Make/Create an Itinerary in Google Docs [Templates + Examples] 2023How to Make/Create a Cookbook in Microsoft Word [Templates + Examples] 2023
How to Make/Create a Postcard in Illustrator [Templates + Examples] 2023How to Make an Invoice in Excel
How to Make/Create an Invoice in Microsoft Word [Templates + Examples] 2023How to Make a Cookbook Using Google Docs
How To Create/Build a Budget in Google SheetsHow To Make/Create a Billboard in Adobe Photoshop [Templates + Examples] 2023
How to Make a Postcard in InDesignHow to Make/Create a Letterhead in Google Docs [Templates + Examples] 2024
How to Make/Create a Postcard in Google Docs [Templates + Examples] 2023How To Make/Create an Invitation in Microsoft Word [Templates + Examples] 2023
How To Make/Create a Postcard in Adobe Photoshop [Templates + Examples] 2023How to Make/Create a Postcard in Microsoft Word [Templates + Examples] 2023
How to Make/Create a Rack Card in Microsoft Word [Templates + Examples] 2023How to Make/Create a Certificate in Microsoft Word [Templates + Examples] 2023
How to Make/Create a Certificate in Google Docs [Templates + Examples] 2023How to Make/Create a Voucher in Microsoft Word [Templates + Examples] 2023
How to Make/Create a Ticket in Microsoft Word [Templates + Examples] 2023How to Make/Create a Leaflet in Microsoft Word [Templates + Examples] 2023
How to Create a Shared Calendar in OutlookHow to Create a Flowchart in Excel
How to Make/Create a Flowchart in Microsoft Word [Templates + Examples] 2023How to Make Address Labels in Word
How To Make/Create an Email Signature in Microsoft Outlook [Templates + Examples] 2023How to Make a Bar Graph in Excel
How To Make/Create a Fillable Form in Adobe PDF [Templates + Examples] 2023How To Make/Create a Pie Chart in Microsoft Excel [Templates + Examples] 2023
How To Make/Create a Bar Chart in Microsoft Excel [Templates + Examples] 2023How to Make/Create a Resume in Microsoft Word [Templates + Examples] 2023
How to Make a Timeline in WordHow To Make/Create a Survey in Google Forms [Templates + Examples] 2023
How to Make a Fillable Form in WordHow To Make/Create a Timeline in Microsoft Excel [Templates + Examples] 2023
How To Make/Create a Schedule in Microsoft Excel [Templates + Examples] 2023How to Make a Poster in PowerPoint
How To Create/Build a Resume in Google DocsHow To Make/Create a Timeline in Microsoft PowerPoint [Templates + Examples] 2023
How to Make/Create a Calendar in Microsoft Word [Templates + Examples] 2023How To Make/Create a Calendar in Microsoft Excel [Templates + Examples] 2023
How to Make/Create a Survey in Google Docs [Templates + Examples] 2023How to Make/Create a Form in Microsoft Word [Templates + Examples] 2023
How to Create a Form in ExcelHow to Make a Gantt Chart in Excel
How To Make/Create a List in Microsoft Excel [Templates + Examples] 2023How to Make a Chart in Excel
How to Make/Create a Budget in Microsoft Excel [Templates + Examples] 2023How to Make/Create Checklist in Microsoft Word [Templates + Examples] 2023
How To Make/Create a Logo in Adobe Photoshop [Templates + Examples] 2023How To Create/Build a Chart in Google Docs
How to Make/Create a Label in Microsoft Word [Templates + Examples] 2023How to Make/Create a Chart in Microsoft Word [Templates + Examples] 2023
How to Make/Create a Pamphlet in Google Docs [Templates + Examples] 2023How to Print Labels From Excel
How to Make/Create a Letterhead in Microsoft Word [Templates + Examples] 2023How to Make/Create a Brochure in Microsoft Word [Templates + Examples] 2023
How to Make/Create a Pamphlet in Microsoft Word [Templates + Examples] 2023How to Make/Create a Business Card in Microsoft Word [Templates + Examples] 2023
How to Make a Flyer in Microsoft Word50+ Roadmap Samples, Format & Examples 2023
50+ Mind Map Samples, Format & Examples 202350+ Family Tree Samples, Format & Examples 2023
50+ Email Signature Ideas & Examples 202350+ Media Kit Samples, Format & Examples 2023
50+ Receipt Samples, Format & Examples 202350+ Planner Samples, Format & Examples 2023
50+ Schedule Samples, Format & Examples 202350+ Quotation Samples, Format & Examples 2023
50+ Resume Samples, Format & Examples 202350+ Inventory Samples, Format & Examples 2023
50+ Itinerary Samples, Format & Examples 202350+ Email Signature Designs, Format & Examples 2023
50+ Analysis Samples, Format & Examples 202350+ Statement Samples, Format & Examples 2023
50+ Estimate Samples, Format & Examples 202350+ Memo Samples, Format & Examples 2023
50+ Policy Samples, Format & Examples 202350+ Invoice Samples, Format & Examples 2023
50+ Meeting Minutes Sample, Format & Examples 202350+ Notice Samples, Format & Examples 2023
50+ Budget Samples, Format & Examples 202350+ Checklist Samples, Format & Examples 2023
50+ Agreement Samples, Format & Examples 202350+ Catalog Ideas & Examples 2023
50+ Plan Samples, Format & Examples 202350+ Lesson Plan Samples, Format & Examples 2023
50+ Report Samples, Format & Examples 202350+ Magazine Ideas & Examples 2023
50+ Tumblr Banner Designs, Format & Examples 202350+ Pinterest Pin Designs, Format & Examples 2023
50+ Whatsapp Post Designs, Format & Examples50+ Twitter Post Designs, Format & Examples
bottom banner