COMMON POWERUp 2021

Many IBM i programmers and operators don’t use Microsoft Excel, but must support business users who want custom data sets to study and share in Excel. Your value to your company and the respect you get from the business people you support will rise if you take the time to understand more about Excel, what your user community needs, and how best to deliver the data they require. This is not a session on configuring middleware. This is a quick run through Excel from the perspective of the people who use it and will help you understand how Excel imports files.

Learning Objectives:
Learn what file formats and delivery methods will help the users you support and save you time. _x000D_ _x000D_ You will see step-by-step how to use Excel's file import features with various types of file formats and how to automate refreshes of the visualization objects used to analyze that data.