The official Microsoft Analyzing and Visualizing Data with Microsoft Excel outline defines 3 domains. The leading three are Consume and Transform Data by Using Microsoft Excel (30-35), Model Data (35-40), and Visualize Data (30-35). The full list is in the topics section above, and ExamPrepAway's 118 practice questions cover each one.

Strong understanding of Microsoft Excel data analysis and visualization; recommended experience with Power Query, Power Pivot, PivotTables, DAX Since requirements change over time, confirm the latest on the official Microsoft exam page before scheduling.

Onsite and Online proctored delivery when it was active (via Pearson VUE) Register for the Microsoft Analyzing and Visualizing Data with Microsoft Excel exam through these official channels:

After booking, ExamPrepAway delivers your practice questions within 1 minute — preparation starts the same day.

The 070-779 exam is a Microsoft certification exam validating the Microsoft Analyzing and Visualizing Data with Microsoft Excel syllabus shown above. It belongs to these credential paths: MCSA: BI Reporting. Candidates in 2026 start with ExamPrepAway's 118 practice questions, available as a printable PDF, a Windows Desktop Test Engine, and an Online Test Engine — three versions of the same materials.

The Microsoft Analyzing and Visualizing Data with Microsoft Excel exam contains Approximately 40 to complete within 150 minutes. Timed simulation in the ExamPrepAway Desktop Test Engine teaches that rhythm before exam day does.

ExamPrepAway issues a full refund if you take the Microsoft Analyzing and Visualizing Data with Microsoft Excel exam within 60 days of purchase and do not pass. The policy does not apply if the exam is taken within 3 days of purchase, if the exam was never actually taken, or to free materials or expired orders, and the candidate name must match the payer name. Submit a scan of your enrollment slip and the official Score Report PDF within 2 days of the exam; claims are processed within 7 days. Alternatively, exchange for two free exam products of equal value and keep your original update service. Orders arrive by email within 1 minute — contact support if nothing arrives within 2 hours.

The Microsoft Analyzing and Visualizing Data with Microsoft Excel exam requires 700 (scaled score) to pass, and registration costs USD price historically around 165 (retired exam pricing varied). A failed attempt means paying the same fee again — a readiness check with the ExamPrepAway engines before booking is the cheaper option.

Microsoft recommends these training resources for the Microsoft Analyzing and Visualizing Data with Microsoft Excel exam:

Follow the training with steady self-testing — the 118 practice questions from ExamPrepAway help you apply theory and fill any gaps the training leaves.

Three versions of the same study materials: a printable, expert-prepared PDF with free demo download and instant access; a Desktop Test Engine for Windows with customizable simulation and timed modes that works offline; and an Online Test Engine for any browser on Windows, Mac, Android, and iOS with test history and performance review. All 118 practice questions are identical across versions. Every purchase includes 365 days of free updates, a 50% renewal discount afterward, and unlimited computer installations.