Shelly Cashman Excel 2019 Module 7: Textbook Project Nicholas White 1

Shelly Cashman Excel 2019 Module 7: Textbook Project

Nicholas White

1. Non-graded - Project: Meyor Insurance

2. Creating Templates

To Open a Blank Workbook and Format the Rows and Columns

To Enter Titles in the Template

To Enter Column Titles in the Template

To Enter Formulas and Functions in the Template

3. Importing Data

To Import Data from a Text File

To Import Data from an Access Table

To Import Data from a Webpage

To Copy from Word and Paste to Excel

To Replicate Formulas

4. Using the Quick Analysis Gallery

To Format Using the Quick Analysis Gallery

To Total Data

5. Using the Find and Replace Commands

To Find and Replace Text

To Format Styles and Borders

6. Inserting a Bar Chart

To Insert a Chart Using the Quick Analysis Gallery

To Format the Chart

To Format the Chart Title

7. Working with SmartArt Graphics

To Create a New Worksheet

To Color and Resize the SmartArt Graphic

To Apply Picture Effects

8. Non-graded - Pictures and Icons

9. Text Boxes

To Draw a Text Box

10. Non-graded - Alternative Text

11. Non-graded - Objective Linking and Embedding

12.Using Screenshots on a Worksheet

To Create Another New Sheet

To Move an Object

To Add a Picture Border

13.Shapes