Enable Technology

Excel 

Power Pivot




Course Overview


A one day course introducing candidates to Power View and Power Pivot Excel tools.

Duration: 1 day course



Course Content


Power View
Understanding Power View
Enabling Power View
Adding Power View to the Ribbon
Creating a Power View Sheet
Working With a Power View Object
Working With Power View Fields
Rearranging and Sorting Fields
Working With Measure Fields
Formatting Power View Data
Tiling Data in Power View
Filtering in Power View
Switching Visualisations
Adding More Power Views
Adding Titles and Images
Updating a Power View Report

Power Pivot
Understanding Power Pivot
Understanding Relational Data
Enabling Power Pivot
Connecting to a Data Source
Working With the Data Model
Working With Data Model Fields
Changing a Power Pivot View
Creating a Data Model PivotTable
Using Related Power Pivot Fields
Creating a Calculated Field
Creating a Concatenated Field
Formatting Data Model Fields
Using Calculated Fields
Creating a Timeline
Adding Slicers

Get & Transform
Understanding Get & Transform
Understanding the Navigator Pane
Creating a New Query From a File
Creating a New Query From the Web
Understanding the Query Editor
Displaying the Query Editor
Managing Data Columns
Reducing Data Rows
Adding a Data Column
Transforming Data
Editing Query Steps
Merging Queries
Working With Merged Queries
Saving and Sharing Queries
The Advanced Editor

Power Map
Understanding Power Map
Creating a Power Map Tour
Working With Location Fields
Working With Mapping Confidence
Working With Height and Category
Fields
Filtering Data
Navigating a Data Map
Changing the Look
Working With Layers
Working With Scenes
Working With Scene Options
Working With Time Settings
Viewing and Editing a Tour
Exporting a Tour as a Video






Email us about this courses         Telephone on 01952 305730






Training Locations: Enable Technology run courses in Wolverhampton, Telford, Shrewsbury, Birmingham, Cannock, Walsall, Dudley, Sandwell, Bridgnorth, Lichfield, Burton-upon-Trent, Stafford, Redditch, Bromsgrove, Solihull, Tamworth, Worcester, Shropshire, Staffordshire, Worcestershire and across the West Midlands.




West Midlands Scheduled Courses: Excel VBA; MS Project, SSRS; SQL; Crystal Reports; HTML;Adobe Illustrator; ASP.NET; Dreamweaver; Flash; Photoshop; InDesign; Google Scripting; Visio; PHP; Microsoft Access; JQuery JavaScript; Web Development; Office;

Birmingham Scheduled Courses: SQL; Excel VBA; MS Access;Photoshop; Adobe Illustrator; InDesign; Dreamweaver; MS Project;Visio; Flash; SSRS;PHP; JavaScript JQuery; HTML CSS; Microsoft Office;

Wolverhampton Scheduled Courses: Microsoft Access; Excel VBAMS Project; Visio; Adobe Illustrator; Photoshop; Dreamweaver; InDesign; Flash; HTML CSS; JavaScript; SQL; Microsoft Office; Adobe

Telford Scheduled Courses: SQL; Excel VBA; MS Project; Visio; PowerPoint; Photoshop; Adobe InDesign; Illustrator; Dreamweaver; Web Design; Office;

Cannock Scheduled Courses: Excel VBA; PHP; Microsoft Access; Visio; MS Project; PowerPoint; Dreamweaver; Photoshop; InDesign; Adobe Illustrator; Flash; JavaScript; HTML CSS;

Walsall Scheduled Courses: Excel; Access; MS Project; Visio; Photoshop; InDesign; Adobe Illustrator; Dreamweaver; Flash; SQL; JavaScript; HTML CSS;

Dudley Scheduled Courses: Excel; MS Access; SQL; MS Project;Visio; Adobe Illustrator; InDesign; Photoshop; Dreamweaver; Flash; JavaScript; HTML CSS;

Sandwell Scheduled Courses: Access;Excel; Microsoft Project; Visio; PowerPoint; Adobe Illustrator; Photoshop; Adobe InDesign; Dreamweaver; Flash; JavaScript; HTML CSS; SQL;

Shropshire Scheduled Courses: Illustrator; InDesign; Adobe; Dreamweaver; Flash; Photoshop; Excel; Project; Visio; PowerPoint; Office; JavaScript; HTML; Access;

Staffordshire Scheduled Courses: Illustrator; InDesign; Photoshop; Dreamweaver; Flash; Adobe; Excel;