Microsoft Analyzing and Visualizing Data with Excel
4.8 /5- Offered byedX
Microsoft Analyzing and Visualizing Data with Excel at edX Overview
Duration | 6 weeks |
Total fee | ₹8,328 |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Go to Website  |
Credential | Certificate |
Microsoft Analyzing and Visualizing Data with Excel at edX Highlights
- Earn a certificate after completion of the course
- Graded assignments for better learning
- Learn from industry best faculty
Microsoft Analyzing and Visualizing Data with Excel at edX Course details
Project managers
Analytics professionals
Data analysts
Candidate's having functional specializations such as MIS, Finance, Marketing, Operations, Human Relations, Information Technology and Administration
End users seeking proficiency in the use of Microsoft Excel 2013 at an advanced level
Gather and transform data from multiple sources
Discover and combine data in mashups
Learn about data model creation
Explore, analyze, and visualize data
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
In this program students will 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
Microsoft Analyzing and Visualizing Data with Excel at edX Curriculum
Week 1
Setup the lab environment by installing Office applications. Learn how to perform data analysis in Excel using classic tools, such as pivot tables, pivot charts, and slicers, on data that is already in a worksheet / grid data
Week 2
Learn about queries (Power Query add-in in Excel 2013 and Excel 2010), and build an Excel data model from a single flat table
Week 3
Get the details on how to create measures to calculate for each cell, filter context for calculation, and explore several advanced DAX functions
Week 4
Learn how Excel can work together with Power BI. Upload an Excel workbook to the Power BI service. Explore the use of Excel on the mobile platform
Microsoft Analyzing and Visualizing Data with Excel at edX Faculty details
Other courses offered by edX
Student Forum
Anything you would want to ask experts?