Email Address*
Phone Number:
Please enter the following text in the box below:
ADDRESS: 901 Dulaney Valley Road, Suite 800
Towson, MD 21204
PHONE: 888-481-3500
Excel 2013/2016 PowerPivot and PowerView Business Intelligence Tools for Advanced Data AnalysisCOURSE ID: EXCELPP

The free PowerPivot add-in for Excel takes PivotTable analysis to a new level. PowerPivot is more than a simple replacement for the Excel PivotTable. It is a business intelligence tool that will provide you with additional features to build complex relationships between sets of data. With PowerPivot you can: analyze data beyond the limits of the Excel PivotTable; organize tables in a relational way; define complex calculation expressions; integrate different data sources into your analysis; provide enhanced interactive graphs; and discover analysis solutions that the Excel PivotTable is not able to provide. PowerView, PowerQuery, and the 2016 Power BI Desktop application to create dashboards will also be covered. Attendees will receive practical information and tips. This course applies to Excel 2013 and 2016.

DESIGNED FOR: CPAs, accountants, finance professionals at all levels of an organization to learn how to analyze data with Excel PowerPivotFIELD OF STUDY: Computer ScienceLEVEL: AdvancedPREREQUISITES: Working knowledge of Microsoft Excel at an intermediate/advanced levelCOURSE PRODUCER: Business Learning InstituteCREDITS: 8.0OBJECTIVES:
  • Become familiar with the Excel PowerPivot application and import data
  • Manipulate sets of data in a variety of PowerPivot reports
  • Use DAX functions in PowerPivot
  • Create graphic representations of PowerPivot reports
  • Distribute PowerPivot Data
  • Use PowerView, Power Query, and the new Power BI Desktop application for building dashboards

* Install and Explore the PowerPivot Application * Import Data from Various Data Sources * Refresh Data from a Data Source * Create Linked Tables * Organize and Format Tables * Create Calculated Columns * Sort and Filter PowerPivot Data * Create and Manage Table Relationships * Create PowerPivot PivotTables * Create PivotCharts * Filter Data Using Slicers * Present PivotTable Data Visually * Manipulate PowerPivot Data Using DAX Functions * Extract Data from Tables Using Functions * Work with Time Dependent Data * Protect Reports * Save Reports in Different File Formats * Work with PowerView data mapping * Work with PowerQuery to access database data * Use the new Power BI desktop app to create a variety of dashboards linked to data

Download the 2016 Business Learning Institute Course Catalog DOWNLOAD PDF
Business Learning Institute - Course Catalog