Event box

Excel: Get External Data

Excel: Get External Data

You can connect Microsoft Excel directly to web and other databases such as Microsoft Access, Microsoft SQL Server, Oracle, and UBInfoSource. Refresh data on demand for your interactive reports and dashboards.

Related LibGuide: Computer Science by Jill Hackenberg

Date:
Tuesday, November 27, 2018
Time:
9:00am - 4:00pm
Location:
310 Silverman
Campus:
North Campus
Categories:
  All Workshops  

This workshop is designed to bring novice users to proficient on covered topics.

 

Topics include:

  • QueryTables
  • Web Queries
  • Open Database Connectivity (ODBC)
  • Introduction to SQL and SQL Queries

 

This is the final session in a full week of data workshops given by internationally recognized experts presented by  the University Libraries.

 

Workshops are offered at no charge to UB faculty, staff and students. All workshops in this series will be presented in room 310 of Capen

 

Hall inside Silverman Library. Bring your laptop, as this room is not equipped with workstations.

 

Co-sponsored by The Graduate School.

Event Organizer

Profile photo of James Gordon
James Gordon

More events like this...