Product Image

Data Analysis Fundamentals using Excel (MS-10994)

Rating:
80% of 100

The main reason for the course is to enable understudies to add investigation capacities to Excel spreadsheets and to give understudies an establishment to learn further developed information examination with Excel or Power BI.

Virtual

Learning Style

Microsoft

Provider

Intermediate

Difficulty

2 Days

Course Duration

2

SATV Value

Course Info

Download PDF

Certificate

See Sample

Timezone
empty table
tab

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

The main reason for the course is to enable understudies to add investigation capacities to Excel spreadsheets and to give understudies an establishment to learn further developed information examination with Excel or Power BI.

Course Information

About this course:

The main reason for the course is to enable understudies to add investigation capacities to Excel spreadsheets and to give understudies an establishment to learn further developed information examination with Excel or Power BI.

Course Objective:

  • Create an Excel report
  • Create Hierarchies
  • Filtering Excel Data
  • Formatting Excel Data
  • Create excel Charts
  • Create a pivot table and pivot chart
  • Explain pivot tables and how to create them.
  • Define the various elements of a pivot chart.
  • Edit pivot tables and pivot charts.
  • Explain what Excel Data tables are.
  • Sort, filter, and validate data.
  • Summarize data.
  • Format summarized data.
  • Create an Excel table
  • Create a dashboard and analyze data
  • Describe the dashboard.
  • Filter data using a slicer.
  • Add calculated columns to a dashboard.
  • Find anomalies.
  • Create a model of Excel data and connect to external data
  • Explain an Excel Data Model and how to use it.
  • Import External Data and use it.
  • Link out to external data.

Audience:

This course is designed for any individual who needs to take the information analysis innovations in Excel beyond formulas and include further developed capacities, for example, hierarchies, dashboards, and connections.

Prerequisite:

Prior to attending this course, understudies must have:

Fundamental information on the MS Windows operating framework and its main usefulness.

Propelled working information on Excel spreadsheets including formulas.

Outline

More Information

More Information
Brand Microsoft
Subjects Business Productivity
Lab Access No
Technology Microsoft
Learning Style Virtual Classroom
Learning Type Course
Difficulty Intermediate
Course Duration 2 Days
Language English
SATV Value 2

Reviews

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

Course Expert:

Author

Tom Robertson
(Data Science Enthusiast)

Tom is an innovator first, and then a Data Scientist & Software Architect. He has integrated expertise in business, product, technology and management. Tom has been involved in creating category defining new products in AI and big data for different industries, which generated more than hundred million revenue cumulatively, and served more than 10 million users.
As a Data Scientist and Software Architect Tom has extensive experience in data science, engineering, architecture and software development. To date Tom has accumulated over a decade of experience in R, Python & Linux Shell programming.

Tom has expertise on Python, SQL, and Spark. He has worked on several libraries including but not limited to Scikit-learn, Pandas, NumPy, Matplotlib, Seaborn, SciPy, NLTK, Keras, and Tensorflow.

Customer Reviews
  1. Data Analysis Fundamentals using Excel (MS-10994)
    Overall Satisfaction
    80%
    Quality of Instructor
    80%
    Course Quality
    80%
    Good Training

    Review by

    Posted on

  2. Data Analysis Fundamentals using Excel (MS-10994)
    Overall Satisfaction
    80%
    Quality of Instructor
    80%
    Course Quality
    80%
    Good materials and good hands­on labs.

    Review by

    Posted on

  3. Data Analysis Fundamentals using Excel (MS-10994)
    Overall Satisfaction
    80%
    Quality of Instructor
    80%
    Course Quality
    80%
    The course met all my needs and expectations so i would recommend it to anyone looking for additional training.

    Review by

    Posted on

click here