R8,700
CompTIA CTT+
CompTIA Certified Technical Trainer (CTT+) certification is for instructors who want to verify they have attained a standard of excellence in the training field. CTT+ validates the knowledge and use of tools and techniques necessary for successfully teaching in today’s learning environments.
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
EXAM CODE TK0-201, TK0-202 & TK0-203
Course Days: 5 Days