PivotTables work best if you have well-structured data that is organized in continuous rows and columns. In reality, they are quite easy to create, as long as you understand a few basics, which we cover below. PivotTables seem complex and mysterious to many spreadsheet users. You can go even further and examine sales revenue for each product category and store combination. For example, the district manager of a retail store chain may want to examine sales revenue by store or product category. In addition, you can quickly and easily examine the data by various dimensions. PivotTables allow you to quickly summarize large quantities of data. PivotTables The PivotTable is among the most useful tools available in modern spreadsheet software. These techniques can help you analyze information so that you can make better decisions. This in-depth guide will help you understand how to use some more advanced techniques, including PivotTables, Scenario Manager and Goal Seek analysis. 1 In-Depth Guide Advanced Spreadsheet Techniques Learning Objectives By reading and completing the activities in this chapter, you will be able to: Create PivotTables using Microsoft Excel Create scenarios using Microsoft Excel s Scenario Manager Perform Goal Seek analysis using Microsoft Excel Introduction A previous in-depth guide helped you learn the basics of using Microsoft Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |