Table of Contents in Excel:

SPREADSHEET MS EXCEL
UNIT 3_Structure
3	Introduction
3.1	Objectives
3.2	What is a Spreadsheet ?
3.3	Excel Basics
	3.3.1	Starting Excel
	3.3.2	Commands and Resources in Excel Window
	3.3.3	Setting Up in Your Excel Environment
	3.3.4	Creating a New Workbook
	3.3.5	Opening an Existing Workbook
	3.3.6	Saving a Existing Document
	3.3.7	Working with Multiple Workbooks
	3.3.8	Closing a Workbook
	3.3.9	Closing Microsoft Excel
3.4	Entering, Editing and Formatting Data
	3.4.1	Moving around the Worksheet
	3.4.2	Selecting Cells, Rows or Columns
	3.4.2.1	Selecting Cells
	3.4.3	Entering Data
	3.4.4	Deleting Data
	3.4.5	Editing Data
	3.4.6	Working with Cells, Rows and Columns
	3.4.7	Data and Formatting
3.5	Formulas and Functions
	3.5.1	Formulas
	3.5.1.1	Create a Simple Formulas
	3.5.1.2	Create a Simple Formulas using Point and Click Method
	3.5.2	Using Cell References
	3.5.3	Linking Worksheets
	3.5.4	Functions
	3.5.4.1	Function Library
	3.5.4.2	Insert a Function
3.6	Working with Worksheets
	3.6.1	Name a Worksheet
	3.6.2	Insert a New Worksheet
	3.6.3	Delete a Worksheet
	3.6.4	Grouping Worksheets
	3.6.5	Ungrouping Worksheets
	3.6.6	Reposition Worksheets in a Workbook
	3.6.7	Hide Worksheets
	3.6.8	Formatting and Printing the Workbook
3.7	Working with Tables and Charts
	3.7.1	Tables
	3.7.1.1	Create Table
	3.7.1.2	Sort Data
	3.7.1.3	Filter Data
3.7.2	Charts
	3.7.2.1	Add Data
	3.7.2.2	Create Chart
	3.7.2.3	Apply Layout
	3.7.2.4	Add Labels
	3.7.2.5	Switch Data
	3.7.2.6	Change Chart Type, Chart Style or Data Range
	3.7.2.7	Move the Chart to a Different Worksheet
3.8	Other Useful Excel Features
	3.8.1	Conditional Formating
	3.8.2	Freeze Rows and Columns
	3.8.3	Find and Replace
	3.8.4	Add Comments
	3.8.5	Protect Worksheet
	3.8.6	Convert Text to Columns
3.9	Summary
3.1	Lab Exercise