Excel Lesson 8: Advanced Data Analysis
In this lesson, you will learn advanced data analysis skills with Excel. You will learn how to summarize large data sets using PivotTables. You will also learn how to arrange, filter, and format PivotTables and how to produce a PivotChart. In addition, you will learn how to perform what-if analysis on your data with the Goal Seek and Scenario commands.
What you’ll learn in this lesson:
- • Creating a PivotTable
- • Rearranging a PivotTable
- • Updating data
- • Creating a PivotChart
- • Performing What-If Analysis
Starting up
You will work with files from the Excel08lessons folder. Make sure you have loaded the OfficeLessons folder onto your hard drive from www.digitalclassroombooks.com/Office2013. If you need further instructions, see “Loading lesson files” in the Starting up section of this book.
Introduction to PivotTables
As discussed in Lesson 6, “Working with Data,” Excel offers an excellent set of tools to track and manage lists of information. The real dilemma occurs when you need to quickly summarize the data or produce informative reports. A PivotTable allows you to do just that.
A PivotTable is an interactive table that summarizes data in an existing worksheet list or table. You can quickly rearrange the table by dragging and dropping fields to create a new report without changing the structure of your worksheet.
When you create a PivotTable ...
Get Office 2013 Digital Classroom now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
