-
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.
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.
