1-516-468-9465 " class="button button_default large" target="_self">Give us a Call!

Posts filed under: Advanced Excel

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...
Continue Reading →

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....
Continue Reading →

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...
Continue Reading →

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,...
Continue Reading →

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...
Continue Reading →

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...
Continue Reading →

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...
Continue Reading →

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...
Continue Reading →

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...
Continue Reading →

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...
Continue Reading →

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...
Continue Reading →

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....
Continue Reading →

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...
Continue Reading →

Advanced Microsoft Excel 2010 (12-2-2012)

I am pleased to announce below is the link to the “Baseball Stats” file developed in class: Advanced Excel 12-2-2012 It has been provided so you can practice the exercises done in class....
Continue Reading →

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...
Continue Reading →

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...
Continue Reading →

Advanced Microsoft Excel 2010 for Windows workshop (7-29-2012)

It was nice working with everyone in the Continuing Education workshop. Here is the link to the file we developed in class:  Advanced Excel 7-29-2012. It has been provided so you can practice the materials created in class....
Continue Reading →

Advanced Microsoft Excel 2010 for Windows workshop

It was nice working with everyone in the Continuing Education workshop. Here is the link to  the file we developed in class:  Advanced Excel 5-20-2012. It has been provided so you can practice the materials created in class....
Continue Reading →