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.


INR 999

Business Intelligence with Excel 2013



 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




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