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.Stay current with the latest Microsoft Self-Service technology and remain relevant for new job opportunities.

 

RoadMap to the Data Analytics with Excel Certificate:

This certificate is divided into 5 classes. The first 3 classes are a Certificate on its own: Master Excel Certificate (Basic, Intermediate and Advanced Excel). You can take the 3 classes in the classroom or online ETG-8106.

The fourth class Data Analysis and Business Modeling with Excel will teach you advanced functions 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. The fifth and last class will introduce you to the brand new technology of Self-Service BI, and how to create your own business intelligence solutions with Power BI. This popular cloud based Business Intelligence platform, performs sophisticated data integration, modeling and reporting in our trusted and beloved Excel. 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.

 

Class TitleCourse #Classroom HoursOffered
Excel Basic DPT-8014 12
Fall 2016
Excel Intermediate DPT-8015 12
Fall 2016
Excel Advanced DPT-8035 12
Fall 2016
Data Analysis and Business Modeling with Excel DPT-7150 30 Fall 2016
Power BI Intro DPT-7151 24 Fall 2016

Important note: Excel Basic, Intermediate and Advanced can be replaced by the Online class MS Excel 2013 Certification Training- Online (ETG-8106). You could also test out of any of the 3 first classes with a passing score in the Excel MOS test.

 

Industry Certification

After completing the classes for Data Analytics with Excel Certificate you will be prepared to take the following certifications:

  • Microsoft Office Specialist (MOS) Excel 2013 #420

 

Job Titles and Career Outlook

There are many job titles that benefit from an advanced knowledge of Excel, such as: Business Intelligence Analyst, Statistician, Bookkeeper, Economist, Credit Analyst, Auditor, Sales or Marketing Managers, among others. Click here for information regarding your local (by zip code) career outlook and learn more more about:

  • Career Info - Typical task and educational level.
  • Pay - How well this career pays?
  • Growth - Is this career growing or declining?
  • Retirement - How many people will retire soon, creating job openings?
  • Employers - Who is hiring locally?

 

Other Advanced classes after completing the Certificate

 

Class TitleCourse #Classroom HoursOffered
Power BI Advanced DPT-7162 24 Fall 2016

 

Access the White Paper "Power BI Governance and Deployment Approaches" co-authored by Microsoft MVP and instructor of our Power BI classes, Javier Guillén.

 

    RECOMMENDED AND RELATED COURSES: