Subject Details
Dept     : MECH
Sem      : 5
Regul    : 2019
Faculty : Mr. R. Dinesh
phone  : NIL
E-mail  : dinesh.r.mech@snsct.org
99
Page views
39
Files
2
Videos
3
R.Links

Icon
Syllabus

UNIT
1
INTRODUCTION TO EXCEL

Theory: About Excel & Microsoft, Uses of Excel, Excel software, Spreadsheet window pane, Title Bar, Menu Bar, Standard Toolbar, Formatting Toolbar, the Ribbon, File Tab and Backstage View, Formula Bar, Workbook Window, Status Bar, Task Pane, Workbook & sheets. Practical: 1. Creating excel data 2. Filtering excel data 3. Formatting excel data

UNIT
2
EXCEL TABLES

Theory: Columns & Rows: Selecting Columns & Rows, Changing Column Width & Row Height, Autofitting Columns & Rows, Hiding/Unhiding Columns & Rows, Inserting & Deleting Columns & Rows, Cell, Address of a cell, Components of a cell – Format, value, formula, Use of paste and paste special. Using Ranges, Selecting Ranges, Entering Information Into a Range, Using AutoFill. Practical: 1. Creating excel table 2. Summarizing data

UNIT
3
FORMULA AND CHART

Theory: Using Formulas, Formula Functions – Sum, Average, if, Count, max, min, Proper, Upper, Lower, Using AutoSum, Advance Formulas - Concatenate, Vlookup, Hlookup, Match, Countif, Text, Trim. Spreadsheet Charts: Creating Charts, Different types of chart, Formatting Chart Objects, Changing the Chart Type, Showing and Hiding the Legend, Showing and Hiding the Data Table Practical: 1. Creating excel formula sheet 2. Creating excel charts

UNIT
4
DATA HANDLING & ANALYSIS

Theory: Data Analysis: Sorting, Filter, Text to Column, Data Validation. Making Macros: Recording Macros, Running Macros, Deleting Macros. Mathematical functions - summarizing data - pivot table: Creating PivotTables, Manipulating a PivotTable, Using the PivotTable Toolbar, Changing Data Field, Properties, Displaying a PivotChart, Setting PivotTable Options, Adding Subtotals to PivotTables - formula auditing - what-if analysis. Practical: 1. Creating and editing pivot tables 2. Creating and editing pivot charts

UNIT
5
STATISTICAL ANALYSIS WITH EXCEL

Theory: Introduction to Statistics (Descriptive and Inferential). Descriptive Statistics: Tabular & Graphical Presentation. Descriptive Statistics: Numerical Measures (Averages and Variances). Introduction to Probability: Discrete Probability Distributions, Continuous Probability Distributions. Sampling and Sampling Distributions, Interval Estimation, Hypothesis Testing, ANOVA, Simple Linear Regression. Introduction to Tabulae for data visualization. Practical: 1. Linear regression table 2. Introduction to Tabulae 3. Optimization using MINITAB

Reference Book:

1. “Excel 2016 Pivot Table Data Crunching”, Bill Jelen, Michael Alexander (ISBN-13: 978-0789756299) 2. “Excel Dashboard and Reports” 2nd Edition, Michael Alexander, John Walkenbach by Wiley (ISBN10: 9781118490426) 3. “Microsoft Excel 2019 Data Analysis and Business Modeling (Business Skills)” 6th Edition, Wayne Winston, 4. “Learn Excel 2016 Essential Skills with the Smart Method”, Mike Smart (ISBN-13: 978-1118373439) 5. “Marketing Analytics: Data-Driven Tech

Text Book:

1. "Essentials of Modern Business Statistics with Microsoft Office Excel", Anderson, Sweeney, Williams (ISBN 978-1-285-86704-5) 2. "Excel 2016 Bible", John Walkenbach, by Wiley (ISBN-10: 1119067510)