-
Bell Ringer: Log in to 1. Network, 2.Gmail, Open Excel spreadsheet (Step-by-Steps pages 9-14)
- WINDOWS 7 VIDEO
- About Me Document
- Review Windows 7 Terms
- Windows 7 Terms
- Excel Lesson 2 Notes
- Key Terms 27
- Creating workbooks 29, Saving Workbooks 31, Organization File Conventions 32
- Entering and Editing Basic Data in a Worksheet 38
-
Open "Customers" - Review Lesson 1 & 2 Notes
- Review Lesson 2 Notes / Con't L2
- Using Data Types to Populate a Worksheet 43
- Cutting, Copying, and Pasting Data 50
- Editing a Workbook’s PROPERTIES 54
- Complete Lesson 2 Projects 2-1 to 2-5
ASSIGNMENT: Windows 7 Terms , Projects 2-1 to 2-5
THURSDAY-
-
- Review Lesson 2 Notes - Open Data File
- Excel Lesson 3 Notes
- Printing with Backstage 64
Printing and Previewing a Document 64
Using Quick Print to Print a Worksheet 66
Setting the Print Area 67
Printing Selected Worksheets 68
Printing Selected Workbooks 70
Applying Printing Options 71
Changing a Printer
- Changing the Excel Environment 75
Customizing the Quick Access Toolbar 75
Customizing the Ribbon 77
Customizing the Excel Default Settings 79
Resetting Default Settings, the Ribbon, and Quick Access Toolbar 81
- Accessing and Using Excel Templates 81
- Complete Lesson 3 Projects
ASSIGNMENT: Lesson 3 Projects 3-1 to 3-6 Windows 7 Terms
- Bell Ringer: Go over Projects
- Review Lesson 3 Notes
- Excel Lesson 4 Notes
- Understanding and Displaying Formulas 92
Understanding Order of Operations 93
Building Basic Formulas 94
Creating a Formula that Performs Addition 95
Creating a Formula that Performs Subtraction 95
Creating a Formula that Performs Multiplication 96
Creating a Formula that Performs Division 96
- Con't Lesson 4 Notes
- Using Cell References in Formulas 97
Using Relative Cell References in a Formula 97
Using Absolute Cell References in a Formula 98
- Complete Lesson 4 Step-by-Steps pages 92-109
ASSIGNMENT: Excel Lesson 4 Step-by-Steps