Microsoft Dynamics (GP User Group) GPUG New York/New Jersey Regional Chapter Meeting (Jun 2013)
Join us for the next New York/New Jersey Regional Chapter meeting on June 12 from 9:00am to 12:30pm!
We want to make sure you're taking advantage of everything you can to help you use your Dynamics GP application better. Not a GPUG Member? Join us to see what all the excitement is about.
Meeting date and time: Wednesday, June 12, 2013 from 9:00am to 12:30pm EST. (Please note that event registration defaults to EST. Please adjust your calendars accordingly.)
Agenda:
- 9:00 - 9:15: Welcome & Introductions
- 9:15 - 9:30: GPUG Collaborate
- 9:30 - 10:30: 10 GP 2013 cool new features worth upgrading for (Anne-Claire McAlister, Accountnet)
- 10:30 - 10:45: Break & Networking
- 10:45 - 11:30: Intro to BI and GP (Belinda Allen, Smith & Allen Consulting, Inc.)
- 11:30 - 12:15: Regional Chapter Leadership: Why, How, Who
- 12:15 - 12:30: Wrap-up and discussion of desired Quarter 3 meeting topics
Audience: All Dynamics GP users and prospects are welcome and encouraged to attend. Members of the GPUG Partner Program are also welcome to attend provided they are accompanied by a customer. Partners please bear in mind that the objective of Regional Chapters is to exchange knowledge and Dynamics GP experience. Partner personnel should possess deep GP expertise and refrain from sales activities.
About Regional Chapters: Regional Chapters enhance your membership in GPUG by offering face-to-face interaction and knowledge-sharing with other Microsoft Dynamics GP users in your region. By having meetings centrally located within your region, users from all job roles and levels in your company can participate by only driving a short distance. Join us so you can optimize the functionality, flexibility, performance and return on investment offered by GP and get better results from your GP implementation back home. Feel free to invite GP colleagues and other users within the region. Remember, a membership in GPUG includes ALL employees at your company. For more information about GPUG, visit www.gpug.com.
Don't miss being a part of this exciting meeting established solely for the purpose of face-to-face networking and knowledge sharing of GP Users in our area!
Location Details
Microsoft Office
1290 Avenue of the Americas 6th floor
New York, NY 10104
Registration Costs
Basic Membership Cost: $20.00
Premium Membership Cost: FREE
Belinda (the GP CSI) AllenBelinda@saci.com917-445-9070
Below is an exert from a future "Tech Tips" that I wrote for the Microsoft Dynamics GP User Group (GPUG) to send to it's members. If you are not a member, you should review membership.
What are Excel Data Limitations?
Which version of Excel should you use?
You’ll want to be on Excel Version 2007 or 2010. Why? Column and row capacities in older versions cannot accommodate some of the files. Below is a table that shows size limitations of various versions of Excel. You’ll see that Excel 2007 and Excel 2010 have much larger row and column maximums than the older versions.
You should always work with supported versions of software; this includes both GP AND Excel.
|
Version
|
Max. Rows
|
Max. Columns
|
Max Columns by letter
|
|
Excel 2010
|
1,048,576
|
16,384
|
XFD
|
|
Excel 2007
|
1,048,576
|
16,384
|
XFD
|
|
Excel 2003
|
65,536
|
256
|
IV
|
|
Excel 2002 (XP)
|
65,536
|
256
|
IV
|
|
Excel 2000
|
65,536
|
256
|
IV
|
|
Excel 97
|
65,536
|
256
|
IV
|
|
Excel 95
|
16,384
|
256
|
IV
|
|
Excel 5
|
16,384
|
256
|
IV
|
Over a million records sounds like a lot, but it still might not be able to handle your needs, so you’ll need to address your Excel needs differently. Let’s review some options:
What is the difference between an Excel Table and an Excel Worksheet
Think of a table as being an “Excel Database.” In an Excel worksheet, you can put a single record on many lines if you like (like the following).
A table will be setup so each row is one complete record and each record is only on 1 row (like the following.)
Both of the above examples provide the same information, but by placing the data in a table rather than a worksheet:
- Excel will apply default formatting to any new data added.
- Excel will automatically apply the Filter setting. The headings for filters will remain when you scroll down.
- You can easily add totals to the bottom with the check box in the Table Tools Design tab.
- If you create a formula in a column, new data rows will have the formulas automatically copied to the new record. (This is a powerful feature if you use a calculated column in a Pivot Table.) This also means Pivot Tables will automatically capture the new data as well.
Understanding and using Tables is an important and necessary element to Excel Reporting.
Belinda (the GP CSI) AllenBelinda@saci.com917-445-9070
Come see me in person discuss SmarList Builder and Excel Builder at the (Microsoft Dynamics GP) GPUG regional meeting Tuesday, 11/27/12 at the Microsoft Office in Manhattan, New York.
Please join us for the next meeting of the GPUG NY/NJ Regional Chapter on
Tuesday, November 27, 2012 from 8:30am - 12:00pm EST. We're planning a great
meeting at the Microsoft office in Manhattan. Don't miss this exciting opportunity
for face-to-face networking with your peers and fellow GP users in your area.
|
|
| |
|
8:30 - 9:00am
|
Welcome & Introductions
|
|
9:00 - 10:00am
|
SmartList Builder
|
|
10:00 - 10:20am
|
Break & Networking
|
|
10:20 - 10:40am
|
SmartList Builder - Customer Examples
|
|
10:40 - 11:45am
|
Excel Builder & Navigation Builder
|
|
11:45 - 12:00pm
|
Planning of Next Meeting
|
Meeting Location:
Microsoft Office
1290 Avenue of the Americas - 6th Floor
Room: Belasco
New York, NY 10104
Registration Costs:
Basic Members: $20.00
Premium Members: FREE
|
Belinda (the GP CSI) AllenBelinda@saci.com917-445-9070