Formulae
and Functions
Cell Addressing in Formulae
Copy Formulae
Absolute Cell Referencing
Creating Names Ranges
Using Ranges in Formulae
Use of Average, Min and Max
Functions
Create a Formula using Functions
Use Insert Function
Use Basic Arithmetic Functions
Date Related Functions
Using Logical Functions in
Formulas
Strings
Data
Lists
Create a Data List
Use a From to View, Sort and
Enter Records
Sorting Lists
AutoFilter
Charts
Creating Charts Revisited
Moving, Resizing and Deleting
Charts
Formatting Charts
Adding Trend Line to a Chart
Using the Chart Toolbar
Changing Chart Options
Printing Charts
Formatting Worksheets
Applying Cell Borders and Shading
Apply AutoFormat
Define a Style
Modify Exiting Style
Apply Style to Worksheet
Add Comments
Review, Edit and Delete Comments
Managing
Worksheets
Renaming Worksheets
Inserting and Deleting Sheets
Copying Sheets
Hide and Unhide Rows and Columns
Switch between Worksheets
Import
and Export of Data
Import Data from other
Applications
Export Data to other Applications
Printing
Workbooks
Print and Preview Ranges and
Sheets
Set Print Areas
Grid Lines
Display Formulas in Worksheet
Cells