Loading…
Attending this event?
THE BEST IBM i & POWER SYSTEMS EDUCATION.When you come to POWERUp, you’ll be able to customize your experience. Choose from 300 sessions, covering over 20 areas of IT, when you plan your schedule. Visit the largest Expo of its kind and meet the experts behind the solutions. Attend social events to meet renowned speakers and peers alike. This conference is structured to give you the pure education and professional connections needed to best enhance your career. Are you ready to POWERUp?

Exhibitor Hall: https://www.expocad.com/host/fx/common/s24/exfx.html

Exhibitor Hall Map Here 
Back To Schedule
Wednesday, May 22 • 4:00pm - 5:00pm
115: Accelerate Your Excel!

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Tweet Share
EVALUATION
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.

Learning Objectives:
After participating in this session, attendees should have the skills and techniques 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
Speakers
avatar for Steve Wolk

Steve Wolk

CTO, PC Richard & Son
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... Read More →

Accelerate your Excel Steven Wolk pdf
Wednesday May 22, 2024 4:00pm - 5:00pm CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  Developing Business Skills
  • Session Level All
  • Award BRONZE
  • 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.

Attendees (17)