Icons & text

  • Icon & text

    Use an icon and text to communicate the value proposition and share the specific benefits of your offering. What makes it unique in your market?

  • Icon & text

    Use an icon and text to communicate the value proposition and share the specific benefits of your offering. What makes it unique in your market?

  • Icon & text

    Use an icon and text to communicate the value proposition and share the specific benefits of your offering. What makes it unique in your market?

Course curriculum

    1. Downloadable Workbooks

    2. New Intermediate Pivot Table Videos - Uploaded 02.2020

    3. Cheat Sheet - 5 Speedy Steps to an Excel Pivot Table

    4. Cheat Sheet - The Top Pivot Table Features

    1. Setting Up Your Data - Tabular Format

    2. No Gaps in your data

    3. Formatting your data

    4. Excel Tables

    5. Clean Your Data Set

    6. Inserting a Pivot Table

    7. Field List - Activate, move, resize & layout

    8. Field List & Areas

    9. Drill down to audit

    10. Sort Field List from A to Z

    11. Double click on any labels to show more Fields

    12. Defer Layout Update

    13. Pivot Cache explained

    14. Refresh a Pivot Table

    15. Clear Filters & Clear Pivot

    16. Select & format

    17. Move a Pivot Table

    18. Pivot Table Styles

    19. Customize Pivot Table Styles

    20. Pivot Table Subtotals

    21. Pivot Table Grand Totals

    22. Pivot Table Report Layouts

    23. Pivot Table Blank Rows

    24. Expand & Collapse buttons

    25. Move & Remove Fields and Items

    26. Show/Hide Field List

    27. Show/Hide Field Headers

    28. Change Count of to Sum of

    29. Number formatting

    30. Field name formatting

    31. Change Sum views in Label Areas

    32. Indent rows in compact layout

    33. Change the layout of a report filter

    34. Format error values

    35. Format empty cells

    36. Printing a pivot table on two pages

    37. Show Report Filter on multiple pages

    1. Create multiple subtotals

    2. Count

    3. Average

    4. Maximum

    5. Minimum

    6. Product

    7. Count Numbers

    8. Show Various Grand Totals

    9. Shortcuts to access Value Field Setting & Summarize Values By

    1. Percentage of Grand Total

    2. Percentage of Column Total

    3. Percentage of Row Total

    4. Percentage Of

    5. Difference From

    6. Percentage Difference From

    7. Running Total In

    8. Percentage Running Total In

    9. Shortcuts to Show Values As

    10. CASE STUDY: Actual v Plan Variation

    1. Group by Days

    2. Group by Months

    3. Group by Quarters & Years

    4. Group by Sales ranges

    5. Group by Text fields

    6. Group by Time

    1. Sort by Largest or Smallest

    2. Sort an Item Row (Left to Right)

    3. Sort Manually

    4. Sort using a Custom List

About this course

  • Free
  • 115 lessons
  • 4.5 hours of video content

Pricing options

Explain how different pricing options might be valuable to different segments of your audience.

Call to action

This is where you seal the deal. Sprinkle this section throughout you page to push prospects to purchase!

Get started now