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 XP Intermediate Tutorial

Microsoft Excel XP
Viewing Worksheets
      Customizing View Options
            Customizing the Excel window display
            Customizing the Comments View options
            Customizing the Objects View options
            Customizing the Worksheet View options
      Displaying and Customizing Toolbars
            Choosing a Toolbar
            Displaying Toolbars
            Customizing Toolbar Options
            Adding Commands to a Toolbar
      Hiding Workbooks and Worksheets
            Hiding a Workbook
            Hiding Worksheets
            Displaying hidden Workbooks
            Displaying hidden Worksheets
      Freezing Panes
            Freezing a horizontal pane
            Freezing a vertical pane
            Freezing horizontal and vertical panes
            Unfreezing panes
      Grouping and Ungrouping Worksheets
            Grouping Worksheets
            To select all Worksheets
            To select several Worksheets
            Ungrouping Worksheets
      Review Questions
More Formatting Techniques
      Using Styles
            Creating a new style
            Applying a style
            Changing the formatting of a style
            Removing a style from cells
            Deleting a style
      Conditional Formatting
            Using conditional formatting
            Changing conditional formatting
            Deleting conditional formatting
            Finding cells with conditional formatting
      Using the Format Painter
            Copying and applying cell formatting with the Format Painter
            Copying and applying column width or row height with the Format Painter
            Copying and applying cell formatting with the Format Painter
            Copying and applying the Format Painter in multiple locations
      Using Guidelines
            Changing the color of the Gridlines
            Turning off the onscreen Gridlines
            Printing Gridlines
      Hiding and Displaying Cells
            Hiding Columns
            Hiding Rows
            Using the mouse to hide Columns
            Using the mouse to hide Rows
            Displaying hidden Columns
            Displaying hidden Rows
            Using the mouse to display hidden Columns
            Using the mouse to display hidden Rows
      Review Questions
More Formulas and Functions
      Using the Series Command
            Using the Series Command
            Applying a list series
            Applying a numeric series
            Applying a basic numeric series
            Creating a custom list series
      Using the Insert Function Wizard
            Displaying the Insert Function wizard
            Choosing a function from the Insert Function wizard
            Entering Function Arguments in the Insert Function wizard
      Using the Excel Function Categories
            Using the Most Recently Used function category
            Using the Financial function category
            Using the Date & Time function category
            Using the Math & Trig function category
            Using the Statistical function category
            Using the Lookup & Reference function category
            Using the Database function category
            Using the Text function category
            Using the Logical function category
            Using the Information function category
      Correcting Formulas
            Finding and correcting errors in Formulas
            Finding error values
            Correcting error values
      Using the Formula Error Checker
            Using the Formula error checker
            Rechecking ignored errors
            Customizing the Formula error checker
      Using the Formula Auditing Toolbar
            Displaying the Formula Auditing toolbar
            Using the Formula Auditing toolbar
            Tracing Precedents
            Removing Precedent Arrows
            Tracing Dependents
            Removing Dependent Arrows
            Adding a new comment
            Evaluating Formulas one step at a time
      Using the Watch Window
            Using the Watch Window
            Adding a Watch to a cell
            Adding a Watch to all the cells with Formulas
            Displaying a cell in the Watch Window
            Deleting a Watch
            Hiding the Watch Window
      Review Questions
Database and List Management
      Using Databases
            Using the Excel database features
            Using database terminology
      Creating and Editing a Database
            Creating an Excel database
            Working with an Excel database
      Sorting a Database
            Sorting data within a database
            Adding other sorting criteria
      Using AutoFilters
            Filtering data
            Filtering data with AutoFilter
            Specifying a conditional filter with AutoFilter
            Using the Top 10 AutoFilter
            Removing all AutoFilters
      Advanced Filters
            Using Advanced Filters
            Removing all Advanced Filters
      Working with Filtered Data
            Manipulating Filtered Data
            Totaling fields within a filtered database list
            Creating Subtotals
            Remove Subtotals
      Using Data Forms
            Using a Data Form
            Adding a new record
            Moving between records
            Finding records
            Editing a record
            Deleting a record
            Closing a Data Form
      Review Questions
Charts
      Chart Wizard
            Using the Chart Wizard
            Selecting the Chart Type
            Specifying the Data Source
            Customizing the Chart
            Defining the Chart Location
      Chart Toolbar
            Displaying the Chart toolbar
            Using the Chart toolbar
            Selecting a Chart
            Selecting Chart objects
      Working with Charts
            Changing the Chart Type
            Adding data to a Chart
            Removing data from a Chart
            Moving a Chart
            Resizing a Chart
            Deleting a Chart
      Formatting the Chart
            Formatting the Chart Area
            Formatting the Chart Title
            Formatting the Plot Area
            Formatting the Axis
            Formatting the Axis Title
            Formatting the Legend
            Formatting the Gridlines
            Formatting the Data Series
      Review Questions
Drawing and Picture Objects
      Drawing Toolbar
            Displaying the Drawing toolbar
            Using the Drawing toolbar
      Working with AutoShapes
            Inserting an AutoShape object
            Drawing common objects
            Formatting AutoShape objects
            Selecting an object
            Changing the look of AutoShape lines
            Changing the look of AutoShape arrows
            Adding a shadow
            Applying the 3-D option
            Moving an object
            Copying objects
            Resizing an object
      Creating Text Boxes
            Creating a text box
            Editing text in a text box
            Resizing a text box
            Deleting a text box
      Adding Pictures
            Inserting Clip Art
            Inserting a picture
            Using the Picture toolbar
            Moving a clip art or picture
            Copying a clip art or picture
            Resizing an object
      Layering Objects
            Changing the layer order of objects
      Grouping and Ungrouping Objects
            Grouping objects
            Ungrouping objects
      Review Questions
Excel 2002 and Other Applications
      Converting Files from Other Applications
            Converting spreadsheets from other applications
      Copying Data from another Application
            Using the Office Clipboard
            Using Paste Special
            Using Paste Special with content from Excel
            Using Paste Special with content from other application
            Changing data to graphic objects
      Embedding and Linking Objects
            Embedding data
            Embedding an existing document
            Linking data
            Creating a link to an existing file
            Linking data from Microsoft Word
      Hyperlinks
            Using Hyperlinks
            Creating a Hyperlink
      Managing Links
            Updating Links
            Editing Links
            Checking the status of a Link
            Breaking Links
      Review Questions

    

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