Microsoft 070-779 exam dumps : Analyzing and Visualizing Data with Microsoft Excel

  • Exam Code: 070-779
  • Exam Name: Analyzing and Visualizing Data with Microsoft Excel
  • Updated: Jul 22, 2026     Q & A: 118 Questions and Answers

PDF Version Demo
PDF Price: $59.99

PC Test Engine
Software Price: $59.99

Microsoft 070-779 Value Pack (Frequently Bought Together)

070-779 Online Test Engine
  • If you purchase Microsoft 070-779 Value Pack, you will also own the free online test engine.
  • PDF Version + PC Test Engine + Online Test Engine
  • Value Pack Total: $119.98  $79.99
  •   Save 49%

About Microsoft 070-779 Exam

It is well known that the 070-779 certification enjoy a high reputation in this field. Obtaining the 070-779 certification means you get the access to the big international companies. Except a considerable salary and benefits, you will have a chance to make friends with some influential people and work with extraordinary guys. While the best way to prepare for the 070-779 actual test is to assist with a valid and useful 070-779 exam prep dumps. The following is the character of the 070-779 training material.

Free Download 070-779 exam dumps pdf

99% pass rate for one time pass

We offer you 070-779 exam prep dumps to help you learn the key knowledge of the test. And you just need to spend one or two days to practice 070-779 training questions and know your weakness and strength during the preparation. The pass rate is reach to 99% because 070-779 updated study material is composed by our professional colleague who has rich experience. The content of 070-779 exam practice dumps is comprehensive and detail, which can help you have a good knowledge of the actual test. With the enough study buy our 070-779 training study, you can be confident to deal with any difficulties in the actual test.

070-779 online test engine

With the 070-779 online test engine, you can experience the actual test environment during the practice. It is suitable for any electronic device with any limit, such as: Windows/Mac/Android/iOS operating systems. When you use the 070-779 online test engine, you can set the test time with each practice and get the test score after finished the test. Besides, the questions which you have made mistake can be marked for next review. With so many intelligence advantages, you can get many benefits from our 070-779 online test engine.

Microsoft 70-779 Exam Syllabus Topics:

TopicDetailsWeights
Consume and Transform Data by Using Microsoft Excel

Import from data sources
-Connect to and import from databases, files, and folders; connect to Microsoft SQL Azure, Big Data, SQL Server Analysis Services (SSAS), and Power Query; import supported file types; import from other Excel workbooks; link to data from other sources

Perform data transformations
-Design and implement basic and advanced transformations, apply business rules, change data format to support visualization, filter data, format data

Cleanse data
-Manage incomplete data; handle data received as a report; remove unnecessary rows, columns, and data; remove repeating headers

30-35%
Visualize Data

Create and manage PivotTables
-Format PivotTables and PivotCharts, format calculated measures, filter data, group and summarize data

Create and manage PivotCharts
-Select a chart type, format calculated measures, filter data; group and summarize data, use slicers

Interact with Power BI
-Import Excel data from Power BI, manipulate Excel data in Power BI

30-35%
Model Data

Create and optimize data models
-Manage data relationships, optimize models for reporting, manually enter data, perform Get & Transform, create automatic relationships, create manual relationships

Create calculated columns, measures, and tables
-Create DAX queries, create DAX formulas, create Excel formulas

Create performance KPIs
-Calculate the actual value, calculate the target value, calculate actual to target values

Create hierarchies
-Create date hierarchies, create business hierarchies, resolve hierarchy issues

35-40%

Reference: https://www.microsoft.com/en-us/learning/exam-70-779.aspx

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

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

Download exam skills outline

Free download 070-779 free demo

We are providing 070-779 free demo for customers before they decide to buy our dumps. Free demos are so critical that it can see the 070-779 dumps' direct quality. You can freely download the 070-779 free demo questions before purchase. There are part 070-779 exam questions and answers, not having all the questions. Besides, delivery time is very short. It's about several seconds to 30 minutes to get the 070-779 exam dumps after purchase. When you pay successfully of for the 070-779 practice test, you will receive our emails containing 070-779 test dumps. Using our 070-779 training practice, you will enjoy more warm and convenient online service.

