Shelly Cashman Excel 2019 Module 8: Textbook Project lilyona martinez 1

Shelly Cashman Excel 2019 Module 8: Textbook Project

lilyona martinez

1. Non-graded - Project: Bell & Rodgers Accounting

2. Line Charts and Trendlines

To Create a 2-D Line Chart

To Format a 2-D Line Chart

To Add a Trendline to a Chart

To Change the Format of a Data Point

3. Creating and Formatting PivotTable Reports

To Create a Blank PivotTable

To Add Data to the PivotTable

To Insert a New Summary Function

To Customize the Field Headers and Field List

To Create a Title

To Update a PivotTable

4. Creating and Formatting PivotChart Reports

To Create a PivotChart Report from an Existing PivotTable Report

To Change the PivotChart Type and Reset Chart Elements

To Change the View of a PivotChart Report

To Create a PivotChart and PivotTable Directly from Data

To Create a Calculated Field to a PivotTable Report

5. Working with Slicers

To Copy a PivotTable and PivotChart

To Add Slicers to the Worksheet

6. Other Excel Charts