Posts

Maths: Multiply any digit number by 11 in 10 seconds

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

Maths: Multiply any 2 digit numbers by 11 in 2 seconds

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

Maths Inequality Signs less than and greater than

https://www.youtube.com/watch?v=v83FvqVNfYQ Tips Less than sign is like a tilted L . Once you identify less than sign then other sign is greater than Inequality signs are like animal mouth. Animal opens the mouth towards bigger number.

Excel: Current Date stamp in 10 seconds

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

Excel: Delete multiple blank cells under 10 seconds

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

Shortcut Keys to remove hyperlinks from word document

https://www.youtube.com/watch?v=uMUhaWIPXYY To remove hyperlinks from word document select all text using CTRL A and then CTRL SHIFT F9 will remove hyperlinks.

Excel: Min and Max

[embedyt] http://www.youtube.com/watch?v=cPn1gGjD4ZM[/embedyt] Max function returns the largest value in a set of values. Syntax MAX(number1, [number2], ...) The MAX function syntax has the following arguments: Number1, number2, ...     Number1 is required, subsequent numbers are optional. Note: If the arguments contain no numbers, MAX returns 0 (zero). Arguments that are error values or text that cannot be translated into numbers cause errors. If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the MAXA  function. MIN functions returns the smallest number in a set of values. Syntax MIN(number1, [number2], ...) The MIN function syntax has the following arguments: Number1, number2, ...     Number1 is required, subsequent numbers are optional. Note: If an argument is an array or reference, only numbers in that array or reference are used. Empty cells, logical values, or text in the array or reference ...