Category: Pivot tables

  • Advanced Excel 7-26-2015

    I’m pleased to announce the two files from the Advanced Excel workshop on 7-26-2015 are now available to practice with: Advanced Excel 7-26-2015 a Advanced Excel 7-26-2015 b

  • Advanced Excel 4-25-2015

    I’m pleased to announce the file created during the Advanced Excel workshop on 4-25-2015 is now available to practice with.  Here is the link:  Advanced Excel 4-25-2015.

  • 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: creating pivot tables working with pivot table fields modifying pivot table layout linking a chart to your pivot table changing data values and…

  • Advanced Excel 10-25-2014

    Below are the files developed during Saturday’s 10/25/2014 Advanced Excel workshop. You can use the files to review the activities covered in class: nested if functions, pivot tables, name range references, pivot charts, mail merge, macros, pivot table sorting, filtering, and grouping. advanced excel 10-25-2014 (1) advanced excel 10-25-2014 (2) advanced excel 10-25-2014 (3) advanced…

  • Advanced Excel 8-9-2014

    Below are links to the files developed in the advanced excel class. It has been provided so you can review the work done in class. Summarizing data with Pivot Tables Group feature with Pivot Tables Formulas and nested functions Linking cells: name range/name box and hyperlinks Nested conditional functions Creating macros and buttons Creating a…

  • Advanced Excel 6-28-2014

    Below is a link to the file developed in the advanced excel class. It has been provided so you can review the work done in class. Summarizing data with Pivot Tables Group feature with Pivot Tables Formulas and nested functions Linking cells: name range/name box and hyperlinks Nested conditional functions Advanced-Excel-6-28-14

  • Advanced Excel 3-15-2014

    I’m pleased to announce below is the link to the worksheet developed during the Saturday workshop on 3-15-2014.  You can use it to review the activities covered in class: Creating a customized drop down list menu Using normal view, page layout view, page break view Saving as PDF Recording a Macro to automate repetitive tasks…

  • Advanced Excel 10-19-2013

    Below is the link to the file developed in the advanced excel class: Advanced Excel 10-19-2013 It has been provided so you can review the work done in class. Recording a Macro Summarizing data with Pivot Tables Formulas and functions Linking with cell references:  absolute, relative, name range Nested conditional functions

  • Advanced Excel 6-22-2013

    Below are links to the three files developed in the advanced excel class: Advanced Excel 6-22-2013 vehicle, shoes, grade book Advanced Excel 6-22-2013 scuba ratings in pivot table Advanced Excel 6-22-2013 links They have been provided to review the work done in class. Recording a Macro Review vlookup Summarizing data with Pivot Tables Links using…

  • Advanced Excel 5-5-2013

    Below are two files developed in the second class. advanced excel 5-5-2013 macro and what if analysis advanced excel 5-5-2013 various examples They have been provided to review the work done in class. Recording a Macro Review vlookup What if analysis pmt(   ) function

  • Advanced Excel 4-28-2013

    Below is the file developed in class. Advanced Excel 4-28-2013 It has been provided so you can practice the exercises done in class: Working with a pivot table Showing details Using name ranges Grouping Filtering pivot table results Interpreting pivot table results Nested functions Shortcuts Linking worksheets Pasting name range Refreshing pivot table and chart…

  • Advanced Excel 4-7-2013

    Below is the link to the file developed in class: Advanced Excel 4-7-2013 It has been provided so you can practice the exercises done in class. It contains macros, a pivot table, and a custom Excel function created with VBA.

  • Advanced Microsoft Excel 2010 (3-17-2013)

    I am pleased to announce below is the link to the “30 Year Interest Rate” file developed in class: Advanced Excel 3-17-2013 It has been provided so you can practice the exercises done in class. It contains macros, a pivot table, conditional formatting, date and conditional functions.

  • Advanced Microsoft Excel 2010 (11-10-2012) – Day 2 of 2

    I am pleased to announce below are the links to the files developed in class during “Day 2 of 2”: Advanced-Excel 11-10-2012-a (day 2 of 2) Advanced-Excel 11-10-2012-b (day 2 of 2) Advanced Excel 11-10-2012 custom function and two macros (day 2 of 2) They have been provided so you can practice the exercises done…

  • Advanced Microsoft Excel 2010 (10-27-2012) – Day 1 of 2

    It was nice working with everyone in the Continuing Education workshop.  Below are the links to the files developed in class: Advanced Excel 10-27-2012 a Advanced Excel 10-27-2012 b custom function It has been provided so you can practice the exercises done in class.