Course description : Learn advanced formulas and work with various tools to analyze data in spreadsheets. Organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.
Category: Productivity & Software
Price: $130.00
Target audience: All Faculty, Managers and Staff who are interested in learning skills to create and modify Excel workbooks.
By the end of the workshop participants will:
Create and Work with Pivot Tables
- Understanding PivotTables
- Working with Recommended PivotTables
- Creating a PivotTable using Worksheet Data
- Creating a PivotTable using an External Data Connections
- Laying out a PivotTable on a Worksheet
- Modifying PivotTable Fields
- Using a Report Filter
- Refreshing a PivotTable
- Formatting a PivotTable
Enhancing PivotTables
- Sorting Items in a PivotTable
- Creating a Slicer
- Grouping Data
- Using a Timeline
- Applying Label and Value Filters
- Creating a Calculated Field
- Creating a Calculated Item
- Creating Charts from PivotTables