Excel 2013 Self-Service Analytics with No Code for the End User (MCC-55084)

Microsoft Excel Training Overview

This Microsoft course, Excel 2013 Self-Service Analytics with No Code for the End User, teaches end users and analysts how to use the new self-service business intelligence tools in Excel and SharePoint Server 2013.

Location and Pricing

Most Accelebrate courses are delivered as private, customized, on-site training at our clients' locations worldwide for groups of 3 or more attendees and are custom tailored to their specific needs. Please visit our client list to see organizations for whom we have delivered private in-house training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote for private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. See a schedule of online courses.

Microsoft Excel Training Objectives

All students will:

• Explore SharePoint 2013 interface.
• Understand pivot tables (optional).
• Explore the PowerPivot user interface.
• Import data.
• Import large datasets.
• Import data with a query.
• Create relationships.
• Create a cascading relationship.
• Create a relationship between tables from different sources.
• Hide columns, change data types, sort, and filter.
• Create and configure calculated columns and calculated fields.
• Add a calculated field from the pivot table.
• Filter context using one table.
• Understand row context and dynamic selection.
• Use FILTER function.
• Use CALCULATE function.
• Build a date table.
• Relate a table to an Excel calendar table.
• Create and configure Time Intelligence.
• Create and configure perspectives.
• Create and configure hierarchies.
• Create and configure KPIs.
• Create a report using Power View.
• Explore and connect to data sources using Power Query.
• Extract, transform, and load data using Power Query.
• Perform online searches.
• Managing data sources and queries.
• Create and configure a Power Map report.
• Create and configure a Tour.

Microsoft Excel Training Outline

Expand All | Collapse All | Printer-Friendly