Excel Magic Trick 326: Hyperlink Worksheet To Worksheet
Friday, August 14th, 2009
See how to create a hyperlink from one sheet to another sheet in the same workbook.
Duration : 0:3:0
See how to create a hyperlink from one sheet to another sheet in the same workbook.
Duration : 0:3:0
Concepts covered: Subtraction of Improper and Proper Fractions and also Mixed Numbers.
Duration : 0:10:25
This lesson consists of providing you with a Self-Tutorial of the basic properties of numbers. These are the ones I discuss:
The Reflexive Property of Equality, The Symmetric Property of Equality, The Transitive Property of Equality, The Substitution Property, The Additive Property of Equality, The Cancellation Law of Addition, The Multiplicative Property of Equality, Cancellation Law of Multiplication, The Zero-Factor Property, The Law of Trichotomy, The Transitive Property of Inequality, Properties of Absolute Value, The Closure Property of Addition, The Closure Property of Multiplication, The Commutative Property of Addition, The Commutative Property of Multiplication, The ociative Property of Addition, The ociative Property of Multiplication, The Identity Property of Addition, The Identity Property of Multiplication, The Inverse Property of Addition, The Inverse Property of Multiplication, The Distributive Law of Multiplication Over Addition, The Distributive Law of Multiplication Over Subtraction, The General Distributive Property and The Negation Distributive Property.
Duration : 0:38:28
Concepts covered: Addition of Improper and Proper Fractions and also Mixed Numbers.
Duration : 0:23:7
Concepts covered: Denominator, Numerator, Common Fraction, and Unit Fraction. I also teach you how to draw typical fractions on a circle.
Duration : 0:27:11
[NOTE: This video is only the first 18 minutes of the full lesson, please visit my website to purchase complete version] Lesson consists of providing you with a Self-Tutorial on how to solve linear equations. Tutor discusses what is an Equation, Solution, Solution Set, Equivalent Equations, Identity, Contradictions, Conditional Equations, Linear Equations, the Standard Form of a Linear Equation. I show you how to actually SOLVE linear equations going step-by-step. I don’t skip steps. I review some of the properties of Equality here too. I remind you to check the work done and how to solve linear equations using a calculator. At the end, you will know how to easily solve equations that look like:
2[y - (4y - 1)] = 5 - 9y
No word problems are done here. This is shown in DETAIL in Part 2 of the Lesson.
Duration : 0:18:25
Learn how to create worksheet and workbook references in formulas.
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109
Duration : 0:8:41
An informal introduction to why we need to learn about fractions.
Lesson 6 consists of providing you with a Self-Tutorial on all about fractions. This lesson is different from the previous ones in that the use of printed Notes is integrated with the Video (other Notes may be used independently of the videos). This lesson is VERY detailed and covers the necessary areas to help students review the many aspects of fractions and fraction conversions. I also show you how to perform all the many different fraction operations and conversions using the TI-84+ Graphing Calculator.
Duration : 0:9:19
This lesson consists of providing you with a basic review of the formulas from geometry you will most likely encounter in algebra (and other math classes like trigonometry and calculus). This is NOT a detailed, formal lesson.
Formulas and concepts covered include:
Angles (complementary & supplementary)
Triangles (perimeter and area)
Isosceles triangle
Equilateral triangle
Right triangle
The Pythagorean Theorem
Similar triangles
Perimeter and area formulas for Quadrilaterals (square, rectangle, parallelogram, trapezoid). Some diagonal formulas too, where applicable.
Circles (radius, diameter, circumference, area)
Cube (diagonal of face, diagonal of cube, surface area and volume)
Rectangular box [or Rectangular Parallelepiped] (diagonal of box, surface area and volume)
Prisms (Volume)
Pyramids (Volume)
Cone (slant height, lateral surface area, total surface area, volume)
Cylinder (lateral surface area, total surface area, volume)
Sphere (surface area and volume)
Duration : 0:23:8