Summarize Data in Access, create a dashboard in Excel

  • February 20, 2013 · 6:30 PM
  • This location is shown only to members

This meetup will be intro to Dashboards.  We will take a large set of data, summarize it in Access, pull it into Excel and create pivot tables and charts.   We will use queries for the summarization in Access which will reduce the memory load in Excel and then show a few different ways to get the data into Excel for charting.  The result will be placed on the website for download.

See you there!

Don't forget to visit our website at http://www.free-excel-access-data-clinic.com/

Join or login to comment.

  • Lan

    Thank you for a very informative session!

    March 10, 2013

  • A former member
    A former member

    The free course Harvard is giving in data visualization can, I believe, be found here at http://www.extension.harvard.edu/courses/22872

    February 20, 2013

  • A former member
    A former member

    Thanks everyone so much for coming. I will be posting some info about downloads on the bulletin board, the charts and some VBA are up at http://www.free-excel-access-data-clinic.com/downloads/

    February 20, 2013

  • Linda P.

    Sorry, I am in New Mexico for this one, & Weds are my regular work night, so not sure I will be able to attend Future sessions. A great resource, just wish I lived closer. :-(

    February 16, 2013

16 went

People in this
Meetup are also in:

Create your own Meetup Group

Get started Learn more
Rafaël

We just grab a coffee and speak French. Some people have been coming every week for months... it creates a kind of warmth to the group.

Rafaël, started French Conversation Group

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy