Productivity
Excel Formula SUM Functions
SUM functions Probably the most frequently used function in Excel (or any other spreadsheet program), =SUM does just that: It
Category: Excel
Looking for tips and how-to information for Excel, checkout this section
Excel
Excel Formula REPT
When Lotus 1-2-3 was the only game in town, you could enter a backslash followed by any character and Lotus
Productivity
Excel Formula RAND
The RAND function is really simple and traditionally used for statistical analysis, cryptography, gaming, gambling, and probability theory, among dozens
Productivity
Excel Formula MIN/MAX functions
Use the MIN function to find the smallest number in a range of values, and the MAX function to find
Productivity
Excel Formula COUNT functions
Use the COUNT function to count the number of numeric values in a range of cells; for example: C4:C15 contains
Excel
Excel Formula AVERAGE function
Most everyone knows that an average is determined by adding all the values in a list, then dividing by the
Excel
Excel Formula AVERAGE function
Most everyone knows that an average is determined by adding all the values in a list, then dividing by the
Productivity
Excel Formula IF statement
The IF function (also more commonly called IF statements) work like this: IF, then, else. Basically, that means if a
Productivity
Excel Formula TRIM
This function removes extra (or padded) spaces that infect your data as a result of user error, downloading data from
Productivity
Excel Formula AND/OR
AND and OR are common functions in the programmers’ environment, also referred to as Boolean operators (along with NOT). AND