Excel - Data Analysis with PivotTables Course

Microsoft Excel Training Online & Onsite

Attend Our Classes From Home - No Software Needed - Learn More...

Microsoft Excel TrainingExcel - Data Analysis with PivotTables

by Certstaffix® Training

Length: 0.5 day(s)      Public Class Price: $335/person (USD)      Group Class Price: Request Quote      Course Category: Microsoft Excel


Microsoft Excel Training
Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.

Upon successful completion of this course, you will be able to use Excel advanced PivotTable functionality to analyze your raw data. You will learn to:
- Prepare data for PivotTable reporting and create PivotTables from various data sources
- Analyze Data Using PivotTables
- Work with PivotCharts


Excel Versions That Can Attend: Excel 2019, 365, 2016, & 2013 (Microsoft Windows PC)
Course Taught With: Excel version 2016 (Microsoft Windows PC) Software and Courseware
Not Appropriate For: Macintosh versions of Excel
Course Description: Print It | Download PDF | Email It

  Public Classes - Live Online at Your Location or OursHow It Works

Certstaffix® Training public classes are instructor-led, live online training you attend from your home or work or in one of our local computer labs. Our live online instructors teach you from a remote location while being able to interact with students as in a traditional classroom setting.

  • A real, live instructor teaching you from another location
  • Hands-on learning with the software/skills you are being taught
  • Interaction with all students in the class at other locations
  • Any needed software for class provided in online lab environment
  • Easy assistance from the instructor

Click a class date below to register & view location/attendance options.

  Group Classes for Organizations - Onsite or Online How It Works

Have a group of employees needing the same training? Onsite training at your office or group live online classes are great solutions.  

  • An expert Instructor will either come to your office or deliver a private live online class to your students
  • Course can be customized to your training needs
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 4 weeks lead time to arrange a training session

  Detailed Course Topics

Course Description: Print It | Download PDF | Email It

Knowledge Pre-Requisites


Course Topics

Lesson 1: Preparing Data and Creating PivotTables
Topic A: Prepare Data
Topic B: Create a PivotTable from a Local Data Source
Topic C: Create a PivotTable from Multiple Local Data Sources
Topic D: Create a PivotTable from an External Data Source

Lesson 2: Analyzing Data by Using PivotTables
Topic A: Summarize PivotTable Data
Topic B: Organize PivotTable Data
Topic C: Filter PivotTable Data
Topic D: Format a PivotTable
Topic E: Refresh and Change PivotTable Data

Lesson 3: Working with PivotCharts
Topic A: Create a PivotChart
Topic B: Manipulate PivotChart Data
Topic C: Format a PivotChart
Course Description: Print It | Download PDF | Email It

Public Class Format

Certstaffix® Training public classes are instructor-led live online training you attend either from your home/work location or in one of our computer labs. Our live online instructors teach you from a remote location while being able to interact with you like in a traditional classroom.


Quality Instructors

Our instructors have many years of experience teaching adult learners in person and online.

Complete Lab Environment

Access to software required is provided in a lab environment during class.

Hands-on Learning

Most classes are not all lecture - you can learn by actually doing.


Small Classes

You get more attention from the instructor and classes flow more smoothly.

Post-Class Lab Access*

Access practice lab environment for 180 days after most classes*.


Low Cancellation Rate

Most classes run as scheduled.



*These courses do not have post-class lab environment access: Adobe, Salesforce, QuickBooks Online Edition, Google, HTML, WordPress, ITIL, Six Sigma, CompTIA, Project Management, SEO, Social Media.


Group Training

Have a group of employees needing the same training? Onsite training at your office or group live online classes are great solutions.

How Group Training Works





  • An expert Instructor will either come to your office or deliver a private live online class to your students
  • Course can be fully customized to your training needs
  • Each student receives a Course Manual with Practice Files (Materials provided before the class date)
  • If a course has a hands‐on lab, we provide access to the configured course software and files.
    (Requires a high‐speed internet connection and certain open ports on your firewall. You can perform a Connection Assessment Test here)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 4 weeks lead time to arrange a training session
  • Training is completed in a convenient session(s) of your choosing
  • Two 15 minute breaks and one hour long break for lunch daily

Request a Free Quote

Excel - Data Analysis with PivotTables Class Reviews

Here are a sample of Microsoft Excel class reviews from past students that have attended our Microsoft Excel training courses.



Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.

Upon successful completion of this course, you will be able to use Excel advanced PivotTable functionality to analyze your raw data. You will learn to:
- Prepare data for PivotTable reporting and create PivotTables from various data sources
- Analyze Data Using PivotTables
- Work with PivotCharts


Excel Versions That Can Attend: Excel 2019, 365, 2016, & 2013 (Microsoft Windows PC)
Course Taught With: Excel version 2016 (Microsoft Windows PC) Software and Courseware
Not Appropriate For: Macintosh versions of Excel


Certstaffix® Class Reviews

Student Average:
4.77 out of 5 from 779 students

4.58 out of 5

Would highly recommend Certstaffix! Classes are VERY thorough and user friendly. :)Bobbye Garrity was awesome. :)


- attended our Excel 2016 Level 2 class

4.35 out of 5

We have a conference room secluded from the public so one can concentrate.


- attended our Excel 2013/2016 - Data Analysis with PivotTables class

5.00 out of 5

very informative


- attended our Excel - Level 1 class

4.55 out of 5

Very clear instructions, do wish the time for trial was a bit more


- attended our Excel - Level 3 class

4.94 out of 5

Today was wonderful! I learned so much! My instructor yesterday not only hasn't marked my course as complete for yesterday and took half the course speaking on micros and creating "buttons" instead of basic coursework needed to make today easier.


- attended our Excel - Level 2 class

4.78 out of 5

This was my third class and by far JoLynn was the best instructor. She was well organized, extremely knowledgeable and professional with her presentation. I would take another class if I know she was teaching.


- attended our Excel - Level 3 class

5.00 out of 5

This was a very interesting and useful class that I will put to work all that I learned today!


- attended our Excel - Level 2 class

4.91 out of 5

This class was amazing! I only signed up for the first one but will definitely see if my company will fund more I learned so many helpful things. It was never overwhelming like I expected from Excel, everything was explained easy and completely.


- attended our Excel 2016 Level 1 class

4.41 out of 5

The resources given after the class were very helpful.


- attended our Excel 2013/2010: Intermediate class

4.50 out of 5

the only problem I had were my own and my computer set up.


- attended our Excel - Level 1 class

4.65 out of 5

The internet connection where 2 individuals are in the same room could be 100% better.


- attended our Excel - Level 1 class

4.48 out of 5

The instructors are very knowlwdgable and took the time to properly answer the questions we all had.


- attended our Excel 2016 - Level 2 class

5.00 out of 5

The instructor was well versed in the subject matter, and he was able to reference the book to lab with ease and simplicity.


- attended our Excel - Level 1 class

4.04 out of 5

The instructor was very knowledgeable. Good sense of humor.


- attended our Excel - Level 1 class

4.70 out of 5

The instructor was very knowledgeable and helpful. I also really liked that they provided physical workbooks for this meeting.


- attended our Excel 2013/2016 - Data Analysis with PivotTables class

4.59 out of 5

The instructor was very kind and helpful and very patient with me. I highly recommend him anytime.


- attended our Excel 2013/2016: VBA Programming class

4.85 out of 5

The instructor was very good. He did present rather fast, but to his credit, he did tell us to slow him down if needed. He interacted well and was good at answering our questions.


- attended our Excel 2016 Level 2 class

4.83 out of 5

The instructor was very good!


- attended our Excel - Level 1 class

4.64 out of 5

The instructor was very friendly and knowledgeable.


- attended our Excel 2013/2010: Advanced class

4.96 out of 5

The instructor was most helpful and took time to assist me when necessary as a Level 1 learner. I really enjoyed the course and will definitely enroll again.


- attended our Excel - Level 1 class

5.00 out of 5

The instructor was fantastic. I will be taking courses 2 & 3.


- attended our Excel - Level 1 class

5.00 out of 5

The instructor was fantastic. She made sure the class was well informed and able to perform and clearly UNDERSTAND the materials. The only negative comment I have is the manuals were not easy to find and harder to download.


- attended our Excel - Level 3 class

4.18 out of 5

The instructor was fantastic and very patient. He helped troubleshoot every issue the group faced whether it was in regard to content or the internet connectivity. I knew most of the information in the basic course, so I am excited to try out the intermediate one and increase my skills.


