Add Excel Tables to a Data Model in Power Pivot

No reviews yet.

Excel tables either within the same workbook or in external workbooks can easily be added to a data model. Internal and external tables are, however, added using different processes.

Tables must be properly designed and contain relatable fields to work together in a data model.
Once tables are imported, relationships must be set between tables in the data model which can then be used for calculations, PivotTables and other data analysis.

Highlights

Prepare tables for use in a Data Model
Import tables into a Data Model

Duration: 4mins 12secs

$6.99 AUD

from

$9.99

Add to Cart

Includes:

Quality On-demand Video Demonstrations
Step-by-step Learner Guide
Demonstration and practice exercises to boost retention
Lifetime access
Course progress indicator

Add Excel Tables to a Data Model in Power Pivot

Highlights

Related Courses

Create Basic Formulas and Functions

Concatenation – combine data from multiple cells

HLOOKUP Exact Match Lookup Table with Named Range

Understand the Data Model in Power Pivot

Connect to a Data Source in Power Pivot

Link Between Worksheets

$6.99 AUD

$9.99

Includes: