Complete EXCEL2013- Chapter 2 Project 1A-1B

EXCEL2013 Chapter 2 Using Functions, Creating Tables, and Managing Large Workbooks

Below are the written objectives.  You can listen and watch the objectives by clicking on Modules Unit 3 Excel.

 Project 2A Inventory Status Report

 Objective 1 Use Flash Fill and the Sum, Average, Median, Min, and Max Functions

Objective 2 Move Data, Resolve Error Messages, and Rotate Text

Objective 3 Use COUNTIF and IF Functions and Apply Conditional Formatting

Objective 4 Use Date & Time Functions and Freeze Panes

Objective 5 Create, Sort, and Filter an Excel Table

Objective 6 View, Format, and Print a Large Worksheet

 Project 2B Weekly Sales Summary

Objective 7 Navigate a Workbook and Rename Worksheets

Objective 8 Enter Dates, Clear Contents, and Clear Formats

 Objective 9 Copy and Paste by Using the Paste Options Gallery

Objective 10 Edit and Format Multiple Worksheets at the Same Time

Objective 11 Create a Summary Sheet with Column Sparklines

Objective 12 Format and Print Multiple Worksheets in a Workbook

Remember to complete the Assignments  in MyITLAB and I will post the grades in CANVAS.