Shelly Cashman Excel 2019 Module 5: Textbook Project Madison Stroud 1

Shelly Cashman Excel 2019 Module 5: Textbook Project

Madison Stroud

1. Non-graded - Project: Consolidated Expenses Worksheet

2.Creating the Consolidated Worksheet

To Apply a Theme

To Format the Worksheet

To Enter the Title, Subtitle, and Row Titles

3. Date, Time, and Round Functions

To Format the Title and Subtitle

To Format a Cell with a Floating Dollar Sign

To Use the TODAY Function

4.Format Codes

To Apply the Comma Cell Style

5. Creating a Cell Style

To Create a New Cell Style

To Apply a New Cell Style

6. Non-graded - Working with Multiple Worksheets

7. Referencing Cells Across Worksheets

To Enter a 3-D Reference

To Use the Paste Gallery

8. Formatting Pie Charts

To Insert a 3-D Chart in a Worksheet

To Explode a Slice

To Format Data Labels

9. Non-graded - Creating Separate Files from Worksheets

10. Non-graded - Consolidating Data by Linking Separate Workbooks