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 taught as private, customized training for 3 or more attendees at our clients' sites worldwide. In addition, we offer live, private online classes for teams who may be in multiple locations or wish to save on travel costs. Please visit our client list for organizations for whom we have delivered onsite training. To receive a customized proposal and price quote for private on-site or online training, 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