-
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
$100
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
Â
300+ Courses
After your course completion, we provide course completion certificate as well.
Lifetime Access
All courses are for lifetime access.
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.
