L4-Advanced-Spreadsheet-Skills.pptx

LESSON 4 Advanced Spreadsheet Skills Commonly used Microsoft Excel functions Conditional functions Use of Microsoft Excel in market research At the end of this lesson, the students should be able to: 1. familiarize with the most commonly used functions in Microsoft Excel; 2. use...

LESSON 4 Advanced Spreadsheet Skills Commonly used Microsoft Excel functions Conditional functions Use of Microsoft Excel in market research At the end of this lesson, the students should be able to: 1. familiarize with the most commonly used functions in Microsoft Excel; 2. use several conditional functions available in Microsoft Excel; and 3. use Microsoft Excel as a viable tool in market research and product development. Microsoft Excel provides an automated way of displaying any statistical data. It can be used to automatically compute for several factors that are not easy to notice especially when faced by a large data. Microsoft Excel includes several arithmetic and basic functions that help you compute faster.  Basic Excel Formulas: Addition (+) Subtraction (-) Multiplication (*) Division (/) *type before the formula, thus: =a1+a2  Average – a function used to compute for the average of the number of a range. COUNTIF – a function used to count the cells with a specified content within a range. SUMIF – a function used to compute for the summation of a range if a certain condition is met AVERAGEIF – a function used to compute for the average of a range if a certain condition is met