Course curriculum

    1. Introduction to PivotTables

    2. Courseware Instruction

    1. Handling Gaps, Missing Values, and Duplicates

    2. Creating PivotTables

    3. Utilizing PivotTable Recommendations

    4. Efficient Methods for PivotTable Creation

    1. Customizing the PivotTable Fields List

    2. Adding Row Headers

    3. Adding Column Headers

    4. Incorporating Values into Your PivotTable

    5. Applying Filters to Your PivotTable

    1. Rearranging Headers

    2. Adding Depth to Headers

    3. Enhancing Layers in the Value Section

    1. Modifying Summaries and Display Values

    2. Introducing Calculated Fields

    3. Incorporating Calculated Items

    4. Grouping Date/Time Data

    5. Grouping Other Data Points

    1. Formatting Numerical Data

    2. Implementing Conditional Formatting

    3. Exploring PivotTable Templates

    4. Enabling Subtotals and Grand Totals

    5. Adjusting Report Layouts

    6. Exploring Field Settings

    7. Exploring PivotTable Options

About this course

  • $29.99
  • 34 lessons
  • 1.5 hours of video content

Discover your potential, starting today

Enroll today