AWS, Microsoft, Google

1. Introduction

Introduction

1. Excel's Ubiquity And Strategic Importance

2. Excel Analytics Facilities

2. Excel as a BI Tool

1. Core Excel BI

2. DEMO Web Queries and the Data Connection Wizard

3. Office Data Connections

4. DEMO Managing Office Data Connections

5. Analysis Services Support

6. DEMO Querying an OLAP Cube

7. The Excel Data Model

8. The BI Semantic Model

3. Data Management And Modeling Core Excel and the Excel Data Model

1. Features Overview

2. Obtaining the Add-In, Data Import

3. DEMO Data Import and Setting Relationships

4. Advanced Modeling

5. DEMO Advanced Modeling, Querying In Excel

4. Data Management and Modeling PowerPivot

1. Overview

2. Creating Reports

3. Demo Power View Basics

4. Maximize, Filters and Bubble Charts

5. DEMO Filters, Bubble Charts and the Play Axis

6. Advanced Properties

5. Data Discovery and Visualization Power View

1. Overview, Data Sources and Tie-Ins with Excel Data Model

2. Demo Importing Web and Facebook Data

3. Data Shaping, Data Manipulation and Integrating Child Data

4. Demo Importing, Shaping and Visualizing HDInsight (Hadoop) Data

5. Data Formulas, Scripts and the _M_ langauge

6. Demo Working with Data Steps and Scripts

6. Data Acquisition Data Explorer

1. Overview and First Steps

2. Demo Mapping the Hadoop Data

3. Chart Types, Controls and Visual Elements

4. Demo Bubble Charts, Heat Maps, Panning, Zooming, and Themes

5. Layers, Scenes and Tours

6. Demo Working with Layers, Building Scenes and Tours

7. Mapping GeoFlow

1. Overview and Excel Services, Excel Web App

2. Demo Excel Analytics in the Excel Web App on Office 365

3. PowerPivot and Power View

4. PerformancePointReporting Services, Analysis Services Clients

8. How SharePoint Ties In

1. Review and Wrap Up

Wrap Up

<p><span style="color: #000000; color: #000000">Transform raw data into actionable insights with our 'Microsoft Excel Data Analysis' course. Whether you're a beginner or an intermediate Excel user, this course will equip you with advanced data analysis techniques. Learn to navigate Excel's powerful tools, perform complex calculations, and create compelling visualizations. Elevate your analytical skills and make data-driven decisions effortlessly. Enroll now to harness the full potential of Microsoft Excel for robust data analysis.</span></p>

Unlock the Power of Data with Microsoft Excel! 📊 Master the art of Data Analysis and become an Excel Pro in just a few clicks. Join our course now! 🚀

Advanced Data Analysis with Microsoft Excel

Dashboard

Profile

Memberships

Courses

Bundle Courses

Communities

Groups

Digital Products

Physical Products

Live Products

Video Library

Audio Library

Events

Appointments

Premium Pages

Certificates

Badges

Order History

Organization Orders

Subscription

Affiliate Dashboard

Settings

Billing

Learn Digital Marketing

Primary Menu

System Defaults

Primary color

Primary color hover

Heading text color

Body text color

Banner text color

Primary button text color

Primary button text hover color

Secondary button background color

Secondary button background hover color

Secondary button text color

Secondary button text hover color

Navbar item background color

Navbar item text color

Navbar item text hover color

Advanced Data Analysis with Microsoft Excel

My Digital Academy

Course Details

Course content