Search

Blogs Blogs

Formulas And Functions 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

Formulas And Functions Blogs RSS feed