# ExcelIsFun

## Excel Business Math 00: Excel Basics

1. 1

### Excel Busn Math 01: What is Excel?

6,021 views

What is Excel? Learn some Excel basis:
1) What a spreadsheet Excel workbook can do
2) Learn the common Excel terms
3) See an basic example of Excel Calculations and Excel Data Analysis
4) See a formula and a function

This is a beginning to end video series for the Business Mathematics / Excel Class, Busn 135 at Highline Community College taught by Michael Gel ExcelIsFun Girvin.

2. 2

### Excel Busn Math 02: Formulas and Math Operators

5,590 views

See how to create Math formulas in Excel using Addition, Subtraction, Multiplication, Division, Exponents, and Parenthesis.

Learn about the Base and Exponent when doing exponents.

See how 2+2*2 is not equal to (2+2)*2.

This is a beginning to end video series for the Business Mathematics / Excel Class, Busn 135 at Highline Community College taught by Michael Gel ExcelIsFun Girvin.

3. 3

### Excel Busn Math 03: Math Order Of Operations

3,269 views

See how to create Math formulas in Excel and how the Math Order Of Operations affects formula Results. See formulas with Addition, Subtraction, Multiplication, Division, Exponents, and Parenthesis.

This is a beginning to end video series for the Business Mathematics / Excel Class, Busn 135 at Highline Community College taught by Michael Gel ExcelIsFun Girvin.

4. 4

### Excel Busn Math 04: The Importance Of Formatting In Math

3,918 views

Learn about formatting in Excel and how it affects Math Calculations. See Currency, Number, Accounting, Date, Time and Percentage formatting using the Format Cells Dialog Box. See date math (date formulas calculations), time (time payroll formulas calculations) math and the different ways to enter Percentages in Excel.

Default (General)
Number format
Currency format
Accounting format
Increase decimals using format cells dialog box
Decrease decimals using format cells dialog box
Date format
Time format
Percentage format
Save time and format cells before you type

This is a beginning to end video series for the Business Mathematics / Excel Class, Busn 135 at Highline Community College taught by Michael Gel ExcelIsFun Girvin.

5. 5

### Excel Busn Math 05: Functions & Formulas

3,798 views

See how to use the built-in Excel functions: SUM, AVERAGE, PRODUCT, LCM, QUOTIENT and MOD functions. Hear about the Excel add-in Analysis Toolpak which adds in functions like QUOTIENT and LCM for Excel 2003 and earlier versions.

This is a beginning to end video series for the Business Mathematics / Excel Class, Busn 135 at Highline Community College taught by Michael Gel ExcelIsFun Girvin.

6. 6

### Excel Busn Math 06: Relative & Absolute Cell References

3,166 views

Learn About the importance of Cell References in Excel formulas and functions. Learn about a Relative and Absolute Cell references in Excel formulas.

This is a beginning to end video series for the Business Mathematics / Excel Class, Busn 135 at Highline Community College taught by Michael Gel ExcelIsFun Girvin.

7. 7

### Excel Busn Math 07: When ROUND function Is Required

3,840 views

See when to use the ROUND function for Math Calculations:
1)You are multiplying or Dividing Decimals
2)When you are required to ROUND (Money Requires that you round to the penny)
3)When you will use the formula result in subsequent calculations

Round to the Penny: the second argument in the ROUND function is 2
Round to the Dollar: the second argument in the ROUND function is 0
Round to the Thousands position: the second argument in the ROUND function is -3

This is a beginning to end video series for the Business Mathematics / Excel Class, Busn 135 at Highline Community College taught by Michael Gel ExcelIsFun Girvin.