We've set full refund policy for our customers to reduce their risk of exam failure. You could get full refund if you fail the 070-779 actual test. After you buy 070-779 test dump from us, you will get the latest update version freely in your email for 1 year.

After purchase, Instant Download: Upon successful payment, Our systems will automatically send the product you have purchased to your mailbox by email. (If not received within 12 hours, please contact us. Note: don't forget to check your spam.)

Microsoft 070-779 Exam Syllabus Topics:

SectionWeightObjectives
Topic 1: Consume and Transform Data by Using Microsoft Excel30-35- Cleanse data
- Import from data sources
- Perform data transformations
Topic 2: Model Data35-40- Create hierarchies
- Create and optimize data models
- Create performance KPIs
- Create calculated columns, measures, and tables
Topic 3: Visualize Data30-35- Interact with Power BI
- Create and manage PivotTables
- Create and manage PivotCharts

What Clients Say About Us

This is the best 070-779 exam materials i have ever seen PracticeTorrent.

Lyle Lyle       5 star  

I became so confident after using this 070-779 exam file and fair enough, i cleared the exam with high scores. Thanks for all your help!

Daisy Daisy       4 star  

I highly recommend the PracticeTorrent exam dumps to all the candidates. It gives detailed knowledge about the original exam. Passed my exam recently.

Nelson Nelson       5 star  

Though i found that i had a few questions not covered in the 070-779 file, i still passed with 95% marks. It is really helpful. Thanks!

Norman Norman       4 star  

If I achieved this awesome victory with high grades, it is all due to the PracticeTorrent Study Guide that has been proved immensely helpful in the entire process.

Edmund Edmund       4.5 star  

Download 070-779 exam materials from PracticeTorrent. Guys, everything is simple and works perfect!

Lennon Lennon       4.5 star  

I tried PracticeTorrent to pass my 070-779 exam, thanks for the results were just remarkable. Thanks a lot.

Cyril Cyril       4.5 star  

I’ve just passed my 070-779 exam with the help of this set of 070-779 exam questions and i am so excited.

Jodie Jodie       4 star  

Passed Yesterday, Got 92% Marks. Highly recommend this file.

Noel Noel       4 star  

Evidence has revealed that the candidates who remain in search of substandard free exam preparation sources often pay heavy price for that.

Archer Archer       4.5 star  

It's really cool to study with the 070-779 exam dumps. Thanks a lot! It is valid and easy to start.It is so reliable to to help me pass the 070-779 exam!

Zora Zora       4.5 star  

Cannot write in words the level of happiness I am feeling right now. Just passed Microsoft 070-779 exam and got more than my expectations. PracticeTorrent 070-779 dumps 070-779 100 Real exam

Letitia Letitia       4 star  

My roommate introduced PracticeTorrent to me and he said your 070-779 study dumps are quite effective. And i decided to have a try. You didn’t let me down. I truly passed with ease! Big thanks!

Bertram Bertram       5 star  

Highly recommendation! passed today! still valid... few new questions!

Hermosa Hermosa       4 star  

I just passed this 070-779 exam.

Conrad Conrad       5 star  

PracticeTorrent delivers you the success which other exam material providers fail to ensure. My statement is experience based. I tried twice for the 070-779 Passed!!!

Barnett Barnett       5 star  

Probably 93% of the test were questions from this dump.

Meredith Meredith       4.5 star  

I took the 070-779 exam last week and passed, I encountered many similar question in real exam. Thanks 070-779 exam dumps give me a chance to achieve my dream.

Bartley Bartley       4 star  

This is my thrid time use your material,070-779 still good for me,thank you.

Tracy Tracy       4.5 star  

I just wanted to thank PracticeTorrent for providing me with the most relevant and important material for 070-779 exam. You are really a good provider.

Edith Edith       4.5 star  

I can comfirm this 070-779 practice engine is valid and good to help. i passed with a high score.

Wendy Wendy       4.5 star  

Have passed my 070-779 exams. I could easily prepare for this exam and pass it in the first time. Big thanks.

Thera Thera       4.5 star  

I will try next Microsoft exams next month.

Julian Julian       5 star  

These dumps are 100% valid with 070-779 dumps and videos online. Thanks for your help. I passed my 070-779 exam.

Randolph Randolph       4.5 star  

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Why Choose Us