Blogs Blogs

Formulas Blogs

Newest Most Active

Hi everyone!   I have tutored students who take this class many times.  It is a very confusing class and teaches old concepts rarely used in business anymore, as the internet has changed how we use Excel and other data management tools. Further, it does not teach definitions of terms so it becomes difficult to look for information online.   I wanted to give some definitions here that will help you at least search for help online: In Excel, things that start with = are called "formulas". A bunch of characters together are called a "string". Strings can have spaces and punctuation. If you cut off a piece of a string (which is done using the LEFT, RIGHT, and MID formulas), that is called "parsing a string". An "array" is a list of numbers or cells. Arrays have have a : in them, and mean STARTING CELL:ENDING CELL (like A1:A20). Each formula has a name, and starts with = and the name, then has... read more

  Reading Formulas can make or break how a student comprehends the formula when alone - outside the presence of the teacher, instructor, tutor, or parent. Formula For Perimeter of Rectangle:  P = 2l + 2w How To Read:  The Perimeter of a Rectangle is equal to two (2) times the Length of the longer side of the rectangle (L) plus two (2) times the Width of the shorter side of the rectangle (W). When is reading formulas like this necessary?  At three particular moments, reading this formula in this manner can be effective.  When students are initially learning what the formula means When student are learning what it means when they should already know (remediation).  When students want to remind themselves (basics learning study skill habit) Remember, Formulas at their introduction are complete statements or thoughts.  Students cannot and will not recall complete thoughts or statements... read more

Formulas Blogs RSS feed