- attended our Excel 2013/2010 - Basic class

4.91 out of 5

The instructor was extremely knowledgeable on the topics discussed in this course. Very likely to recommend to others. Thank you very much!


- attended our Excel 2013/2010 - Intermediate class

5.00 out of 5

The instructor was extremely helpful and allowed for a flow that enabled us to learn and practice the materials. We are well prepared to practice all the elements we learned on our own after completed this class. I had a few "ah ha" moments, and really appreciated the training and the instructor.


- attended our Excel 2016/2019 - Level 3 class

4.75 out of 5

The instructor was excellent and dynamic. Took command of the course and kept it moving forward.


- attended our Excel - Level 2 class

5.00 out of 5

The instructor was engaging and fun. She made sure to answer all questions thoroughly.


- attended our Excel 2016 Level 2 class

5.00 out of 5

The instructor was awesome!!!


- attended our Excel 2016 - Level 1 class

4.62 out of 5

The instructor was amazing, wish my college professors taught like her


- attended our Excel 2016 Level 1 class

4.80 out of 5

The instructor Kay did an excellent job. Great balance of moving ahead and keeping everyone engaged. The class is real fast moving for the general user and to dig into excel to this level, and I know there is a lot more to know, but this was a lot to digest, one student gasped wow at learning some of the capacities of Excel that is available but not used. Exactly what I was thinking! The material I was taught by your classes demonstrates that I can improve some of the excel worksheets we use for business. That to me is of huge value.Thanks,Jim


- attended our Excel - Level 2 class

4.65 out of 5

The Instructor JoLynn was outstanding! :-)


- attended our Excel - Level 1 class

4.58 out of 5

The instructor JoLynn Rihn is great; I have taken other class with her and was glad she was on this one as well!


- attended our Excel 2013/2016 - Dashboards class

5.00 out of 5

The instructor Jeaneann Perkins is a WONDERFUL instructor. I pray that she is teaching Excel 3. I learned soooo much from her. KUDOS, to a WONDERFUL instructor.


- attended our Excel - Level 2 class

4.83 out of 5

The instructor gave additional tips that were not in the book. He was very knowledgeable and answered everyone's questions in a friendly manner.


- attended our Excel 2013/2010: Basic class

5.00 out of 5

The instructor assisted me after class for 30 min for my actual tasks for my job. He is fantastic !!!


- attended our Excel - Level 2 class

4.94 out of 5

The instructor (Bobbye) was great, kept the class engaged, and was thorough with the material covered and encouraged questions/concerns during the entire time. Would love to have her again for level 2 & 3.


- attended our Excel 2016 Level 1 class

4.74 out of 5

The environment and instructor for this class was amazing!


- attended our Excel 2013/2016 - Dashboards class

4.73 out of 5

The course was laid out in a logical progression. The instructor was very knowledgeable and well qualified to teach the class. He was personable, and very helpful when issues arose. There was a lot of information to move through in the 3 days allotted, but I believe that the information was covered in a thorough and understandable manner.


- attended our Excel 2013/2016: VBA Programming class

4.67 out of 5

The course itself is great, as was the instructor. It's only a struggle when other students delay the class due to lack of understanding (basic computer, internet). My instructor had the patience of Ghandi. She was great.


- attended our Excel 2013/2010 - Basic class

4.96 out of 5

The class was an excellent overview; I would focus more time on charts and tables as those are the ultimate goal of most excel users. The data tables are just a means to an end which is charts, tables, analysis.Even as such, you did a fantastic job.


- attended our Excel - Level 1 class

5.00 out of 5

That was a lot of fun, and very informative. Thank you to Steve Goldberg for helping us out.


- attended our Excel - Level 1 class

5.00 out of 5

thanks for a great class


- attended our Excel - Level 1 class

4.76 out of 5

Thanks Bill - super useful! Looking forward to the Advanced class!


- attended our Excel 2013/2010 - Intermediate class

5.00 out of 5

thank you john


- attended our Excel - Level 1 class

4.97 out of 5

Thank you for share your knowledge and tips


- attended our Excel 2016 Level 3 class

5.00 out of 5

Teacher was very knowledgeable and thorough. She even offered her help after class for any questions that we might have.


- attended our Excel 2016 - Level 2 class

4.84 out of 5

Teacher was excellent very clear, concise communicator and patient with answering questions.


