Home > Store

Exam Ref 70-779 Analyzing and Visualizing Data by Using Microsoft Excel

Exam Ref 70-779 Analyzing and Visualizing Data by Using Microsoft Excel

eBook (Watermarked)

  • Your Price: $25.59
  • List Price: $31.99
  • Estimated Release: May 29, 2018
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

Also available in other formats.

Register your product to gain access to bonus material or receive a coupon.


  • Copyright 2018
  • Pages: 256
  • Edition: 1st
  • eBook (Watermarked)
  • ISBN-10: 1-5093-0809-1
  • ISBN-13: 978-1-5093-0809-5

Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-779 Analyzing and Visualizing Data by Using Microsoft Excel certification exam.

Exam Ref 70-779 Analyzing and Visualizing Data by Using Microsoft Excel offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern IT professionals need to successfully consume, transform, model, and visualize data with Excel 2016. Coverage includes:

  • Importing data from external data sources
  • Working with Power Query
  • Designing and implementing transformations
  • Applying business rules
  • Cleansing data
  • Creating performance KPIs
  • And much more

Microsoft Exam Ref publications stand apart from third-party study guides because they:

  • Provide guidance from Microsoft, the creator of Microsoft certification exams
  • Target IT professional-level exam candidates with content focused on their needs, not "one-size-fits-all" content
  • Streamline study by organizing material according to the exam’s objective domain (OD), covering one functional group and its objectives in each chapter
  • Feature Thought Experiments to guide candidates through a set of "what if?" scenarios, and prepare them more effectively for Pro-level style exam questions
  • Explore big picture thinking around the planning and design aspects of the IT pro’s job role

For more information on Exam 70-779 and the MCSA: BI Reporting credential, visit microsoft.com/learning.

Sample Content

Table of Contents

1. Consume and Transform Data
2. Model Data
3. Visualize Data


Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership