Loading...
Excel - Data Analysis with PivotTables
Get actionable insight from your data with Excel’s popular power tool schedule2h
5(1)
116 Courses
• 3781 Reviews
Combining TV-style video production with modern graphics and animation, Bigger Brains courses are popular with both learners and training professionals around the world. Our top teachers and subject...
Kathy Jones
•
Certified Trainer
Kathy is a Microsoft Certified education/training professional with experience in all aspects of training. Her strengths include classroom presentations, organizational skills, problem-solving, progra...
About this course
Get more from Excel using the power of PivotTables.
PivotTables are the perfect tool to analyze large amounts of data in Excel. The ability to summarize, visualize, and tabulate your data makes PivotTables an important option for Excel users who need to store and report on data. You will learn how to create, format, and manipulate PivotTables and PivotCharts so you can easily get the actionable results you need from your data.
You’ll also learn how to connect to external data and create PivotTables from multiple tables. Custom fields, formatting, and advanced filtering options are also important features covered in this course. Taught by Microsoft Certified Trainer Kathy Jones, Excel: Data Analysis with PivotTables will help intermediate and advanced users work more effectively with Excel PivotTables and PivotCharts.
Topics covered include:
- Preparing data and creating PivotTables.
- Working with local and external data sources.
- Creating relationships between tables.
- Summarizing, organizing, filtering, and formatting PivotTables.
- Refreshing and changing PivotTable data.
- Creating PivotCharts.
Enjoy award-winning HD content in the “Uniquely Engaging”™ Bigger Brains Teacher-Learner style!
This course includes:
schedule2 hours on-demand video