Lesson 4

Advanced Spreadsheet Skills

    In this lesson I learned that i can use  Microsoft Excel as a viable tool in market research and product development. I know already on how can i do some of my home works by using Microsoft Excel, it can helps me a lot to improve my skills and knowledge  and I want to explore more and learn more about this topic.


     -Microsoft Excel is a widely use spreadsheet program. A spreadsheet program is a software for entering, editing, manipulating, and printing information in a tabulate form. 

Using Formulas and Function

"PLEASE EXCUSE MY DEAR AUNT SALLY"

-is a shortcut for the precedence which operations take place:

Operation enclosed within Parenthesis, Exponential , Multiplication, Division, and then Addition and Subtraction

List of commonly used mathematical symbol in Excel

Exponentiation(^)   Multiplication(*)

Division(/)                 Addition(+)

Subtraction(-)           Equal to(=)

Greater than(>)        Less than(<)

Sum(range) is used to compute the total of all items in the specific range. 

Average(range) is used to get the average of the items in a range.

Count(range) is used to count the values found in the range.

Max(range) is used to get the largest value within the range.

Min(range) is used to get the smallest value within the range.

COUNTIF(range,criteria) is used to count the cells with specified content within a range.

SUMIF(range, criteria) is used to compute for the summation of a range if a certain condition is met.

AVERAGEIF(range,criteria) is used to compute for the average of a range if a certain condition is met.