Understanding 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.
Reference Book:
William J. Stevenson, Ceyhun Ozgur, ‘Introduction to Management Science with Spreadsheet’,Tata McGraw Hill, 2009. Wayne L. Winston, Microsoft Excel 2010: Data Analysis & Business Modeling, 3rd edition, Microsoft Press, 2011. Vikas Gupta, Comdex Business Accounting with Ms Excel, 2010 and Tally ERP 9.0 Course Kit,Wiley India, 2012 Kiran Pandya and Smriti Bulsari, SPSS in simple steps, Dreamtech, 2011.
Text Book:
David M. Levine et al, “Statistics for Managers using MS Excel’ (6th Edition) Pearson, 2010 2. David R. Anderson, et al, ‘An Introduction to Management Sciences: Quantitative approaches to Decision Making, (13th edition) South-Western College Pub, 2011.David M. Levine et al, “Statistics for Managers using MS Excel’ (6th Edition) Pearson, 2010 David R. Anderson, et al, ‘An Introduction to Management Sciences: Quantitative approaches to Decision Making, (13th edition) South-Western College Pub, 2011.
