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