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 excel 10-25-2014 (4)

Mail Merge Example – xlsx file

Mail Merge Example – docx file

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.

1. Summarizing data with Pivot Tables
2. Group feature with Pivot Tables
3. Formulas and nested functions
4. Linking cells: name range/name box and hyperlinks
5. Nested conditional functions
6. Creating macros and buttons
7. Creating a macro for a specific purpose

Advanced Microsoft Excel 8-9-2014

Advanced Microsoft Excel 8-9-2014 macro examples

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:

1. Creating a customized drop down list menu
2. Using normal view, page layout view, page break view
3. Saving as PDF
4. Recording a Macro to automate repetitive tasks
5. Summarizing data with Pivot Tables
6. Linking with cell references:  absolute, relative, name range
7. Applying nested conditional functions

File developed in the advanced excel class:  Advanced Excel 3-15-2014.

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.

1. Recording a Macro
2. Summarizing data with Pivot Tables
3. Formulas and functions
4. Linking with cell references:  absolute, relative, name range
5. Nested conditional functions

Below are links to the three files developed in the advanced excel class:

1. Advanced Excel 6-22-2013 vehicle, shoes, grade book
2. Advanced Excel 6-22-2013 scuba ratings in pivot table
3. 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 hyperlinks and name ranges

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”:

1. Advanced-Excel 11-10-2012-a (day 2 of 2)
2. Advanced-Excel 11-10-2012-b (day 2 of 2)
3. 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 in class.

It was nice working with everyone in the Continuing Education workshop.  Below are the links to the files developed in class:

1. Advanced Excel 10-27-2012 a
2. Advanced Excel 10-27-2012 b
3. custom function

It has been provided so you can practice the exercises done in class.