Apps 2-T

Day #2 – Excel Project #7 – Creating Templates, Importing Data, and Working with Smartart, Images, and Screenshots

Create a Template with sample data and formulas
Use a Template to create a new workbook
Import and format outside Data into an Excel workbook
use the Quick Analysis gallery to create totals and charts easily.
Find and Replace data
Insert and format a Bar Chart
Create and format a Smartart graphic to display pictures and text
Add a hyperlinked Screenshot

Chapter Directions – High School Analysis
Lab #1 – Custom Fragrances