Skill Review $9\mathrm{.}2$

In this project, you will create a summary worksheet to consolidate sales data from different regions. You will import addresses from a text file and manipulate the imported data.

Skills needed to complete this project:

Consolidating Data in a Summary Worksheet $($Skill $9\mathrm{.}9)$

Adding Data Validation $($Skill $9\mathrm{.}6)$

Inserting Links $($Skill $9\mathrm{.}11)$

Working with Comments $($Skill $9\mathrm{.}10)$

Importing Data from a Text File $($Skill $9\mathrm{.}2)$

Inserting Data Using Flash Fill $($Skill $9\mathrm{.}4)$

Converting Data to Columns $($Skill $9\mathrm{.}5)$

Protecting Worksheets and Workbooks from Changes $($Skill $9\mathrm{.}12)$

Checking for Accessibility $($Skill $9\mathrm{.}17)$

Finalizing the Workbook $($Skill $9\mathrm{.}18)$

Alternate Instruction for Microsoft $365$ Apps iconThis image appears when a project instruction has changed to accommodate an update to Microsoft $365$ Apps. If the instruction does not match your version of Office, try using the alternate instruction instead.

Important: Download the resource files needed for this project from the Resources link. If they download in a zipped folder, make sure to extract the files after downloading the resources zipped folder. Visit the SIMnet instant help for step$-$by$-$step instruction.