NEW COURSE – PowerPivot Training Course with Excel 2010 & 2013 in Belfast, Omagh, Derry, Newry and Throughout Northern Ireland
July 19, 2013 by admin
No Comments »
PowerPivot is an add-in for Microsoft Excel 2010 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and PivotCharts, and then further analyze the data so that you can make timely business decisions without requiring IT assistance.
Our 1 Day course will enable delegates to maximise the benefit of this useful tool.
Prerequisites
This course is designed for Advanced users – a knowledge of Pivot tables and Advanced functions is required.
Course Content
-
Installation & Set up of Power Pivot
-
Creating your first Power Pivot report
-
Creating a data model & refining it
-
Using Tables & Structured References
-
Using Pivot Tables & Slicers
-
SQL Basics
-
Power Pivot formulas & DAX
-
Complex DAX examples
-
Working with time-intelligence
-
Power Pivot Dashboard
-
New features of Power Pivot in Excel 2013
Contact us on 028 9032 2228 or email info@mullantraining.com for dates and prices.
Posted in: What's New in Omagh