Home   Technology Courses   Management Courses   Certification   MyHistory  Course Schedule   Free Catalog   About Us   What's New   Contest   Contact Us Photo Galary

Microsoft Excel 2007 Foundation Level A FIRST LOOK AT EXCEL Starting the Excel program What is the Active Cell? The Excel cell referencing system Entering numbers and text Default text and number alignment Adding a column of numbers Worksheets and Workbooks Saving a workbook Closing a workbook Creating a new workbook Opening a workbook Switching between workbooks Saving a workbook using another name Saving a workbook using a different file type HELP Getting help Searching for Help The Help 'Table of Contents' Printing a Help topic Alt key help SELECTION TECHNIQUES Why are selection techniques important? Selecting a cell Selecting a range of connecting cells Selecting a range of non-connecting cells Selecting the entire worksheet Selecting a row Selecting a range of connecting rows Selecting a range of non-connected rows Selecting a column Selecting a range of connecting columns Selecting a range of non-connecting columns MANIPULATING ROWS AND COLUMNS Inserting rows into a worksheet Inserting columns into a worksheet Deleting rows within a worksheet Deleting columns within a worksheet Modifying column widths Modifying column widths using 'drag and drop' Automatically resizing the column width to fit contents Modifying row heights COPYING, MOVING AND DELETING Copying the cell or range contents Deleting cell contents Moving the contents of a cell or range Editing cell content Undo and Redo AutoFill Sorting a cell range Searching and replacing data MANIPULATING WORKSHEETS Switching between worksheets Renaming a worksheet Inserting a new worksheet Deleting a worksheet Copying a worksheet within a workbook Moving a worksheet within a workbook Copying or moving worksheets between workbooks FONT FORMATTING Font type Font size Bold, italic, underline formatting Cell border formatting Formatting the background color Formatting the font color ALIGNMENT FORMATTING Aligning contents in a cell range Centering a title over a cell range Cell orientation Text wrapping Format painter NUMBER FORMATTING Number formatting Decimal point display Comma formatting Currency symbol Date styles Percentages FREEZING ROW AND COLUMN TITLES Freezing row and column titles FORMULAS Creating formulas Easy way to create formulas Copying formulas Operators Formula error messages CELL REFERENCING Relative cell referencing within in formulas Absolute cell referencing within formulas FUNCTIONS What is a function? Common functions Sum function Average function Max function Min function Count function What are 'IF functions'? Using the IF function USING CHARTS Inserting a column chart Inserting a line chart Inserting a bar chart Inserting a pie chart Resizing a chart Deleting a chart Chart title or labels Chart background color Changing a column, bar, line or pie slice colors Changing the chart type Modifying Charts using the Layout tab Copying and moving charts within a worksheet Copying and moving charts between worksheets Copying and moving charts between workbooks CUSTOMIZING EXCEL Modifying basic options Minimizing the Ribbon AutoCorrect options WORKSHEET SETUP Worksheet margins Worksheet orientation Worksheet page size Headers and Footers Header and footer fields Scaling your worksheet to fit a page(s) PREPARING TO PRINT A WORKSHEET Visually check your calculations Gridline display when printing Printing titles on every page when printing Printing the Excel row and column headings Spell checking Previewing a worksheet Comparing Workbooks side by side Zooming the view Printing options

Copyright ©2008, www.galaxy.ps

Designed By: Mohammed Fuqaha