Welcome to the World of Education.

MS Excel and Advanced Excel Lab Syllabus MBA Pune Univesity for Academic Year 2013-14

Subject Name: MS Excel and Advanced Excel Lab

Subject Type: Generic Elective

Subject Code: 109

Marks: 50

Distribution of Marks: 50 (Internal Marks by College)

Unit 1

1.1 Understanding Excel’s Files, Ribbon and Shortcut:Create a workbook , Enter data in a worksheet , Format a worksheet , Format numbers in a worksheet , Create an Excel table , Filter data by using an AutoFilter , Sort data by using an AutoFilter ( 1 )

1.2 Essential Worksheet Operations: Using Help (F1), Key Board Shortcuts ( 1 )

1.3 Working with Cells and Ranges: Formatting Cells, Name Manager ( 1 )

1.4 Visualizing Data Using Conditional Formatting:Apply conditional formatting ( 1 )

1.5 Printing Your Work:Print a worksheet , Using Print Preview & Other Utilities ( 1 )

Lab based Evaluation (1 )

Unit 2

2.1 Working with Dates and Times & Text: Working with Dates & Time, Creating Formulas that Manipulate Text – Upper, Proper, Lower, Concatenate, Text to column ( 1 )

2.2 Creating Formulas That Count, Sum, Subtotal:Create a formula, Use a function in a formula ( 2 )

2.3 Creating Formulas That Look Up Values: VLookup, HLookup, Match & Index ( 2 )

Lab based Evaluation 1

Unit 3

3.1 Creating Formulas for Financial Applications: Introduction to formulas e.g. PV, PMT, NPER, RATE, Creating Balance Sheet, Investment Calculations, Depreciation calculations ( 3 )

3.2 Creating Charts and Graphics:Chart your data, Creating Sparkline Graphics, Using Insert Tab Utilities(2)

Lab based Evaluation 1

Unit 4

4.1 Using Custom Number Formats:Right click, Format Cells window ( 1 )

4.2 Using Data Tab and Data Validation:Getting external Data, Remove Duplicates, Apply data validation & using utilities from Data Tab ( 1 )

4.3 Protecting Your Work: Using Review Tab Utilities ( 1 )

4.4 Performing Spreadsheet What-lf Analysis:Create a macro, Activate and use an add-in 2

Lab based Evaluation 1

Unit 5

5.1 Analyzing Data with the Analysis Tool Pak:Anova,Correlation, Covariance, Descriptive Statistics, Histogram, Random Number Generation, Rank and Percentile, Regression, t-Test, Z Test ( 2 )

5.2 Using Pivot Tables for Data Analysis:Create Data Base for Pivot, Analysing Data with Pivot Tables, Producing Report with a Pivot Table ( 3 )

Lab based Evaluation 1

Text Books

• Excel 2010 Bible [With CDROM]by John Walkenbach, John Wiley & Sons, 2010 Edition

 Reference Books

• Excel 2007 for Dummies by Greg Harvey

• New Perspectives on Microsoft Office Excel 2007

Supplementary Reading Material

• www.hrdiap.gov.in/Downloads/04.MS%20Excel.pdf

• www.stern.nyu.edu/~jsimonof/classes/1305/pdf/excelreg.pdf

• www.goodwin.edu/computer_resources/pdfs/excel_2010_tutorial.pdf

• www.microagecs.com/apps/training/courseware/excel.pdf

• www.lfpl.org/jobshop/docs/Intermediate-Excel.pdf

Websites

• http://office.microsoft.com/en-us/

• http://office.microsoft.com/en-us/excel-help/excel-help-and-how-to- FX102693827.aspx

• http://office.microsoft.com/en-us/excel/

• http://office.microsoft.com/en-us/excel-help/excel-functions-by-category- HP005204211.aspx

• http://www.baycongroup.com/el0.htm

• http://spreadsheets.about.com/od/tipsandfaqs/f/excel_use.htm

• http://www.computerhope.com/shortcut/excel.htm

• http://www.techonthenet.com/excel/formulas/

• http://www.functionx.com/excel/

• http://people.usd.edu/~bwjames/tut/excel/

• http://spreadsheets.about.com/od/excelfunctions/Using_Excel_Functions_in_Spreads heets.htm

• http://www.computergaga.com/excel/functions/

Journals

• http://www.elijournals.com/products/showproduct.asp?prodID=24&catID=1

• http://www.spyjournal.biz/views/excel

Share This