Free Microsoft Office Training and MS Windows Training
HOME  |  Premium Edition IT Training Courses  |  FAQs  |  Schools, Colleges & Computer Training Companies  |  Contact Us  | Terms  |  Link to Us 

Free computer tutorials & full computer training courses, inc. Microsoft Word training, Excel training & MS Project training.  Other IT training courses include Microsoft Windows.

 

FREE 
Online Computer Training Courses for Microsoft Office and Microsoft Windows

Excel 20007 Foundation Training Course

Microsoft Excel 2007
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
            Summing 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
Using Excel
      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
Worksheets
      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
Formatting
      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 and Functions
      Formulas
            Creating formulas
            Easy way to create formulas
            Copying formulas
            Operators
            Formula error messages
      Relative, mixed and absolute cell referencing
            Relative cell referencing within 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
Charts
      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 the column, bar, line or pie slice colors in a chart
            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
Printing
      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

    

FOR INDIVIDUAL USE ONLY – NOT TO BE DOWNLOADED
Copyright 'Best Computer Training Courses' - www.BestComputerTrainingCourses.com

Microsoft Excel Training Courses

Other Computer Tutorials

 
 

 
 

Free Microsoft Office & Microsoft Windows computer training courses inc. Microsoft Word training courses, Excel training courses, PowerPoint training courses.  Microsoft Office 2010 & Windows 7 manuals also available. 
© 2011 Best Computer Training Courses - Search Engine SEO by http://www.WebSiteSEOAustralia.com.au

  

www.BestComputerTrainingCourses.com