Exams

Exam 70-779: Analyzing and Visualizing Data with Microsoft Excel

Important

This exam retired on January 31, 2021. For currently available options, please refer to the Browse Certifications and Exams page.

 
Candidates for this exam should have a strong understanding of how to use Microsoft Excel to perform data analysis. Candidates should be able to consume, transform, model, and visualize data in Excel. Candidates should also be able to configure and manipulate data in PowerPivot, PivotTables, and PivotCharts. Candidates may include BI professionals, data analysts, and other roles responsible for analyzing data with Excel.

Part of the requirements for: MCSA: BI Reporting

Related exams: none

Go to Learn Profile

Schedule exam

  • 70-779: Analyzing and Visualizing Data with Microsoft Excel

    Languages: English

    Retirement date: **

    Candidates for this exam should have a strong understanding of how to use Microsoft Excel to perform data analysis. Candidates should be able to consume, transform, model, and visualize data in Excel. Candidates should also be able to configure and manipulate data in PowerPivot, PivotTables, and PivotCharts. Candidates may include BI professionals, data analysts, and other roles responsible for analyzing data with Excel.

    Price based on the country or region in which the exam is proctored.

    We strongly recommend that you register for an exam with a personal MSA account. If you register with an organizational (work/school) AAD account, your exam records will be lost if you leave your organization and they will be unrecoverable.
    for Analyzing and Visualizing Data with Microsoft Excel

    All objectives of the exam are covered in depth so you'll be ready for any question on the exam.

Skills measured

  • Consume and Transform Data by Using Microsoft Excel (30-35%)
  • Model Data (35-40%)
  • Visualize Data (30-35%)

Download exam skills outline

Two ways to prepare

Items in this collection

  • Learning paths or modules are not yet available for this certification

There may be certifications and prerequisites related to "Exam 70-779: Analyzing and Visualizing Data with Microsoft Excel"

  • MCSA: BI Reporting

    This certification demonstrates your expertise in analyzing data with both Power BI and Excel.

Exam resources

Exam Replay

Boost your odds of success with this great offer.

Your certifications

Review and manage your scheduled appointments, certificates, and transcripts.

* Pricing does not reflect any promotional offers or reduced pricing for Microsoft Certified Trainers and Microsoft Partner Network program members. Pricing is subject to change without notice. Pricing does not include applicable taxes. Please confirm exact pricing with the exam provider before registering to take an exam.

** Complete this exam before the retirement date to ensure it is applied toward your certification. After the retirement date, please refer to the related certification for exam requirements.