Easy Excel Learning

Juan Hinojosa, Technologist and Math Instructor

Category: Pivot Tables

  • Intermediate Excel 3-24-2015

    It was a pleasure working with the class!  Below is a link to the Excel workbook developed during the workshop.


    Merrick Intermediate Excel 3-24-2015

    You can use the file to review the activities covered in class: pivot table/pivot chart, sorting, filtering, and creating a Gantt chart.

  • Excel Pivot Table workshop 12-13-2014

    I’m pleased to announce below is the link to the worksheet developed during the Saturday workshop on 12-13-2014. You can use it to review a few of the activities covered in class:

    1. creating pivot tables
    2. working with pivot table fields
    3. modifying pivot table layout
    4. linking a chart to your pivot table
    5. changing data values and refreshing your pivot table
    6. adding a slicer and timeline tool to your pivot table to enhance interactivity

    PivotTables 12-13-2014