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
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
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
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
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
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 (ISBN-10: 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 Techniques with Microsoft Excel” 1st Edition by Wayne L Winston, Wiley (ISBN-10: 111837343X)
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)
