X hits on this document

195 views

0 shares

0 downloads

0 comments

41 / 57

Microsoft Excel

Entering Date and Time: Dates are stored as MM/DD/YYYY. No need to enter  in that format. For example, Excel will recognize Jan 9 or jan-9 as 1/9/2007 and Jan 9, 1999 as 1/9/1999. To enter today’s date, press Ctrl and ; together. Use a or p to indicate am or pm. For example, 8:30 p is interpreted as 8:30 pm. To enter current time, press Ctrl and : together.  

Copy and Paste all cells in a Sheet: Ctrl+A for selecting, Ctrl +C for copying  and Ctrl+V for Pasting.

Sorting: Data Sort Sort By

Descriptive Statistics and other Statistical methods: ToolsData Analysis Statistical method. If Data Analysis is not available then click on Tools Add-Ins and then select Analysis ToolPack and Analysis toolPack-Vba

Document info
Document views195
Page views195
Page last viewedThu Jan 19 21:40:14 UTC 2017
Pages57
Paragraphs509
Words3812

Comments