Business Intelligence with Excel 2013

  • Duration – 15 hour

 

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.

All Business Analytics Courses Bundle

$40

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

 

Complete End to End Job Oriented Courses.

Best self paced courses created by industry experts & 24/7 support.

Knowasap Features 

300+ Courses

After your course completion, we provide course completion certificate as well.

Lifetime Access

All courses are for lifetime access.

l

Priority Support

All queries are answered 24/7.

What People Are Saying

Abhilash -

A very good match. i am enjoying every bit.

Sonal-

Experience was quite good and it was very useful and well elaborated course.

Karan-

I FEEL AS IF I AM ATTENDING A WORLD CLASS TRAINING AND THE LECTURER HAS BEEN AWESOME!

Gilbert-

I find that the explanation is good and also understandable.

Seyed-

Really helpful, recommended to everyone to grow up your future skills for next level especially in this competitive market.

Mayur-

I really like this course, it was a good match for me :))

Mahesh-

Standard process and hands on covered nicely.

 

Emily-

Perfect, with complete hands on. Well structured and nicely covered.

Kevin-

Great Content, nice and up to the mark course.

Mayuresh-

 

Great courses. Beginner friendly and the explanations are clear and very easy to understand.

Saket-

Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.

Tushar-

A very detailed explanation and quite handy tips and tricks! loved it

Sourabh-

 

Excellent lecture, pace of the instructor is very good, easy to understand

Rishi-

Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.

Mahima-

This Courses is really useful for my career and surely i will recommend other to fulfill their career goals.

 Mauricio Roldan -

A pesar de no dominar perfectamente el idioma, se entiende bien.

Emile-

Yes lessons are very good. Not so fast, well explained

Kishore-

Worth course for the beginner to invest their time to learn this demanding skills.

Learn at your pace

Courses Made By Industry Experts

Enhance your career

Enroll NowContact us