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
Don't forget to visit our website at http://www.free-excel-access-data-clinic.com/