Skip to Main Content
Office 2013 Digital Classroom
book

Office 2013 Digital Classroom

by Walter Holland, AGI Creative Team
August 2013
Beginner content levelBeginner
672 pages
14h 31m
English
Wiley
Content preview from Office 2013 Digital Classroom

Excel Lesson 8: Advanced Data Analysis

ex08.psd

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office Word 2007 Step by Step

Microsoft® Office Word 2007 Step by Step

Joyce Cox and Joan Lambert
Microsoft® Office 2013 QuickSteps, 3rd Edition

Microsoft® Office 2013 QuickSteps, 3rd Edition

Carole Matthews, Marty Matthews, Bobbi Sandberg

Publisher Resources

ISBN: 9781118571613Purchase bookOther