- attended our Excel 2016/2019 - Level 3 class

5.00 out of 5

Steve's expertise and sense of humor made this course extremely enjoyable, as well as informative. He made sure we were all with him at all times, and followed up with us to make sure we completely understood what we were learning.


- attended our Excel 2013/2010 - Intermediate class

4.89 out of 5

Steve was a great instructor, very helpful and his humor kept the class light and enjoyable.


- attended our Excel 2013/2010 - Basic class

4.94 out of 5

Steve Goldberg was great! Great atmosphere! So many new tricks!


- attended our Excel 2016 Level 2 class

4.74 out of 5

Steve Goldberg was EXCELLENT!!!


- attended our Excel 2013/2010 - Basic class

5.00 out of 5

Steve Goldberg was excellent


- attended our Excel - Level 2 class

5.00 out of 5

Steve Goldberg was direct and added humor to the training as well - made the time enjoyable!


- attended our Excel - Level 2 class

5.00 out of 5

Steve Goldberg was a great instructor.


- attended our Excel - Level 2 class

4.13 out of 5

Speed up the introductions (if they are needed at all), start on time, offer to log in early for those that want to test the online classroom lab in advance.


- attended our Excel - Level 1 class

4.74 out of 5

Sherry is amazing, very patient and helpful. I learned a lot of information. I appreciate having this avenue to study. Thank you Sherry.


- attended our Excel - Level 1 class

4.95 out of 5

Serge was fantastic! He really targeted the areas we wanted to learn and his method of teaching was easy and I loved the interaction.


- attended our Excel - VBA Programming class

4.52 out of 5

Serge was excellent and patient to others needing extra assistance, while keeping the rest of the class occupied. He also would periodically look at your screen and give guidance without signaling you out....that his help was towards you....lol


- attended our Excel 2013/2010: Intermediate class

5.00 out of 5

See you tomorrow at the intermediate, and soon the advanced class.


- attended our Excel 2013/2010: Basic class

4.61 out of 5

Recommend 2 screens for the class. One to watch instructor and the other to perform the work.


- attended our Excel - Level 1 class

4.76 out of 5

Really enjoyed having Bill B. for an instructor, his personality and his tone of voice kept my attention. I really liked to do the online activities for EXCEL 2 13 they were extremely important to me, as this is the best way I learn, by hands on training. Bill was more than happy to assist me and he was very helpful.


- attended our Excel 2013/2010: Basic class

4.65 out of 5

Personable instructor...good balance of breaks and work.


- attended our Excel 2016 Level 3 class

4.86 out of 5

Overall a really great informative class. The instructor was very patient with all of her students and was very knowledgeable about the subject. She was always able to answer questions and help out when students had issues.


- attended our Excel 2016 Level 2 class

4.96 out of 5

Our trainer was amazing! I have taken a beginner class both at the community college and another training site and I learned more today then I did with the other classes. I hope that the next class I take, Level 2, will be he same instructor. Thank you!


- attended our Excel - Level 1 class

4.96 out of 5

Our instructor Sherry was nothing but professional and patient with all of the students as we encountered various complications at our individual locations. Her manner of instruction was engaging, personable and very informative. I thoroughly enjoyed this Level 1 class despite already knowing much of what was covered. That is a testament to a great instructor!


- attended our Excel - Level 1 class

5.00 out of 5

none. great course


- attended our Excel - Level 1 class

4.94 out of 5

None, instructor was great!


- attended our Excel 2013/2010 - Basic class

4.91 out of 5

No suggestions from me. I enjoyed the course immensely. Thanks so much!


- attended our Excel - VBA Programming class

4.61 out of 5

Need much more practice and explaining how


- attended our Excel 2013/2010 - Basic class

4.89 out of 5

N/A


- attended our Excel 2013/2010 - Basic class

4.95 out of 5

My instructor, Andrew, was clearly knowledgeable and very helpful. He was willing to stay over breaks and help students with concepts they didn't fully grasp, and was good at fielding questions through the chat function during class. He was also good at time management, and managing students who were experiencing technical difficulties. It was a great class, and I learned.


- attended our Excel 2013/2010: Intermediate class

4.85 out of 5

My experience was a good one. I have no suggestions for any improvements.


- attended our Excel 2013/2010 - Basic class

4.95 out of 5

