MrExcel Goes Back to Basics: Excel Tips & Tricks for Oracle Users

with Bill Jelen, MrExcel

Tuesday, June 23 @ 1pm EDT | 10am PDT

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.

 Plus, you can earn 1 CPE credit!

What you'll learn:

• Use XLOOKUP, CONCATENATE, and other everyday formulas to clean and reshape Oracle data
• Apply mass updates across large datasets, like changing ship dates or replacing item numbers, in just a few steps
• Navigate large spreadsheets faster with Freeze Panes and other simple shortcuts
• Catch and correct data issues in Excel before anything reaches Oracle

Who should attend:

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.