Microsoft SharePoint Automation and Integrations

Course | September 26 | 1:30-3 p.m. |  Virtual Classroom

 Human Resources

This course details the process of integrating Microsoft Office applications with SharePoint Site data. Emphasis is placed on automation, connection settings, and real time data feeds between SharePoint Sites and the Microsoft Office suite. Learning Objectives * Understand the underlying structure and hierarchy of Sites, Subsites, and Apps. * Create and assign automated Alerts to notify users of real-time data changes. * Review standard SharePoint Apps with preexisting automation functionality. * Establish live SharePoint App data connections to Microsoft Excel Tables, PivotTables, and PivotCharts. * Query SharePoint App data using the Microsoft Excel Query Editor. * Perform Microsoft Word and Microsoft Publisher Mail Merges using SharePoint records and Excel staging Tables. * Link Microsoft Access databases to live SharePoint Apps for analysis, reporting, and Macro automation. * Design interactive Visio diagrams using Shapes linked to SharePoint App records. * Explore the integrations of SharePoint task management with Microsoft Project.

  Register online

 ksamsell@berkeley.edu