18 and older
Upon successful completion of this course, you will be able to use Excel advanced PivotTable functionality to analyze your raw data. You will learn to: Prepare data for PivotTable reporting and create PivotTables from various data sources; Analyze Data Using PivotTables; Work with PivotCharts.
This course is taught with the Office 2013 version software. You will be able to attend with either 2013 or 2016 version software due to minor variations between the two. All students will receive Office 2013 course materials.
Please note that this course in not appropriate for those students using Mac computers running the Mac version of Microsoft Office. This course is only appropriate for those using PCs running the Windows version of Microsoft Office.
Lesson 1: Preparing Data and Creating PivotTables
Topic A: Prepare Data
Topic B: Create a PivotTable from a Local Data Source
Topic C: Create a PivotTable from Multiple Local Data Sources
Topic D: Create a PivotTable from an External Data Source
Lesson 2: Analyzing Data Using PivotTables
Topic A: Summarize PivotTable Data
Topic B: Organize PivotTable Data
Topic C: Filter PivotTable Data Topic D: Format a PivotTable
Topic E: Refresh and Change PivotTable Data
Lesson 3: Working with PivotCharts
Topic A: Create a PivotChart
Topic B: Manipulate PivotChart Data
Topic C: Format a PivotChart
Prerequisite: Excel 2013/2010 - Basic
Courseware (if a course has a Courseware) will be shipped to the address provided two weeks before the class starts. Make sure that the additional info field is properly and correctly filled out to avoid Courseware being lost in transit. Please also note that P.O. Box addresses are not allowed.
The classes are instructor-led live training you attend in a local classroom or from your home/office. Our instructors teach from a remote location while being able to interact with students as in a traditional classroom setting.
Instructors can view student progress and take control of their PC to provide direct assistance. Students can see the instructor's presentation as well as voice questions directly to the instructor and participate in class discussions.