My company plans to take several more courses, but we will most likely have an instructor to come teach a group because of our connection issues in our building. But I will be recommending the online classes for individuals who use Excel and want to learn more about available features.


- attended our Excel - Level 1 class

4.74 out of 5

Ms. Garrity is not only knowledgeable, but a fun instructor as well. She made the class!


- attended our Excel 2013/2010: Intermediate class

4.62 out of 5

Maybe start with a survey about what sections we want to spend more time on. I found that we spent more time than I wanted on material I already was familiar with and ended up rushing through the material i was most excited about.


- attended our Excel - Level 3 class

4.87 out of 5

Maybe just make sure to identify exactly where you (the instructor) are in the book so the individuals can follow along easier. Otherwise, great class!


- attended our Excel - Dashboards class

4.94 out of 5

Maybe another quick break in the afternoon session. Facility break or a stretch would be great...


- attended our Excel - Level 1 class

4.94 out of 5

Marie at the Dallas TX LBJ location is so helpful, welcoming and pleasant! I would be happy to come back for more training and will recommend to my coworkers.


- attended our Excel 2013/2016: Data Analysis with PivotTables class

4.80 out of 5

log in and testing before the class


- attended our Excel - Level 1 class

5.00 out of 5

Kay was very informative and courteous to all of us in the class. I took part in my home office and was very pleased! I will highly recommend her and the course to others.


- attended our Excel 2016 Level 1 class

4.43 out of 5

Kay was patient and helpful when something did not work.


- attended our Excel 2016 Level 2 class

5.00 out of 5

Joslyn was exceptional! An excellent instructor.


- attended our Excel 2016 - Level 2 class

5.00 out of 5

JoLynn was great! Taught the content very well and created an inviting atmosphere for questions


- attended our Excel 2016/2019 - Level 2 class

5.00 out of 5

JoLynn was a great instructor! She was knowledgeable and very personable. Great content and I know it will help me in my daily work.I will take all my future courses from my home office or office but will not travel to a lab location as it was not worth the hassle. Now that I know I can effectively do it locally, there is no need to have to travel.


- attended our Excel 2016 - Level 1 class

4.71 out of 5

JoLynn was a great instructor


- attended our Excel 2016 Level 3 class

4.78 out of 5

Jolynn Rihn is an excellent instructor and I would look to take other classes from her.


- attended our Excel - VBA Programming class

4.88 out of 5

Jolynn is an excellent instructor - very knowledgeable, patient and thorough. She also had to balance different levels of experience throughout the day. She kept the class moving so we could cover the material.


- attended our Excel 2013/2010: Advanced class

4.73 out of 5

JoLynn did a great job as always, even with the lab version issues, still did great managing through what she was able to show and teach us.


- attended our Excel 2016/2019 - Level 3 class

5.00 out of 5

JoLynn created a perfectly paced class with cogent answers to all inquiries. Thank you!


- attended our Excel - Data Analysis with PivotTables class

5.00 out of 5

Jo was a fantastic instructor! I hope I get her when I take the Level 3 course!


- attended our Excel 2016/2019 - Level 2 class

4.70 out of 5

Janeanne was great! I hope to get her in Excel-3 for the July 24th session. She is very passionate and that is so helpful when learning this type of information. I hope she writes an article or book soon!


- attended our Excel - Level 2 class

4.83 out of 5

Janeann was awesome!I liked the examples done in class


- attended our Excel - Level 2 class

4.82 out of 5

I've been working with Excel for more than decade. I was very impressed that every chapter we covered there was always some gold nugget that Bill provided in addition to the course. I learned a lot!


- attended our Excel 2016 Level 2 class

5.00 out of 5

It would be helpful to have two monitors for this class.


- attended our Excel - Level 1 class

4.67 out of 5

It went very fast and I had a little trouble.


- attended our Excel - Level 2 class

5.00 out of 5

It was very easy to follow. Thumbs up


- attended our Excel - Level 1 class

5.00 out of 5

It was great. I learned a lot of information.


- attended our Excel - Level 1 class

4.53 out of 5

it was great


- attended our Excel 2016 Level 1 class

4.58 out of 5

It was excellent in general.One thing to improve: we went slow in the beginning which obliged us to rush at the end when it was important material. Either expand the time or speed the introduction.


