Most Oracle users spend more time in Excel than anywhere else — cleaning up exports, prepping data for uploads, or building quick lookups to fix what's broken. And yet, we all have a tendency to overcomplicate it. This session is a reset.
Bill Jelen, better known as MrExcel, brings his signature tips-and-tricks style to an Oracle context. Using real Oracle data scenarios, including Sales Orders and GL Journals, MrExcel will show you how a handful of simple Excel techniques can save you hours of manual work every week.
No deep ERP knowledge needed. No advanced Excel wizardry. Just the basics done right and put to work on the data you deal with every day. Plus, you can earn 1 CPE credit!
Any Oracle user who works with data in Excel — finance, operations, order management, or anywhere in between. If you've ever spent too long wrangling a spreadsheet, this one's for you.
Learning Objectives:
- Apply XLOOKUP, CONCATENATE, and other everyday Excel formulas to clean, reshape, and validate Oracle data exports for accuracy before upload.
- Operate mass update techniques in Excel to efficiently modify large Oracle datasets — such as ship dates or item numbers — in just a few steps.
- Practice navigation and productivity shortcuts, including Freeze Panes, to work faster and more confidently in large Oracle-sourced spreadsheets.
Educational Tracks:
#CloudERP
#E-BusinessSuite
#ProfessionalDevelopment
Presenter:
@Bill Jelen, Excel Guru, MrExcel.com
Sponsored By:
More4Apps