Welcome to ONLC Training Centers
Attend Excel for Business Analytics Training Classes at ONLC

Excel Analytics & Power Classes



Microsoft Excel has new features that bring advanced business analytics, business intelligence and publishing capabilities to average users. These features were available in Excel 2013 through the “Power” add-ins Power Pivot, Power Query, Power View and Power Map. In Excel 2016, these features are built-in.

With the BI (business intelligence) and business analytics tool in Excel, data science is no longer solely in the hands of the technical elite. Business analytics and business intelligence is now democratized for every Excel users.

  • Get Data. Power Query lets you connect to public data or corporate data sources. Then it makes “data munging” and “data wrangling” easy by merging data from multiple sources and re-shaping and transforming data with repeatable steps.

  • Analyze. Power Pivot creates sophisticated data models with relationships, custom calculated fields, hierarchies, and KPIs that can analyze 100s of millions of rows of data with lightning-fast performance. After getting your data, use Power Pivot for Excel to put it all together in sophisticated data models.

  • Visualize. Power View lets you quickly create interactive reports, analytical views and dashboards.With Power Map for Excel you can perform geospatial explorations of your data by taking advantage of any data with location to plot across 3-D maps. Interact and story tell with this captivating map tool to see your data in new perspectives and unlock deeper insights.

  • Publish. Power BI publishes your reports making them available for your team. Colleagues can then access and interact with your reports in a browser, making it easier to consume data and unlock insights.

Attend hands-on, instructor-led training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from the convenience of your home/office PC via our Remote Classroom Instruction (RCI) technology.

Excel Analytics Classes

Click the title of the classes marked with the green flag () to see specific locations and dates of Ready to Run classes.  Click the title of the classes marked with the yellow flag () to see specific locations and dates of Early Notice classes.

Class Information
Click Title for Dates & Outlines Days Fee
Excel Analytics
Excel BI Tools: PowerPivot and Interactive Visualizations 3 $1495
Excel BI Tools: DAX Formulas for Dynamic Tables 2 $995
Excel BI Tools: Get and Transform Data 1 $495
Microsoft Official Analytics-Related Classes (Accept Software Assurance Vouchers)
20778: Analyzing Data with Power BI 3 $1595
MOC On-Demand: 20778-Analyzing Data with Power BI 3 $995    
20779: Analyzing Data with Excel 3 $1595
MOC On-Demand: 20779-Analyzing Data with Excel 3 $995    


Looking for other Excel classes?
ONLC offers Introduction through Programming with VBA classes in Excel. See more Excel classes at ONLC.


Looking for other Business Intelligence classes?
ONLC offers many Business Intelligence courses from a variety of vendors. See Business Intelligence classes at ONLC.


News & Offers


Call our Education Advisors for certification and course selection assistanceEducation Advisors to Help You
Our advisors can answer questions you may have about classes and vendor certification programs to help you select the training that is right for you. For assistance, contact our Education Advisors toll free in the USA at 1.800.288.8221 (8am-6pm Eastern).


ONLC Training Centers has locations coast to coast
Training Locations Coast to Coast
ONLC Training Centers offers hands-on, remote instructor-led training classes at our more than 300 locations in North America. And for those not near one of our sites, you can attend these same live classes from your home/office computer via our Remote Classroom Instruction (RCI™). See list of ONLC locations.


For More Information

To register for class by phone or for more information...