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 2003 Foundation Training Course

Microsoft Excel 2003
Course Basics
      Toolbars
            The Title Bar
            The Menu Bar
            The Tool Bar
            The Status Bar
            The Scroll Bar
      File Management
            Opening Files
            Saving Files
            Closing Files
      Installing the Sample Files
Introduction to Microsoft Excel 2003
      What is Excel?
            Microsoft Excel 2003
            Using Excel as a Spreadsheet
            Using Excel as a Database
            Analyzing Data
            Microsoft Web Site
      Excel File Types
            Spreadsheet files
            Online Publishing files
            XML files
            Template files
      Excel Environment
            Working with the Excel window
            Using the Formula Bar
             Using the Task Pane
             Using the Getting Started Pane
            Using the Microsoft Excel Help Pane
             Using the Search Results Pane
             Using the Clip Art Pane
            Searching for a Clip Art
            Customizing the search
            Searching using Organize Clips
             Using the Research Pane
            Using the Clipboard Pane
            Using the New Workbook Pane
            Using the Status Bar
            Exiting Excel 2003
      Toolbars
            Using Toolbars
            Showing a Toolbar
            Hiding a Toolbar
            Moving a Toolbar
             Using the Standard Toolbar
            Using the Formatting Toolbar
      Office Assistant
            Microsoft Office Assistant
            Displaying the Office Assistant
            Displaying Tips
            Using Tips of the Day
            Hiding the Office Assistant
            Customizing the Office Assistant
      Review Questions
Workbooks and Worksheets
      Creating and Opening Workbooks
            Creating a new Workbook
             Creating a new Workbook using a template on your computer
            Creating a new Workbook using an online template
            Opening an existing Workbook
      Working with Workbooksq
            Understanding Workbooks and Worksheets
            Minimizing a Workbook
            Saving Workbooks
            Saving a backup copy
            Saving Summary Information
            Closing Workbooks
      Working with Worksheets
            Zooming the Worksheet View
            Renaming Worksheets
            Changing the Sheet Tab color
            Inserting Worksheets
            Reordering Worksheets
            Deleting Worksheets
            Customizing Worksheet Views
      Working with Cells
            Understanding Cells and Ranges
            What is the Active Cell?
      Navigating within a Worksheet
            Navigating to a specific cell
            Moving around the Worksheet
            Moving within a selection
      Navigating the Workbook
            Navigating between Worksheets using the mouse
            Moving between Worksheets using the keyboard
            Moving from one Workbook to another
             Comparing two workbooks side-by-side
      Review Questions
Spreadsheet Data
      Entering Data
            Entering text
            Entering numbers as numeric values
            Entering numbers as text
            Entering dates
            Entering current date
            Entering current time
            Customizing the movement of the active cell
            Entering data into a range of cells
            Filling a range of cells with the same data
      Using Time Saving Features
            Using Auto Complete
            Using a Pick List
            Using AutoCorrect
            Viewing items that will be corrected
            Adding items to AutoCorrect
            Deleting an AutoCorrect item
            Using Smart Tags
            Turning Smart Tags on
             Enabling Date and Person Name Smart Tags
      Checking the Spelling
            Checking spelling in a Worksheet
            Correcting spelling errors
      Review Questions
Formatting and Customizing Data
      Selecting Items in Excel
            Selecting a Cell
            Selecting a Row
            Selecting a Column
            Selecting a Range
            Selecting a non-contiguous Range
            Selecting an entire worksheet
            Selecting several Worksheets
            Selecting all Worksheets
      Formatting Text
            Changing the Font
            Changing the Font size
            Changing the Font style
            Changing the Underline
            Changing the Font effects
            Resetting Font formatting
            Changing the default Font characteristics of the current workbook
            Changing the default Font in new workbooks
      Formatting Numbers
            Formatting numbers using the Formatting Toolbar
            Applying the Currency Format
            Applying the Percent Format
            Applying the Number Format
            Applying custom formatting
            Setting fixed decimal places for numeric values
      Manipulating Data
            Aligning data horizontally within a cell
            Aligning data vertically within a cell
            Centering headings over multiple columns
            Wrap multiple lines of data in a cell
            Indenting data within a cell
            Changing the text orientation
      Formatting Columns and Rows
            Changing the Column width numerically
            Changing the Column width visually
            Changing Column width to fit data
            Setting the default Column widths
            Changing the Row height numerically
            Changing the Row height visually
            Changing the Row height to fit data
      Formatting with Colors and Patterns
            Changing the color of your text
            Applying fill color to cells
            Removing fill color from cells
            Applying pattern to cells
            Removing pattern from cells
      Adding and Editing Borders
            Selecting a Border style
            Applying Borders
            Removing Borders
            Changing the style and color of Borders
      Using AutoFormat
            Applying AutoFormat
      Review Questions
Editing Spreadsheets
      Cutting, Copying, and Pasting
            Cutting data
            Copying data
            Pasting data
            Inserting copied Cells
            Copying multiple items to the Office Clipboard
            Pasting items from the Office Clipboard
            Deleting items from the Office Clipboard
            Copying data by dragging and dropping
            Copying data over several cells
            Copying an object to another Worksheet location
      Inserting and Deleting
            Inserting Rows
            Inserting Columns
            Inserting Cells
            Deleting Rows or Columns
            Deleting the contents of a Cell or Range
            Deleting data without deleting the cell formatting
            Removing cell formatting without deleting the data
            Deleting Cells
            Deleting Objects
      Using Find and Replace
            Searching for text or numbers
            Replacing text or numbers
      Using Undo and Redo
            Undoing the last action
            Undoing multiple actions
            Redoing the last Undo
            Redoing multiple Undos
      Review Questions
Formulas and Functions
      Entering Formulas
            Understanding a Formula
            Using the Formula toolbar
            Entering a Formula
            Entering a Cell or Range reference
            Using relative and absolute Cell references
            Editing Formulas
      Entering Functions
            Understanding a Function
            Entering Functions
            Using the AutoSum Functions
            Using the SUM Function
            Using the AVERAGE Function
            Using the COUNT Function
            Using the MAX Function
            Using the MIN Function
      Using Named Cells and Ranges in Formulas
            Choosing names for Cells and Ranges
            Naming Cells or Ranges
            Navigating Workbooks using Cell or Range names
            Creating named Ranges based on Cell values
            Deleting named Cells or Ranges
            Using named Cells and Ranges in Formulas
      Review Questions
Printing
      Using Page Setup
            Changing page orientation
            Setting the scale of the page
            Setting paper size
            Setting print quality
            Beginning page numbering with a different number
      Margins
            Changing the Margins
            Changing the Header and Footer Margins
            Changing the Margins in Print Preview
            Centering the data on a page
      Headers and Footers
            Using standard Headers and Footers
            Creating custom Headers or Footers
      Printing a Spreadsheet
            Setting the print area using Print Area
            Setting the print area using Page Setup
            Printing Row or Column titles on every page
            Selecting elements to print
            Previewing a Worksheet
            Setting the order pages are printed
            Printing a Workbook
      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