Data Analytics with Excel Certificate

Develop the skills to become a "Power Excel" user and learn how to quickly tell the story of your data and make yourself more marketable in the field of data analysis.

Master the skills in Excel including business modeling and learn how to transform data into bottom-line results.



RoadMap to the Data Analytics with Excel Certificate:

Master Excel

Demonstrate that you have the skills needed to get the most out of Office by earning a Microsoft Office Specialist certification in Excel.  In this course you will begin with building a spreadsheet and then moving into more complex features of the application to create business insights.  This course can be taken as one, or by enrolling in Basic, Intermediate, and Advance.  Course maps to Microsoft Exam 77-420.

Master Excel (MOS 7001), or MS Excel 2013 Certification Training- Online (ETG-8106) or:

Excel Basic (DPT 8014)
Excel Intermediate (DPT 8015)
Excel Advanced (DPT 8035)

Data Analysis and Business Modeling with Excel

This course is designed to teach the advanced functions of Excel, to master the business modeling and analysis techniques that help transform data into bottom-line results.  Participants will learn important math functions for statistics, forecasting, and optimization modeling.

Data Analysis and Business Modeling with Excel (DPT 7150)

Excel Pivot Tables

As an advanced user of Excel, you will gain the knowledge of data manipulation and visual reporting through the Pivot Table function.  This skill is one of the most sought after skills in the market. The target audience for this class is business/financial analyst and project managers.

Excel Pivot Tables (DPT 7161)

-----   OR  ------

Power BI Intro

Learn how to transform your skills, data, and business and create your own business intelligence solutions with Power BI, a popular cloud based Business Intelligence platform for performing sophisticated data integration, modeling and reporting. In this class, you will focus on real world scenarios, problem-solving, and data modeling. Learn how to turn mass quantities of data into meaningful information and on-the-job results.

Course Outline (DPT 7151)