Posts

Showing posts with the label excel

Excel: Find Sum and Average

https://www.youtube.com/watch?v=kO094RKeQos Sum The SUM function, (math and trig function) adds values. You can add individual values, cell references or ranges or a mix of all three. Syntax: SUM(number1,[number2],...) Number1     mandatory. The first number, cell reference, or range for which you want the Sum. Number2, ...     Optional. Additional numbers, cell references or ranges for which you want the Sum. Average function returns the Average . It is (Arithmetic mean) of the arguments or values specified. Syntax AVERAGE(number1, [number2], ...) Number1     mandatory. The first number, cell reference, or range for which you want the average. Number2, ...     Optional. Additional numbers, cell references or ranges for which you want the average. Notes: Arguments  can either be numbers or names, ranges, or cell references that contain numbers. Logical values and text representations of numbers that you type directly into the list of arguments are counted. If a r...

Excel Number Formatting

https://www.youtube.com/watch?v=s0xUxRWBvoQ

Excel: Delete multiple blank cells under 10 seconds

https://www.youtube.com/watch?v=sujLcqmyA20