Analyzing Data with Excel Training (20779)

This official Microsoft Analyzing Data with Excel (20779) course and learn to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.

Plus, this course will prepare you for Microsoft exam 70-779, a core requirement for the MCSA: BI Reporting certification.

You Will Learn How To:

  • Explore and extend a classic Excel dashboard
  • Explore and extend an Excel data model
  • Pre-format and import a .CSV file
  • Import data from a SQL Server database
  • Import data from a report
  • Create measures using advanced DAX functions
  • Create data visualizations in Excel
  • Create a Power BI dashboard with Excel

  • On-Demand Training Description

    With a blend of video, text, hands-on labs, and knowledge checks, you will receive the same high quality content as the live event, but you can attend on your own time, at your own pace.

    PLUS, we include access to a Microsoft Certified Trainer (MCT) to help you prepare for your certification exam and help you apply your new skills immediately… Learning Tree knows how to bring learning to life!

    • Flexibility to take the course on your own time, at your own pace
    • Forever access to the digital course materials – for any refreshers
    • You will receive a code with your purchase.The code may be redeemed for online access to this On Demand course for up to six months
    • Upon course activation, the MOC On Demand videos and labs are available for three months
    • 2 FREE hours of individual coaching from an MCT Learning Tree Instructor
    • This delivery is also eligible for Microsoft Assurance Training Vouchers (SATVs)
    • NOTE: Only live, in-class training is eligible for NASBA CPEs; on-demand training is not eligible for CPE credit

  • Requirements

    • Before attending this course, students must have:
      • Basic knowledge of the Microsoft Windows operating system and its core functionality
      • Working knowledge of relational databases
      • Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals
      • Basic knowledge of data analytics equivalent to having attended course 10994

  • Exam Information

    This course can help you prepare for the following Microsoft certification exam — 70-779: Analyzing and Visualizing Data with Microsoft Excel

  • Redeem Your Microsoft Training Vouchers (SATV)