Microsoft Excel & Accounting

Excel Lessons 1-12
Excel Lesson 1
Intro to Excel
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/Excel%20Lesson%201.docx
Excel Lesson 2
Setting up a Spreadsheet
https://dl.dropboxusercontent.com/u/44780538/Excel%20%26%20Accounting/Excel%20Lesson%202.docx
Resources:
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/Activity%201%20Discipline%20Chart/ACT%201%20Excel%20Setting%20up%20a%20Spreadsheet%20%28student%20discipline%20chart%29.docx
Discipline Chart:
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/Activity%201%20Discipline%20Chart/Act%201%20Excel%20Student%20Discipline%20Chart.xlsx
Excel Lesson 3
Adding and Subtracting Formulas
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/Excel%20Lesson%203-8/Excel%20Lesson%203%20Adding%20and%20Subtracting%20formulas.docx
Test
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/Excel%20Lesson%203-8/Lesson%203%20TEST%20over%20entering%20formulas%20add%20and%20subtract.docx
Excel Lesson 4
Multiplication and Division
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/Excel%20Lesson%203-8/Lesson%204%20entering%20formulas%20multiply%20divide%20autosum.docx
Resource:
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/Excel%20Lesson%203-8/Planning%20an%20Effective%20Spreadsheet.docx
Formula Worksheet Test Review
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/Excel%20Lesson%203-8/Formula%20Worksheet%20and%20test/Formula%20worksheet%20test%20review.xlsx
Excel Lesson 5
Cut Copy & Paste
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/25%20Excel%205-7/Lesson%205%20cut%20copy%20paste%20and%20cell%20addressing.docx
TEST after Lesson 5
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/25%20Excel%205-7/Excel%20Project%20Test%20after%20Lesson%205.docx
Excel Lesson 6
Excel Formatting
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/25%20Excel%205-7/Lesson%206%20Excel%20Formatting.docx
Excel Lesson 7
Advanced Order of Operation
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/25%20Excel%205-7/Lesson%207%20Excel%20Advanced%20Order%20of%20Operations.docx
Loan Amortization
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/25%20Excel%205-7/Loan%20Amortization%20Template%20Lesson.jpg
Excel Lesson 8
Creating Functions
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/26%20Excel%208-10/Lesson%208%20Creating%20Functions%20and%20filling%20cells.docx
Formula and Order of Operations Test
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/26%20Excel%208-10/Excel%20Formula%20and%20Order%20of%20Operations%20Test.docx
Excel Lesson 9
Fill Cells Automatically
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/26%20Excel%208-10/Lesson%209%20Fill%20Cells%20Automatically.docx
Formula Worksheet Test
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/26%20Excel%208-10/Formula%20worksheet%20test.xlsx
Test Answers
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/26%20Excel%208-10/Formula%20worksheet%20test%20answers.xlsx
Excel Lesson 10
Set Print Options
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/26%20Excel%208-10/Lesson%2010%20Set%20Print%20Options.docx
Decimal and Percent Test
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/27%20Excel%2011-12/Decimal%20and%20Percent%20TEST.docx
Excel Lesson 11
Creating Charts
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/27%20Excel%2011-12/Lesson%2011%20Creating%20Charts.docx
Excel Lesson 12
Pictographs
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/27%20Excel%2011-12/Lesson%2012%20Adding%20a%20Pictograph.docx
Final Excel Test:
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/27%20Excel%2011-12/Final%20Excel%20Test.docx
Timeline Test
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/28%20Texas%20Independence%20Day/Timeline%20Final%20Test/Instructions%20for%20Timeline%20in%20Excel.docx
Timeline Test Sample
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/28%20Texas%20Independence%20Day/Timeline%20Final%20Test/Timeline%20Test%20Example.xlsx

TAXES
Completing a W-2 Form
 http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/31%20W-2%20Form/Completing%20a%20w-2%20form.docx
Resources:
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/31%20W-2%20Form/f1040ez.pdf
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/31%20W-2%20Form/i1040ez%20Tax%20Table%20in%20instruction%20book%2027-34.pdf

Investing Lessons:
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/33%20We%20Seed%20Lesson/Learn%20How%20to%20use%20Excel%20to%20watch%20your%20Investment%20Performance.docx

Accounting Ethics Lesson
Created in MovieMaker
Student Sample:
http://dl.dropbox.com/u/44780538/Excel%20%26%20Accounting/WorldCom%20Scandal.wmv