The Excel Environment Opening Excel Creating a new Workbook Opening a Workbook Saving Workbooks Closing Excel Closing multiple workbooks Zooming in a spreadsheet Using the help window using the undo button using the redo button Lising shortcut keys Editing a template Using the vertical scroll bar Using the horizontal scroll bar

The Excel Windows Showing the Application control menu Showing the workbook control menu Showing the workbook shortcut menu

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 size groups of cells Numerically size groups of rows Numerically size groups of rows Setting a background image Merge and center text Unmerge cells Creating a cell outline I Creating cell borders I Remove cell borders I Filling a cell with color

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 Decrease decimal places Increase decimal places Formatting to Percentages I Formatting to Currency I Formatting numbers using commas 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

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

Language Settings 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

f x Basic Functions   Entering formulas using the function wizzard Using The Autosum button Using AutoCount Using AutoAverage Using AutoMin Using AutoMax The SUM function The AVERAGE() Function The COUNT() function The MAX() function The MIN() functions The SQRT() function The FACT() function The ROUND() function The ROUNDUP() function The ROUNDDOWN() function The ABS() function Using the DATEVALUE() function

Working with Images Showing the picture toolbar I Showing picture toolbar II Inserting a picture from a file I Inserting a picture form file II Cropping pictures I (crop tool) Cropping picture (properties) Resizing pictures I (drag) Reszing pictures II (properties) Rotating pictures I (handle) Rotating pictures II (toolbar) Rotate picture III (properties) Changing a picture to greyscale I Changing a picture to greyscale II Creating a color washout effect Creating a color washout effect Setting a color to transparent Adjusting picure brightness I Adjusting picure brightness II Adjusting picture contrast Image I Adjusting picture contrast Image II Positioning Positioning pictures in the page

ClipArt Inserting clipart I (toolbar) Inserting clipart II (menu) Inserting clipart from the web Resizing clipart I (drag) Resizing clipart II (properties) Converting a clipart picture to drawing Editing a clipart element color Editing clipart element size Editing cliapart element points Deleting a clipart element Regrouping elements after editing

Chart & Diagrams Inserting diagram (tree) Adding parent nodes Adding sister nodes Adding child nodes manually setting node position Inserting a venn diagram Changing circle colors Changing cirsle tranparency Adding text boxes

Intro to Charts Showing the chart tool bar Chart Type Index page Embedding a simple graph Creating a new worksheet for a chart How quick graph data

Formatting Charts Formatting Charts Main 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 size Changing the grid color Removing the grid Changing the background color Changing background to 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 column How to make a pie chart

Drawing Show the drawing toolbar I Showing the drawing toolbar II Drawing lines Setting line color Setting line style Drawing arrows and setting arrow style Dawing rectangles and ovals shapes Resizing shapes I Setting shape outline color Seting shape color fill Autoshapes Show autoshape toolbar I Drawing autoshape arrows Creating a shape shadow Drawing an autoshape no symbol Creating an autoshape banner

WordArt Show the wordart toolbar I Show the wordart toolbar II Insert wordart I (wordart toolbar) Insert wordart II (drawing toolbar) Insert Wordart III (main menu) Show wordart formatting widow I Show wordart formatting widow II Show wordart formatting widow III Modifying wordart color fills I Modifying wordart color fill II Changing outline color I Changing outline color II Resizing wordart I (drag) Resizing wordart II (properties) Rotating Wordart I Rotating Wordart II Wordart text shadow Wordart two color gradint fill I Wordart two color gradint fill II Wordart image fill

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

Printing Printing a selected portion of the worksheet Printing active worksheets Printing all the pages in your workbook Using quick print