Topic: Introduction To Excel
Video/Class Project
01:
Video to watch: Excel
& Business Math 01: Introduction to Excel. Why We Use Excel for Math. First
Formula. ( 39:00 min)
Start file for Video/Class Project to download: ExcelBusinessMath01-IntroToExcel.xlsx
Handout to download: ExcelBusinessMathVideo01-IntroToExcel.pdf
Assigned Homework: HW #1-3 at end of Excel Workbook for this video.
Video/Class Project
02:
Video to watch: Excel
& Business Math 02: Copying Formulas with Relative & Absolute Cell References ( 10:26 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo02-CellReferences.xlsx
Handout to download: ExcelBusinessMathVideo02-CellReferences.pdf
Assigned Homework: HW #1-3 at end of Excel Workbook for this video.
Video/Class Project
03:
Video to watch: Excel
& Business Math 03: Excel's Golden Rule: Formula Inputs, What If Analysis and
Excel Models ( 30:09 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo03-ExcelGoldenRule.xlsx
Handout to download: ExcelBusinessMathVideo03-ExcelGoldenRule.pdf
Assigned Homework: HW #1-2 at end of Excel Workbook for this video.
Video/Class Project
04:
Video to watch: Excel
& Business Math 04: Excel Built-in Functions, Data Types and Keyboards are Fast! ( 34:05 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo04DataFunctionsKeyboards.xlsx
Handout to download: ExcelBusinessMathVideo04DataFunctionsKeyboards.pdf
Assigned Homework: HW #1-3 at end of Excel Workbook for
this video.
Video/Class Project
05:
Video to watch: Excel
& Business Math 05: Number Formatting & When You MUST Use ROUND Function ( 32:41 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo05-NumberFormatROUND.xlsx
Handout to download: ExcelBusinessMathVideo05-NumberFormatROUND.pdf
Assigned Homework: HW #1-2 at end of Excel Workbook for this
video.
Video/Class Project
06:
Video to watch: Excel
& Business Math 06: All About Excel Formulas (17 Examples) for Business Math
Class ( 47:06 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo06-FormulaElementsTips.xlsx
Handout to download: ExcelBusinessMathVideo06-FormulaElementsTips.pdf
Assigned Homework: HW #1-5 at end of Excel Workbook for this video.
Video/Class Project
07:
Video to watch: Excel & Business Math 07: Style Formatting:
Format Painter, Mini Toolbar, Styles, Clear Format & More ( 24:10 min)
Start file for Video/Class Project to download: ExcelBusinessMathVideo07StyleFormatting.xlsx
Handout to download: ExcelBusinessMathVideo07StyleFormatting.pdf
Assigned Homework: HW #1 at end of Excel Workbook for this video.