Franklin 7107

This course supports analysts and advanced business users who must combine data from various sources, shape it through pivots or aggregations and sort it into groups or similar values prior to analysis.

If data visualization is important to your work, attend this hands-on workshop of Tableau Desktop! See demos of Tableau visualizations; connect to your data with Tableau Data Extract; learn to create hierarchies, formatting and aggregation and create worksheets, analytics, maps, interactive dashboards and more.

In this course for intermediate to advanced Excel users, learn how macros can make quick work of repetitive, complex tasks in Excel. The workshop will also include an introduction to virtual basic for applications (VBA) to further customize the macros you create.

Get an overview of Box.com, the cloud-based service that provides secure file storage and file sharing. Learn Box basics, including how to use Box to collaborate with people within and outside of UCOP and tips for commenting directly on files, folder permissions, shared links and more.…

Discover how Excel can expand your productivity with techniques including data entry, functions, managing lists through tables, sorting and filtering, visualizing data and more.