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
Lecture Notes

UNIT 1:
pdf
download    open file
About Excel & Microsoft, Uses of Excel
pdf
download    open file
Excel software, Spreadsheet window pane
pdf
download    open file
Title Bar, Menu Bar, Standard Toolbar
pdf
download    open file
Formatting Toolbar, the Ribbon, File Tab and Backstage View
pdf
download    open file
Formula Bar, Workbook Window, Status Bar
pdf
download    open file
Task Pane, Workbook & sheets
UNIT 2:
pdf
download    open file
Columns & Rows: Selecting Columns & Rows, Changing Column Width & Row Height
pdf
download    open file
Autofitting Columns & Rows, Hiding/Unhiding Columns & Rows
pdf
download    open file
Inserting & Deleting Columns & Rows, Cell, Address of a cell
pdf
download    open file
Components of a cell – Format, value, formula, use of paste and paste special
pdf
download    open file
Using Ranges, Selecting Ranges
UNIT 3:
pdf
download    open file
Using Formulas, Formula Functions – Sum, Average, if
pdf
download    open file
Count, max, min, Proper, Upper, Lower, Using AutoSum
pdf
download    open file
Advance Formulas - Concatenate, Vlookup, Hlookup, Match, Countif, Text, Trim. Spreadsheet Charts
pdf
download    open file
Creating Charts, Different types of chart
pdf
download    open file
Formatting Chart Objects, Changing the Chart Type
pdf
download    open file
Showing and Hiding the Legend, Showing and Hiding the Data Table
UNIT 4:
pdf
download    open file
Data Analysis: Sorting, Filter, Text to Column, Data Validation
pdf
download    open file
Making Macros: Recording Macros, Running Macros, Deleting Macros
pdf
download    open file
Mathematical functions - summarizing data
pdf
download    open file
pivot table: Creating PivotTables, Manipulating a PivotTable
pdf
download    open file
Using the PivotTable Toolbar, Changing Data Field, Properties, Displaying a PivotChart
pdf
download    open file
Setting PivotTable Options, Adding Subtotals to PivotTables - formula auditing - what-if analysis
UNIT 5:
pdf
download    open file
Introduction to Statistics (Descriptive and Inferential)
pdf
download    open file
Descriptive Statistics: Tabular & Graphical Presentation
pdf
download    open file
Descriptive Statistics: Numerical Measures (Averages and Variances)
pdf
download    open file
Introduction to Probability: Discrete Probability Distributions, Continuous Probability Distributions
pdf
download    open file
Sampling and Sampling Distributions, Interval Estimation, Hypothesis Testing, ANOVA, Simple Linear Regression
pdf
download    open file
Introduction to Tabulae for data visualization