UNIT 1:
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
UNIT 2:
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
UNIT 3:
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
UNIT 4:
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
UNIT 5:
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