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.
