The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...

Not anymore: Excel 2013’s table tools include features that make it easy to link charts and cells, perform searches, and create dynamically updated reports, just like—yes—a relational database.

This article explains how to create a report in Microsoft Excel using key skills like creating basic charts and tables, creating pivot tables, and printing the report.The information in this ...

How to Create a Report to Display Quarterly Sales in Excel 2007. Excel is the spreadsheet program of the Microsoft Office suite. Using Excel, you can store and track all the information that's ...

Excel can feel like a maze of endless rows, columns, and formulas, especially when you’re trying to create something as detailed as a loan repayment report.

How to Create a Report in Excel Automatically. The first step in leveraging the power of Excel Power Query is to convert your raw data into Excel tables.

We'll show you how to create an Excel checklist with checkboxes you can tick off as you complete the items. It will indicate ...

How often do you have to create reports in Excel? Which one are you most proud of? Let us know in the comments. And be sure to visit our Office 101 help hub for more related articles!

So, you want to know how to create a scatter plot in Excel. Chances are, you probably already know what the term means, but given Microsoft Excel’s arsenal of options packed into each tab, ...

You can draw a flowchart for processes in Microsoft Excel without using an external add-on. There are mainly two methods to do so. You can use one or a combination of both methods to create a ...

Here’s how to make a Gantt chart in Excel to accommodate complex agile project management within the familiar tool. A Microsoft Excel spreadsheet is one of the most versatile business tools around.