Microsoft Excel Data Analysis - Learn How The Experts Use It

Name: Microsoft Excel Data Analysis - Learn How The Experts Use It
Rating: 4.8 (5696 reviews)

Learn the analytics capabilities of Excel and its add-ins, like PowerPivot & How it is used by business data analysts.

Highest Rated

Created byVincent Gomez

Last updated 6/2026

English

What you'll learn

Understand and Identify the principles of data analysis
Build presentation ready dashboards in Excel
Apply analysis techniques to datasets in Excel
Become adept at using Excel functions and techniques for analysis
Learn how to use Pivot Tables and Pivot Charts to streamline your workflow in Excel
Use effective design principles when creating and presenting data
Learn about Excel's Ubiquity And Strategic Importance as a BI Tool
Learn about the Excel Data Model
GeoFLow
Working with External Databases
Integration with Sharepoint

Course content

9 sections • 40 lectures • 2h 57m total length

Introduction3:28

Features Overview6:26
Obtaining the Add-In, Data Import4:46
DEMO: Data Import and Setting Relationships6:35
Advanced Modeling6:47
Master advanced modeling in Power Pivot by building calculated columns and measures with DAX syntax, managing relationships, perspectives, hierarchies, and KPIs, and using diagram view to refine the model.
DEMO: Advanced Modeling, Querying In Excel9:42
Create calculated columns and measures in Power Pivot, format as currency, and set a KPI for total sales; build hierarchies and a date table with slicers for geography and time.

Overview5:00
Creating Reports5:56
Create Power View reports that query semantic models, including direct query mode for tabular analysis services. Activate the add-ins, design reports in Excel or SharePoint, and export to PowerPoint.
Demo: Power View Basics3:18
Maximize, Filters and Bubble Charts1:14
DEMO: Filters, Bubble Charts and the Play Axis3:45
Advanced Properties1:56
Explore advanced properties in Power Pivot, like the representative column and image, and see how Power Pivot and Power View render keys and aggregations in the BI semantic model.

Overview, Data Sources and Tie-Ins with Excel Data Model7:57
Demo: Importing Web and Facebook Data4:16
Data Shaping, Data Manipulation and Integrating Child Data2:35
Explore data shaping and manipulation with data explorer: configure data types, modify schema, split delimited text, manage columns, sort, group, pivot, filter, replace values, and work with parent-child data.
Demo: Importing, Shaping and Visualizing HDInsight (Hadoop) Data9:46
Data Formulas, Scripts and the 'M' langauge1:44
Discover how Data Explorer records each step as a formula, enabling a script view of acquired data, filters, splits, and renames; the M language powers data modeling across types.
Demo: Working with Data Steps and Scripts2:29

Overview and First Steps3:49
Demo: Mapping the Hadoop Data5:10
Explore geo flow in Excel 2013 by mapping Hadoop cell tower dwell time data using country and state geography; visualize dwell time as bar height in the data model.
Chart Types, Controls and Visual Elements3:34
Explore geo flow visuals, including column, bubble, and heat map charts with flexible aggregations and time regions. Master map controls, annotations, and theme options to enhance data storytelling.
Demo: Bubble Charts, Heat Maps, Panning, Zooming, and Themes4:38
Layers, Scenes and Tours2:12
Explore how layers, scenes, and tours let you overlay charts such as column charts and heat maps, adjust properties, lock scales, and create animated, themed transitions.
Demo: Working with Layers, Building Scenes and Tours2:00

Requirements

Basic experience with Excel functionality

Description

Microsoft Excel is one of the most powerful and popular data analysis desktop application on the market today. Having a deep practical knowledge of Excel will greatly increase your productivity. You will be seen as a very skilled business data analyst in the organization. And will lead to a much greater opportunities for you.

Excel is the number-one spreadsheet application, with a plethora of capabilities. If you're only using the basic features, you're missing out on a host of features that can benefit your business by uncovering important information hidden within raw data. This Excel Data Analysis course allows you to harness the full power of Excel to do all the heavy lifting for you.

The course, comprised of 3+ hours of video training, guides you through the basic and advanced features of Excel to help you discover the gems hidden inside. From data analysis, to visualization, the course walks you through the steps required to become a superior data analyst.

Who this course is for:

Anyone who wants to learn to apply data analysis techniques using Excel
Anyone who wants to become good at using Excel for data analysis
Anyone who wants to learn the core concepts of data analysis in Excel
Anyone who wants to learn about PowerPivot, Pivot Charts etc..

Microsoft Excel Data Analysis - Learn How The Experts Use It

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 3min

Excel as a BI Tool2 lectures • 9min

Data Management And Modeling: Core Excel and the Excel Data Model8 lectures • 40min

Data Management and Modeling: PowerPivot5 lectures • 34min

Data Discovery and Visualization: Power View6 lectures • 21min

Data Acquisition: Data Explorer6 lectures • 29min

Mapping: GeoFlow6 lectures • 21min

How SharePoint Ties In4 lectures • 15min

Wrap-Up2 lectures • 5min

Requirements

Description

Who this course is for: