If you are looking for some special tricks to Generate Pdf Reports from Excel data, you’ve come to the right place. In Microsoft Excel, there are numerous ways to generate PDF reports from Excel data. This article will discuss four methods to generate PDF reports from Excel data. Let’s follow the complete guide to learn all of this.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
Steps to Generate Reports from Excel Data
Here, we will demonstrate how to generate a report from Excel data. Let us first introduce you to our Excel dataset so that you are able to understand what we are trying to accomplish with this article. We have a dataset showing sales in different months of ABC company.
At first, we want to make a report file “ Sales Summary of ABC Company” from the above dataset. Let’s walk through the steps to generate a report from Excel data.
Step 1: Creating Pivot Table
- Firstly, select the range data B4:D16.
- Next, select the Insert tab. Then select Pivot Table> From Table/Range.
- When the Pivot Table from table or range dialog box appears, choose New Worksheet. Then, click on OK.
- As a consequence, there will be a new worksheet. Your Pivot Table Fileds will appear on the right.
- After that, check Months, Items, and Total Sales.
- Then, place Months in Rows, Items in Columns, and Total Sales in Values section.
- As a result, the report will appear as shown below.
Step 2: Add Slicer
- Go to Pivot Table Analyze and select Insert Slicer.
- Then, select Items, and Months in the Insert Slicers Dialog box.
- Therefore, the report will appear as shown below.
Step 3: Add Chart for the Data
- To create a chart, select the range of data and go to the Insert tab. Next, select the 2-D Column chart.
- Therefore, you will get the following chart.
Step 4: Generating Final Report
- Then, go to the Insert tab and select Text. Next, select Header & Footer.
- Now, you need to write the Header as follows.
- Finally, the report will appear as shown below.
4 Ways to Generate PDF from Reports in Excel
In the following section, we will use four effective and tricky methods to generate PDF reports from Excel data. This section provides extensive details on four methods. You should learn and apply all of these to improve your thinking capability and Excel knowledge.
1. Using Save As Command
Now, we will use Save As PDF command to make the report file into a PDF file. To do this you have to follow the following process.
Steps:
- Firstly, go to the File tab and select Save As. Select your required folder to save the PDF by clicking “This PC”. Next, choose PDF under the Save as Type.
- As a result, the pdf will be created like the following.
- Finally, you will be able to generate PDF reports from Excel data like the following.
2. Applying Export As PDF Command
Here, we will use the Export As PDF option to make the report file into a PDF file. To do this you have to follow the following process.
Steps:
- Firstly, go to the File tab and select Export. Next, select Create PDF/XPS.
- Select your required folder to save the PDF like the following. Then, click on Publish.
- As a result, the pdf will be created like the following.
- Finally, you will be able to generate PDf reports from Excel data like the following.
3. Utilizing Print Option
Now, we will use the Microsoft Print to PDF option to make the report file into a PDF file. To do this you have to follow the following process.
Steps:
- Firstly, go to the File tab and select Print. Next, select Print >Mircosoft Print to PDF>Print.
- Select your required folder to save the PDF like the following. Then, press Enter.
- As a result, the pdf will be created like the following.
- Finally, you will be able to generate PDf reports from Excel data like the following.
4. Using Quick Access Toolbar
Now, we will use the Quick Access Toolbar command to make the report file into a PDF file. To do this you have to follow the following process.
Steps:
- Firstly, you need to click on the Toolbar, which is at the top of the window beside the Do section.
- Select your required folder to save the PDF like the following. Then, click on Publish.
- As a result, the pdf will be created like the following.
- Finally, you will be able to generate PDf reports from Excel data like the following.
Conclusion
That’s the end of today’s session. I strongly believe that from now you may generate PDF reports from Excel Data. If you have any queries or recommendations, please share them in the comments section below.
Don’t forget to check our website Exceldemy.com for various Excel-related problems and solutions. Keep learning new methods and keep growing!
The post How to Generate PDF Reports from Excel Data (4 Easy Methods) appeared first on ExcelDemy.
