Business Intelligence with Excel 2013

Microsoft Excel is, by a long way, the most widely-used spreadsheet software out there, and the 2013 edition is the most powerful and versatile version yet. Packed with new features and design changes, Microsoft Excel 2013 has plenty to offer for any company.

Whether you’re new to Excel, or just looking to update your knowledge to the latest version, you’ll find that this course will help you put together stunning and impressive spreadsheets with ease, helping you to stand out in the workplace and impress your boss.

lIFETIME ACCESS

INR 999

Business Intelligence with Excel 2013

Introduction

 

 Introduction to Excel Business Intelligence Technologies

 

 Activating Addins

 

Working with Power Query

 

 Introduction to Power Query

 

 Power Query Interface

 

 HR Master

 

 Cleaning and Transforming Data with Power Query

 

 Download the Append Data Files

 

 Appending Data with Power Query

 

 Download Merge Data Files

 

 Merge Data with Power Query

 

 Sales Data

 

 Using the Group By Feature

 

 Load Data to Power Pivot

 

Working with Power Pivot / Data Model

 

 Introduction to Power Pivot

 

 Introduction to Power Pivot

 

 Download the Employee Master Training File

 

 Loading Data into PowerPivot

 

 Creating Relationships

 

 Analyzing Data with Pivot Tables

 

 Calculated Columns

 

 Calculated Fields

 

 Pivot Tables and Pivot Charts

 

 Creating Interactive Dashboards

 

Excel Power View

 

 Introduction to Power View

 

 Introduction to Power View

 

 Tables and Tiles in Power View

 

 Visualization Column and Bar Charts

 

 Visualizations Line

 

 Interactive Dashboard

 

 Using Filters in Power View

 

 Download the Sales Training Data Source

 

 Creating Scatterplots in Power View

 

 Creating ScatterPlots over Time

 

 Mapping Data

 

Power Map

 

 Power Map

 

 Introduction to Power Map

 

 Mapping Data in Power Map

 

 Changing the Method of Visualization

 

 Mapping Over Time

 

 Changing the Method of Aggregation in Power Map

 

 Creating Tours of Power Map Data

 

 Conclusion

 

More than 20000 students on Udemy

  • 4.1 Instructor Rating
  • Best Seller Course
  • Highest Rated Course
  • Courses used by udemy for business clients.

210K students on our platform

  • Unlimited access to all courses.
  • Top Courses for every trending technologies.
  • 4.5 Average ratings for all the courses.
  • Certificate Internationally accepted.

Learn at your pace

Courses Made By Industry Experts

Enhance your career

Enroll NowContact us