Data Import & Export in Excel

Purchase Tickets at Eventbrite.com (https://www.eventbrite.com/e/data-import-export-in-excel-tickets-27042410578)

As finance and accounting professionals we sometimes have to work with data from different sources such as various internal databases and systems, the internet etc. Files may be formatted differently which makes integration challenging. The data often has to be manipulated or converted.

Excel provides multiple tools to import & export data which will be covered in this class.

Presented by: Experienced Excel user - Jason Bradfield, Roger Nakayu and Stephen Tin

Session will cover:

· Using Power Query to import data

· Using Power Query to manipulate data

· Importing data formatted in txt, csv, xlsx etc.

· Pivoting data from external sources

· Formatting data into tables

· Importing tips and tricks

This is a hands-on knowledge sharing session. Bring your own laptop to follow along.

***No computer is provided by the organizer. ***