css.php

Excel Video Tutorials

(Video) Tutorials on Excel topics:

Basic Operators(PEMDAS):

Formula Creation:

https://support.office.com/en-us/article/Create-a-simple-formula-11a5f0e5-38a3-4115-85bc-f4a465f64a8a

https://support.office.com/en-us/article/Create-a-formula-8eef00e0-b514-4ebd-b202-086668f2d664?ui=en-US&rs=en-US&ad=US

 

Keyboard Shortcuts:

https://support.office.com/en-us/article/Excel-keyboard-shortcuts-ef213435-a57e-4ce1-bac6-2b39f16cb121

Functions

Mean, Median, Mode & Standard Deviation:

 

Min & Max:

Range, Variance & Standard Deviation:

Sum:

Count:

Sumif, Countif:

Installing Data analysis Toolpack:

 

Correlation Matrix: