addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwchatcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrosseditemptyheartfacebookfolderfullheartglobegmailgoogleimagesinstagramlinklocation-pinmagnifying-glassmailminusmoremuplabelShape 3 + Rectangle 1outlookpersonplusprice-ribbonImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruseryahoo

Create a Function in Excel, A Query in Access

  • Jan 23, 2013 · 6:30 PM
  • This location is shown only to members

Welcome to our first Free Excel/Access Data Clinic Night.  Sign in with meetup or drop us a line and let us know you are coming.  Bring  your problems (and your laptop) and leave with solutions.

Have you ever wished you could write your own Excel function? It’s easier than you think.  Want to reference a column of dates and pull a month name from it?  How about pulling apart a column that has city, state zip all in one text line and pulling those elements out into individual columns?  We’ll go over the basics of making a simple function and using some string manipulation techniques to separate values.

The Access lesson will be on queries.  Have you ever had to try to match two sets of data, like one month versus another in Excel.  We’ll show you how to move the data from a spreadsheet into a table and then use a query to look for matches.  It’s a lot easier than it sounds.

The meeting will be held from 6:30pm to 8:30pm Wednesday Jan 23th, 2013 at 1904 Franklin St.3rd Floor conference room. Oakland, CA 94612
[masked]

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

Join or login to comment.

  • Lan

    Great way to meet other Excel / Access users and learn from each other!

    February 6, 2013

  • Casie M.

    Absolutely excellent, I learned a lot. I appreciated that they used real issues as examples. I thought both teachers with friendly and relatable and completely interested in helping each student.

    January 25, 2013

  • Tamas M.

    Looking forward to next time. Thanks! Access review was very useful.

    January 23, 2013

  • William

    I'll be driving into Oakland. Anything I need to know about parking? Is there a lot, a garage or metered curb spots? Thanks.

    January 23, 2013

    • Dan S.

      There's free street parking after 6pm.

      January 23, 2013

  • A former member
    A former member

    I do not have a laptop. Will I still be able to participate?

    January 16, 2013

    • A former member
      A former member

      Sure Tajalli, you can watch

      January 17, 2013

    • Casie M.

      I'll be watching too! Sorry, I missed this part of the explanation.

      January 23, 2013

  • A former member
    A former member

    Good question, Tajalli. I guess I will be a watcher, too!

    January 17, 2013

16 went

People in this
Meetup are also in:

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