Category: Pivot tables

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.

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…

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…

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…

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

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…

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

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.

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.

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…

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.