Introduction

Running Microsoft Excel

Excel elements

Managing workbooks and worksheets

Entering Data into Spreadsheet

Formatting

Changing number and date formatting (currency, percentage, etc...)

Formating cell's borders and background

Formating row and column headers

Styles in Excel

Excel Navigation

Moving around a big spread sheet

Dealing with multiple workbooks projects

Copying and Moving data

Selecting and moving ranges of data

Paste Special utility

Filling spreadsheet with series of data (dates, weekdays, sequential number, etc..)

Formulas, Addresses and Names of Cells

Creating and moving formulas

When to use absolute and relative address

Solving circular reference problem

Conditional formatting

Referening other worksheets and workbooks

Creating and utilizing cells name

Excel Functions

Basic information about functions and Excel

Basic functions

Functions nesting

Conditional functions

Intesrt function dialogue box

Drawing

WordArt and Autoshapes

Static and dynamic graphics

Charts

Charts types and their utilization

Creating clear charts

Charts elements and their modification

Creating chart types

Hiding and Protecting Data

Hiding sheets, columns and rows

Hiding formulas and cells' data

Protecting sheets and workbooks against changes

Protecting workbooks from viewing

Printing

Printing spreadsheets

Printing charts