- Duration / Course length: Upto 13 Hours Start now
- Accredited by: CiQCPD Qualification Standards
- Certificates:
- Course delivery: This course is delivered in video format
Course details
Microsoft Excel is the most used spreadsheet program in the world. It can be used in almost any industry as you can carry out large numbers of data analysis, simple to complex maths and tabulating data streams. One of the most common add-in for Microsoft Excel 2016 is PowerPivot, and if you want to learn about that you can do so from this Microsoft Excel 2016 PowerPivot Training course.PowerPivot is a very useful add-in given that it is able to import millions of rows of data from multiple data sources into a single Excel workbook and contains a lot of data analysis features. Here you start out with getting to know the PowerPivot application, ways to import data from sources, refresh data, and create linked tables. Following these, you will explore how to organize and format tables, create calculated columns, sort and filter data, and create and manage table relationships. Furthermore you will learn to create PowerPivot reports for analysis and use the DAX functions, before finally moving onto protecting and saving reports in different file formats.
Now if you are looking to utilize this amazing add-in feature for your work, then you definitely need to get started on this course immediately.
COURSE CURRICULUM
- Enable and Navigate
- Import Data from Various Data Sources
- Refresh Data from a Data Source
- Create Linked Tables
- Organize and Format Tables
- Create Calculated Columns
- Sort and Filter PowerPivot Data
- Create and Manage Table Relationships
- Create PivotTables
- Create PivotCharts
- Create Power Views
- Filter Data Using Slicers
- Present PivotTable Data Visually
- Manipulate PowerPivot Data Using DAX Functions
- Extract Data from Tables Using Functions
- Save Reports in Different File Formats
- Work with Time Dependent Data
- Protect Reports
Job roles this course is suitable for:
Account Executive , Account Security Officer , Big Data AnalystAbout Adams Academy
Adams Academy is best known for offering awarding body accredited online courses that are available for anyone who wishes to acquire a certification and take their professional life to the next level. As an online learning site, we are aware of the fact that there are a lot of people out there who considers themselves to be a curious learner but the courses that they are interested in are not available in the area. So, we have decided to give them a chance to learn in a convenient way – in their own convenient place and time.
Our Mission
To make learning more accessible to learning enthusiasts, regardless of where they are residing in the world. To offer different courses of different levels for the students to choose from. To position our company as a leader in the industry of online learning.
Our Vision
Maintain the good credibility and reputation that we have built as online courses provider.
