Expert Excel Training
This workshop is designed to provide an in-depth understanding of Excel’s Advanced tools and features. Learn how to create a data form to control data input and collect user information with more flexibility. Understand the Data Model approach for integrating data from multiple tables in Excel. Learn how to connect to a new external data source and create a PivotTable using an external data connection. You’ll also use PivotTables to analyze data in multiple tables and Learn how to create relationships between tables. Finally, you’ll learn how to use the data analysis add on Power View to explore, visualize, and present data that encourages ad-hoc reporting.
- Create a form using a variety of controls
- Create and manipulate a PowerView sheet
- Analyze data using multiple tables