The Excel Environment

Opening Excel

Creating a new Workbook

Opening a Workbook

Saving Workbooks

Closing Excel
Closing multiple workbooks
Zoomsettings in the spreadsheet

Using the help window
using undo
using redo
Lising shortcut keys

Editing a template

Using the vertical scroll bar

Using the horizontal scroll bar

Toolbars

Showing toolbars Index

Showing the formatting toolbar

Showing the drawing toolbar
Showing the chart toolbar
Showing the picture toolbar
Showing the wordart toolbar

Working with Cells

Selecting a cell

Selecting groups of cells
Selecting multiple cells

Referencing a cell

Indexing Cells using rows & columns

Referencing a group of cells
Naming ranges
Setting a default cell width

Changing the tab color
Change the color of multiple tabs
Changing the column width
Changing the row height
Numericaly set the column width
Numerically set the row hight
Numerically set the size of a group of cells
Resizing  cells to fit contents
autofit cell height
autofilt cell width
Unmerge cells

Inserting & deleting rows
Inserting & deleting columns

Creating cell borders
Removing cell borders
Changing cell border colors
Drawing cell borders
Changing the cell background color l

Clear cell contents
Copy and Paste Index
Copy and Paste I

Paste Special values & formulas

Copy here as values only

Copy & Paste formulas with $

Copy & Paste Comments

Copy and paste Labels Values & Formulas

Autofill Index

Using the autofill options icon

Autofill identical data

Autofill a patterned series

Autofill formula

Autofill days of the week

Quick autofill

Horizontal autofill

Advanced Autofill (the $ sign)

Moving Data-drag and drop

The "go to"tool
The "go to" special tool
The "Find" tool

The "Find and Replace" tool

Formatting cell Data

Formatting cells Index

Formatting to Decimals I
Decrease decimal places
Increase decimal places
Formatting to Fractions I
Formatting to Percentages I Formatting to Currency I
Using Commas I
Formatting to Dates I

Formatting dates to date values I

Working with Worksheets

Changing tab color
Removing tab color
Changing the color of multiple tabs
Inserting worksheets
Deleting worksheets
Renaming worksheets
Reordering worksheets
Setting a worksheet background image

Working with Text

Setting a default font
Merge and center text
Adding comments to a cell
Editing comments
Removing comments

How to display Symbols

Formatting Text

Changing Fonts

Displaying Symbols

Changing font size Changing the Color of Fonts

Bold
Italics
Underline

Center text
Justify left
Justify right Merge and center text

Using the format painter

Using spell-check

Changing the language setting

Basic Operations In Excel

Basic Arithmetic Index

Multiplication & Division

Multiplication

Division

Addition

Subtraction

Basic Algebra functions

Using Mathematics Functions

Using the Equation Bar

Linking cells

Entering formulas using the function wizzard
The SQRT() function

The SUM function

Using Autosum button

The AVERAGE() Function

The ROUND() function

The ROUNDUP() function

The ROUNDDOWN() function

The ABS() function

The MAX() function

The MIN() functions

The FACT() function

The COUNT() function

Using the DATEVALUE() function

Intro to Charts

Embedding a Graph StepbyStep

 Formatting Charts

Formatting Charts Man Index
Formatting Line chart Index

Edit the chart title
Changing title color
Repositioning the title
Changing the title font
Changing the title text size

Changing the axis label font
Changing the axis label color
Changing the axis label size
Changing the axis label position
Changing the axis label orientation

Changing the axis color
Changing the axis tick marks
Changing the axis scale
Changing the axis scale font
Changing he axis scale color
Changing the axis scale size

Changing the legend text font
Changing the legent text color
Changing the legend text size
Changing the legend position
Changing the legend border
Removing the legend

Changing the line color

Changing the line style
Changing the line weight
Changing the line smoothness

Changing the point style
Changing the color of points
Changing the point sizeChanging the grid color
Removing the grid

Changing the background color
Changing the background to a gradient fill

Positioning the plot in the chart area
Resizing the plot in the chart area
Resizing the chart in the worksheet
Positioning the chart in the worksheet

Types of graphs

How to make a line chart

How to make a scatter plot

How to make a bar chart (vertical)

How to make a pie chart

Working with Images

Inserting Images

Resizing Images

Rotating Images

Aligning Images

Components

Inserting AutoShapes

Changing Autoshape properties

Inserting 3D Text

Changing auto text properties
Positioning components in the worksheet

Basic Tools

Setting editing permissions

Sending your workbook as an email
Researching words and phrases

Inserting a hyperlink

Removing a hyperlink

Convert to flash paper swf file

Convert to a pdf file