- attended our Excel 2016 - Level 3 class

4.90 out of 5

It was a good class...just a lot of information to pack in one day.


- attended our Excel - Level 1 class



Please contact us if we do not yet have any reviews or you would like more.


View all Microsoft Excel training reviews

Microsoft Excel Courses By City:

       FL - Winter Park       NC - Asheville       PA - York      
- - your home       GA - Atlanta       NC - Charlotte       PR - Puerto Rico      
AL - Birmingham       GA - Augusta       NC - Greensboro       QC - Montreal      
AL - Huntsville       GA - Columbus       NC - Raleigh       RI - Providence      
AL - Mobile       GA - Savannah       NC - Winston-Salem       SC - Greenville      
AR - Bentonville       HI - Honolulu       ND - Bismarck       SC - Myrtle Beach      
BC - Vancouver       IA - Des Moines       ND - Fargo       SC - North Charleston      
CA - Bakersfield       IA - Iowa City       NE - Lincoln       SK - Regina      
CA - Fresno       ID - Boise       NE - Omaha       SK - Saskatoon      
CA - Los Angeles       IL - Chicago       NH - Bedford       TN - Chattanooga      
CA - Merced       IL - Rockford       NJ - Bridgewater       TN - Knoxville      
CA - Modesto       IN - Bloomington       NM - Albuquerque       TN - Memphis      
CA - Napa       IN - Evansville       NM - Las Cruces       TN - Nashville      
CA - Oakland       IN - Fort Wayne       NM - Santa Fe       TX - Amarillo      
CA - Oxnard       IN - Indianapolis       NS - Halifax       TX - Austin      
CA - Rancho Cucamonga       IN - South Bend       NV - Henderson       TX - Beaumont      
CA - Sacramento       KS - Overland Park       NV - Reno       TX - Corpus Christi      
CA - Salinas       KS - Topeka       NY - Albany       TX - Dallas      
CA - San Diego       KY - Lexington       NY - Buffalo       TX - El Paso      
CA - San Jose       KY - Louisville       NY - New York City       TX - Fort Worth      
CA - Santa Maria       LA - Baton Rouge       NY - Rochester       TX - Houston      
CA - Santa Rosa       LA - Lafayette       NY - Syracuse       TX - Killeen      
CA - Stockton       LA - New Orleans       OH - Beavercreek       TX - Laredo      
CB - Caribbean       LA - Shreveport       OH - Cincinnati       TX - Longview      
CB - Kingston       MA - Burlington       OH - Cleveland Heights       TX - Lubbock      
CB - Nassau       MA - Springfield       OH - Columbus       TX - McAllen      
CO - Boulder       MA - Westborough       OH - Toledo       TX - Midland      
CO - Colorado Springs       MB - Winnipeg       OH - Youngstown       TX - San Antonio      
CO - Denver       MD - Largo       OK - Oklahoma City       TX - Tyler      
CT - Cheshire       MD - Laurel       OK - Tulsa       TX - Waco      
CT - New Haven       ME - Portland       ON - Ottawa       UT - Ogden      
CT - Stamford       MI - Ann Arbor       ON - Toronto       UT - Salt Lake City      
DE - Wilmington       MI - Flint       OR - Beaverton       VA - Charlottesville      
FL - Daytona Beach       MI - Grand Rapids       OR - Bend       VA - Glen Allen      
FL - Fort Lauderdale       MI - Lansing       OR - Eugene       VA - Harrisonburg      
FL - Fort Myers       MI - Livonia       OR - Medford       VA - Roanoke      
FL - Gainesville       MN - Minnetonka       OR - Salem       VA - Virginia Beach      
FL - Jacksonville       MO - Columbia       PA - Allentown       VT - Burlington      
FL - Lakeland       MO - St. Louis       PA - Erie       WA - Seattle      
FL - Miami       MS - Biloxi       PA - Harrisburg       WA - Spokane      
FL - Naples       MS - Jackson       PA - Malvern       WI - Eau Claire      
FL - Pensacola       MT - Billings       PA - Philadelphia       WI - Green Bay      
FL - Sarasota       MT - Montana       PA - Pittsburgh       WI - Madison      
FL - Tallahassee       NB - Moncton       PA - Reading       WI - Milwaukee      
FL - Tampa       NB - Saint John       PA - Scranton-Wilkes Barre