Instructions:
1) Download all files
2) Open files
3) Click on video and watch
4) Complete project as seen in video
5) Then do homework in textbook (Homework list in syllabus).
Downloads:
Excel2010BusnMathCh04.xlsm (Chapter in
the textbook is 5, but workbook says 4!!!) (Selected homework solutions at end of workbook)
If file downloads as ".zip", watch this video: Download Excel File Shows Up As Zip?
Videos To Watch:
Excel 2010 Business Math 37: Checks and Deposits & Withdrawals at Your Bank
(section 5.1) (20 mins)
Excel 2010 Business Math 38: Calculating Checking Fees (Section 5.1) (4 mins)
Excel 2010 Business Math 39: VLOOKUP to Calculating Checking Fees (Section 5.1) (12 mins)
Excel 2010 Business Math 40: Create Checkbook Register In Excel Using IF function (Section 5.1) (16 mins)
Excel 2010 Business Math 41: Calculating Credit Card Fees (Section 5.2) (8 mins)
Excel 2010 Business Math 42: Bank Reconciliation (Section 5.3) (22 mins)
Extra IF and VLOOKUP Function (if you want more information about IF and VLOOKUP):
Workbook:
Busn
Math Ch 05 - IF and VLOOKUP Functions.xlsm
Videos:
Office 2010 Class #38:
Excel IF Function Formula Made Easy (7 examples)
Office 2010 Class #39:
Excel VLOOKUP Function Formula Made Easy (3 Examples)
2nd Extra VLOOKUP Video:
Workbook:
EMT915.xlsx
Video:
Excel Magic Trick 915: What
Exactly Does VLOOKUP Do? What Is Purpose Of VLOOKUP? 9 Examples