Understating Excel, Introduction to formulas e.g. PV, PMT, NPER, RATE, Creating Balance Sheet, Investment Calculations, Depreciation Calculations. Chart your data, Creating Graphics using Insert tab Utilities.

LOOKUP Functions, Protecting your work sheet using review tab utilities, Create an Excel table, What-if Analysis, Pivot tables for Data Analysis, Analyzing data with the Analysis Tool Pack.

Entering Data manually, Importing MS Excel file, Importing Text file, Managing files, Descriptive Statistics, Hypothesis, Interpretation of the results of Runs Test, Linear Regression.

Mean Comparison – One sample T Test, Independent T Test, Paired Sample T Test, Pearson coefficient of Correlation, ANOVA.

Non Parametric Tests – Sign Test, Mann-Whitney U Test, Chi-Square Test, Kruskal- Wallis Test, Friedman Test, Wilcoxon Signed-Rank Test.