R3,200
Microsoft Office Excel PowerPivot 2016
Candidates will learn how Microsoft Office Excel PowerPivot 2016 enables data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. Among other functions, pivot-table tools can automatically sort, count, total or give the average of the data stored in one table or spreadsheet. It displays the results in a second table (called a “pivot table”) showing the summarized data. Pivot tables are also useful for quickly creating unweighted cross tabulations. A deep dive into the functions in this application in Excel.
Essentials and Intermediate training
1. Make Your Data Work for You
- Maximize the power of Pivot Table
- Ask the questions
- Get the answers
2. A Quick Tour
- Determine what you need to know
- The source is important
- Ready, Set, Go
- The Pivot Table layout
- What goes where
- Result of our Pivot Table
- Viewing our Data differently
3. Manipulating the Pivot Table
- Rearrange the layout
- What we get
- Add a new field
- Remove a field
- Rename a field
- Format Numbers
- Change the Sort Order & Top 10 Autoshow
- Refresh data
4. Digging Deeper
- Create a Quarterly Group
- Group data manually
- Display subtotals
- Hide / Display Grand Total
- Format a Pivot Table report
- Using a Slicer
- Format a Slicer
5. Beyond the Basics
- Creating a Second Data Field
- Use count to Summarize Data
- Display Numerical Data as a Percentage of the Total
- Create a Custom Calculation
- More functions in Custom Calculation
6. More Pivot Table Calculations
- Using Formulas
- Create a Calculated Field
- Create a Calculated Item
- Use Pivot Table Data outside the Report
- Use Get Pivot Data Function
- Turn off Get Pivot Data Function
7. Optional Topics
- Create a Pivot Chart Report
- Publish Pivot Table Reports to the Web
- Use Multiple Ranges as Source Data
Course Days: 1 Day
