Charts and Graphs in Excel
Charts and graphs are used to make information clearer and easier to understand. A good picture is worth a thousand numbers. The most common place for people…
June 2017
Excel: DATA VALIDATION
Data validation feature allows you to set up certain rules that dictate what can be entered into a cell. It allows you to do the…
Descriptive Statistics in R
Descriptive statistics is the term given to the analysis of data that helps, describe, show or summarize data in a meaningful way, It doesn’t allow…
EXCEL : Importing External Data
External data is defined as data that exists outside of the Excel workbook, in some other place. Other places could be almost anywhere; and Excel…
Excel: Functions-II
TEXT FUNCTIONS 1. TRIM: Removes all spaces from a text string except for single spaces between words SYNTAX: =TRIM (text) TEXT: Required. The text from…
