Interactive

Getting Started With Power Pivot in Excel 2016: Manage Data Relationships

Biz Library

Updated Feb 05, 2019

Microsoft Office Excel 2016: Part 4 (Data Analysis with PivotTables) - For reporting to be accurate and function well, you must prepare the data for analysis by setting up relationships among tables and creating hierarchies. (the Excel 2016 Data Model, Data Sources, the Table Import Wizard, Diagram View, Relationships, Hierarchies)

Related learning

Preparing Data and Creating Pivot Tables in Excel 2016: Create a PivotTable From Multiple Local Data SourcesInteractive ⋅ 7 mins

Preparing Data and Creating Pivot Tables in Excel 2016: Create a PivotTable From a Local Data SourceInteractive ⋅ 6 mins

Getting Started With Power Pivot in Excel 2016: Course OverviewInteractive ⋅ 2 mins

Forecasting Data in Excel 2016: Course Follow-UpInteractive ⋅ 2 mins

Explore more technology skills

IT Software

Web Design and Development

Data & Analytics

Design and Animation

Gaming and Games Development

Devops, Networking and Security

Programming and Web Development

Computer Science and Engineering

Biz Library

GLOBAL

BizLibrary is a world-leading eLearning training provider with a library of over 6500 resources available in Go1. The BizLibrary collection contains thousands of employee training videos on key topics your employees need, including business and soft skills, leadership, sales and customer service, HR compliance, IT software, workplace safety and more. With scientifically-proven employee training solutions that engage employees and drive results, BizLibrary online courses appeal to businesses of all sizes. All video content means courses are relatable and engaging, whilst covering essential topics for any organization and any learner. BizLibrary is a US-based provider of business skills, leadership and management training courses, which are all available in the Go1 Content Hub and relevant globally.