Analyzing Data with Excel (MS-20779)

If you are interested in updating your skills of excel sheet with the BI techniques, you have come to the right place. QuickStart offers a variety of Data science trainings and courses to keep you updated and in markets spot light.


Learning Style





3 Days

Course Duration


SATV Value

Course Info

Download PDF


See Sample

SubscribeBuy Individually
empty table
When you subscribe, you get:
Master Subscription plan gives you access to this course and over 1188 other popular courses
On Sale!
Now Only $2,999.00 Regular Price $3,499.00
Now Only $2,999.00 Regular Price $3,499.00
/ Year
19 Learners Have Enrolled For This Course

You have already taken demo for this course.

If you want to get access to demo again, feel free to contact our support at (855) 800-8240
If you are interested in updating your skills of excel sheet with the BI techniques, you have come to the right place. QuickStart offers a variety of Data science trainings and courses to keep you updated and in markets spot light.

Course Information

If you enroll in this course without the Master Subscription plan, you receive a Free Official Exam Voucher (excluding purchases using Training Vouchers / SATV) for the 70-779 Exam. This course does not include Exam Voucher if enrolled within the Master Subscription, however, you can request to purchase the Official Exam Voucher separately.

About this course:

Analyzing Data with Excel (MS-20779) is a 3 day course, that focuses mostly on integrating BI techniques to Excel Data analysis, therefore this course increases the capabilities of students from making pie charts and tables to Pivot charts, the Excel data Model and Power BI.  The courseware is supported by virtual labs to provide practice on real platforms. Moreover, students will get a recognized certificate on completion off the course.

A qualified Solutions Developers with Microsoft Azure skills earns $81,714 annually.

Course Objective: 

After completing this course, students will be able to: 

  • Explore and extend a classic Excel dashboard.

  • Explore and extend an Excel data model.

  • Pre-format and import a .CSV file.

  • use data from a SQL Server database

  • use data from a previous reports.

  • Build measures using advanced DAX functions.

  • Build data visualizations in Excel.

  • Build a Power BI dashboard with Excel.


The target audience of this course includes:

  • Students experienced in analyzing data with Excel and who wish to add BI techniques to their expertise.

  • SQL Server report creators who want to learn alternative methods of presenting data.


Students attempting this course must have a previous understanding of the following:  

  • Basic working knowledge of the Microsoft Windows operating system and its functions

  • Familiarity of relational databases.

  • Complete Knowhow of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals.

Suggested prerequisites courses:

  • SQL Database for Beginners


Frequently Asked Questions

Q1. How will this training benefit me in my current job role? This training will help you in your Job’s current role by learning and getting hands on experience in the following areas:

Q2. How to create Excel Dashboards, Analyze Data, How to use Excel Pivot tables and what are some limitations of Data Analysis in Excel.

  • Learn about Data modelling using Excel and how to write DAX queries.
  • Data Transformation and Shaping, Loading into excel and Data Importing from Pre-Formatted Excel files.
  • Learn how to import data from SQL Server, CSV file and create a Data Table.
  • You will also learn how to import and transform data from excel reports to create meaningful insights for your business to make key-business decisions.
  • You will learn how to write some advanced DAX functions, write complex DAX queries to create measures.
  • Data Visualizations help businesses understand factual information and this requires understanding of Pivot Charts, Cube Functions and Charts available for Cube Functions, which you learn in this course.
  • Most powerful BI tool to this date “Power BI”. You will be able to get an overview of it regarding how to upload your excel data into Power BI and what are some

Q3. How To Replace One Value With Another In Excel? You can replace one value with another using the FIND & REPLACE feature in Excel. To do this, select the data set and use the keyboard shortcut - CONTROL H (hold the control key and then press H). This will open the Find & Replace dialog box. In this dialog box, you can specify the value you want to change and the replacement value.

Q4. How Can You Select All Blank Cells In Excel?

  • If you work with a data set that has blank cells in it, you can easily select these cells in Excel. Once selected, you can choose to highlight these, delete these, or add some value to it (such as 0 or NA).
  • To do this, you need to use the Go To Special dialog box in Excel.

Here are the steps to select all blank cells in Excel:
  1. Select the entire data set (including blank cells).
  2. Press F5 (this opens the Go to dialog box).
  3. Click the 'Special' button (this opens the Go To special dialogue box).
  4. Select Blanks and click OK (this selects all the blank cells in your data set).

Q5. Explain the function of Solver in Excel?

  • Solver in Excel is an add-in that allows you to get an optimum solution when there are many variables and constraints.
  • You can consider it to be an advanced version of Goal Seek.
  • With Solver, you can specify what the constraints are and the objective that you need to achieve.
  • It does the calculation in the back-end to give you a possible solution

Q6. What Is A One-variable Data Table?

One variable Data Table in Excel is most suited in situations when you want to see how the final result changes when you change one of the input variables.

For Example:

  • If you want to know how much on monthly installment change if you increase/decrease the number of months, you can set up a one-variable data table for it.
  • This can be useful when you want to keep the monthly payment less than $500 and know what all options you have (6 months, 9 months, 12 months, etc.)

More Information

More Information
SubjectsIT Ops & Management
Lab AccessYes
Learning StyleVirtual Classroom
Learning TypeCourse
Course Duration3 Days
SATV Value3
VPA DiscountVPA Discount


Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account

Virtual instructor Led

Virtual Classroom Courses

Our virtual instructor-led courses give you access to live instructors training you with other live students in a virtual classroom environment.

200+ Virtual Classroom Courses

Online Self-Paced Courses

Take self-paced online courses at your convenience and own pace, with unlimited access to courses in various emerging technologies.

700+ Self-Paced Courses

E-books blogs, case studies, ariticles

As part of informal learning, our platform will recommend E-books, whitepapers, case studies, articles, and videos. This is AI curated content closely aligned with your learning objectives.

E-books blogs, case studies,...

College Accredited Courses

QuickStart courses are accredited by several top schools and universities, including Texas A&M and University of Phoenix. You can print out certificates and also apply them towards your degree plan with them.

College Accredited

Full Learning Dashboard & Analytics

Access all your enrolled, completed, course statistics, and community discussions from one centralized and intuitive learning dashboard with built in analytics, course tracking, time spent, and more.


QuickStart Discussions

Engage with other learners where you can directly chat, ask questions, and socialize with other learners experts and instructors on a course subject.

Community Access Community Access

Virtual Labs

Videos and lectures only go so far. Get real world, hands-on practice with virtual labs (not available for all courses).

Virtual Labs Virtual Labs
Live Instructor Support

Live Instructor Mentoring & Support

Get your IT problems solved through a community of mentors, experts and peers. Get live help from experts to answer questions on course material or guidance on a project.

Mentoring & Discussions Mentoring & Discussions

Career Paths

Start a learning pathway towards understanding and mastering your career. With QuickStart career paths, you can fully understanding and being the best in your field.

Learning Paths Learning Paths

Informal Learning

Access to AI curated content from various content publishers which can help in self-directed learning.

Informal Learning Informal Learning