Agile SQA Tester & Scrum Master Bundle 2026
Dr. Tahira
5.0 (279)·2h 14m · 33 lectures
$3.00$12–$199up to −98%
Loading course
Microsoft Excel Data Analysis - Learn How The Experts Use It
Learn the analytics capabilities of Excel and its add-ins, like PowerPivot & How it is used by business data analysts.
5.05,696 reviews16,952 learners
- All Levels
- 2h 57m video
- 40 lectures
- English
- Captions
- Updated 2026
Taught by Vincent Gomez
- 2h 57m of on-demand video
- 40 lectures across 9 sections
- One-off payment — no subscription
- Lifetime access on web and mobile
- Closed captions (English)
Curriculum
9 sections40 lectures2h 57m total
- Introduction3:28
- Excel's Ubiquity And Strategic Importance3:50
- Excel Analytics Facilities5:06
- Core Excel BI3:30
- DEMO: Web Queries and the Data Connection Wizard7:33
- Office Data Connections2:55
- DEMO: Managing Office Data Connections2:13
- Analysis Services Support1:31
- DEMO: Querying an OLAP Cube8:48
- The Excel Data Model7:16
- The BI Semantic Model6:42
- Features Overview6:26
- Obtaining the Add-In, Data Import4:46
- DEMO: Data Import and Setting Relationships6:35
- Advanced Modeling6:47
- DEMO: Advanced Modeling, Querying In Excel9:42
- Overview5:00
- Creating Reports5:56
- Demo: Power View Basics3:18
- Maximize, Filters and Bubble Charts1:14
- DEMO: Filters, Bubble Charts and the Play Axis3:45
- Advanced Properties1:56
- 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
- Demo: Importing, Shaping and Visualizing HDInsight (Hadoop) Data9:46
- Data Formulas, Scripts and the 'M' langauge1:44
- Demo: Working with Data Steps and Scripts2:29
About this course
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 bu…
Before you start
- Basic experience with Excel functionality
Who it’s 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..
Related
More in IT & Software
IT Support Quiz Course and Notes - IT Fundamentals
MD Diallo
5.0 (255)·1h 56m · 26 lectures$3.00$12–$199up to −98%The Ultimate Cisco CCNA Packet Tracer Project
Bassam Alkaff • Remote Author @ INE • CCDP, CCNPx3, VCP
5.0 (210)·3h 14m · 57 lectures$3.00$12–$199up to −98%Salesforce Administrator ADM-301 Mock Exams | 2026 Updated
Danh Hien
5.0 (192)·$3.00$12–$199up to −98%
$3.00$12–$199