Welcome back!
WMSUG will hold a regular meeting on Wednesday March 19th, beginning with a presentation at 8:30AM.
** Note - Available exclusively via the web
** Note - This is a "Turn your Web Camera On" event ***
** Meeting access information will be sent a day prior to the event **
"Accelerate your Excel!" by Steven Wolk, Chief Technology Officer, PC Richard & Son:
Are you intimidated by spreadsheets? Do you use Excel for the basics, but know you could be so much more productive with it if only you knew how? Do you cringe when other business people within your company ask for data in spreadsheet form? Excel is a wonderful tool, especially when paired with the IBM i! It's incredibly powerful, and can save you lots of time. This session will begin with the basics and then progress through more advanced Excel topics such as functions, pivot tables, and array formulas. Using real life examples, you'll see how these new skills will help you in your career. Finally, we'll review powerful methods of pulling data from your IBM i directly into Excel spreadsheets! You'll even leave with sample code you can leverage within Excel to give you one click access to run an SQL statement from your desktop, and have the results returned in a spreadsheet. After each of the 25 topics covered, we’ll review by playing Excel Bingo, for prizes! Learn some great new Excel skills, have some fun, and maybe leave with a prize!
Learning Objectives: After participating in this session, attendees should have the skills and tools to:
- Understand the benefits of using Excel
- Use spreadsheets to improve your own productivity as well as that of your company
- Pull data from your IBM i directly into a spreadsheet in a variety of ways
Audience:
- Anyone who has ever had to work with a spreadsheet will benefit from the skills gained during this session. We will start with the basics, but even experienced Excel users will find useful information in this session.
This month's meeting is being held exclusively via the web!
- To receive the Web Meeting connection information for this meeting, join our mailing list.
- Click the e-mail me icon and ask our Secretary/Treasurer to add you to our E-mail list.
Please call 616-261-6656 if webinar connection problems develop.
About the Presenter:
Steven Wolk is the Chief Technology Officer for PC Richard & Son, a family owned and operated chain of 66 appliance and electronics superstores located throughout NY, NJ, CT, and PA. Founded in 1909, PC Richard has always been known for honesty, integrity, and reliability throughout it's over 113 year history. Steve joined PC Richard & Son in 1986. In 2000, after working his way through a number of IT related roles, he assumed his current position as the company’s first CTO. As CTO, he considers himself very fortunate to lead a large in-house team of very talented software developers. Together, they bring their combined extensive retail experience to bear in the application of new technologies to improve business processes and efficiency to create a competitive advantage for this unique company. Steve is an IBM i zealot and advocate, and is deeply involved in the IBM i community. He’s very proud to be an IBM Power Systems Champion since 2020. Steve is a long-standing speaker at COMMON conferences, a subject matter expert, a member of COMMON’s Strategic Education Team, and speaks at IBM i related conferences globally. He is also a former member of the board of directors for The LUG (Large User Group), a group of over 100 of the world’s largest users of IBM technology, most recently serving as the Communications Officer. Steve is also Vice President and a board member of LISUG, the Long Island Systems User’s Group, and enjoys his role as emcee of LISUG’s monthly educational and networking events. Steve enjoys mentoring through a variety of organizations, including LISUG, COMMON, and NPower.
Date / Location
Date: Wednesday March 19th, 2025
Time: 8:30 AM presentation
Place: *** Note - available exclusively via the web ***
Note: Meeting access information will be sent a day prior to the event
E-mail list for Meeting Notices and Web Meeting:
Click the e-mail me icon and ask our Secretary/Treasurer to add you to our E-mail list.
Membership: The 2024-2025 Season Continues
Review the list of paid memberships. Download and complete the self-service invoice form for your company. Thank you for your support.
If you wish to stop receiving E-mail from WMSUG:
Click on the "e-mail me" icon and specify your changes for our Secretary/Treasurer.
** END of POST **
