This course will be available from January 2019.

Excel is one of the most widely used solutions for analyzing and visualizing data. It now includes tools that enable the analysis of more data, with improved visualizations and more sophisticated business logic. In this data science course, you will get an introduction to the latest versions of these new tools in Excel 2016 from an expert on the Excel Product Team at Microsoft.

Learn how to import data from different sources, create mashups between data sources, and prepare data for analysis. After preparing the data, find out how business calculations can be expressed using the DAX calculation engine. See how the data can be visualized and shared to the Power BI cloud service, after which it can be used in dashboards, queried using plain English sentences, and even consumed on mobile devices.

Do you feel that the contents of this course are a bit too advanced for you and you need to fill some gaps in your Excel knowledge? Do you need a better understanding of how pivot tables, pivot charts, and slicers work together and help in creating dashboards? If so, check out Introduction to Data Analysis using Excel.

What You’ll Learn

  • Gather and transform data from multiple sources
  • Discover and combine data in mashups
  • Learn about data model creation
  • Explore, analyze, and visualize data

Course Curriculum

Welcome to the Course!
Welcome Details 00:05:00
Course Basics Details 00:05:00
Schedule and Grading Details 00:05:00
Set up the Lab Environment
Which Excel Version Should I Use? Details 00:05:00
Install Office 2016 Professional Plus Trial Details 00:15:00
Notes for Using Non-Supported Excel 2016 Details 00:05:00
Notes for Using Supported Excel 2013 Details 00:15:00
Notes for Using Non-Supported Excel 2013 Details 00:05:00
Notes for Using Excel 2010 Details 00:20:00
DataSet / Examples Usage
DataSet / Examples Usage Details 00:05:00
Pre-course Survey Survey
Analyzing and Visualizing Data with Excel Course Survey 00:10:00
Survey Acknowledgement 00:01:00
Module 1 - Data Analysis in Excel
Data Analysis in Excel – Lecture Details 00:20:00
(Optional) Create an Excel Table Details 00:10:00
Using VLOOKUP Details 00:05:00
Data Analysis in Excel Quiz 00:15:00
Lab: Explore and Extend a Classic Excel Dashboard
Lab Overview Details 00:20:00
Exercise 1: Explore the Classic Excel Dashboard 00:15:00
Exercise 2: Extend the Classic Excel Dashboard 00:15:00
Applying Conditional Formatting Details 00:05:00
Module 2 - The Excel Data Model
The Excel Data Model – Lecture Details 00:15:00
The Excel Data Model Quiz 00:10:00
Basic DAX
Basic DAX – Lecture Details 00:25:00
A Little Bit More About DAX Details 00:15:00
Basic DAX Quiz 00:10:00
Lab: Explore an Excel Data Model
Lab Overview Details 00:05:00
Exercise 1: Explore the Excel Data Model 00:05:00
Exercise 2: Create a Pivot Table 00:20:00
Exercise 3: Create Measures 00:10:00
Tips and Tricks Details 00:10:00
Importing Data from a CSV File
Importing Data from a CSV File – Lecture Details 00:20:00

SmithTips is a human capital organization that is aimed at being the bridge between academia and industry by working to build and develop the capacity of individuals and groups.

 Dansoman Atico, Accra, Ghana

(00) 233 260 734 574

Last Tweets

Who’s Online

There are no users currently online
Skip to toolbar