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 Advanced Training Course

Microsoft Excel 2003
Course Basics
      Toolbars
            The Title Bar
            The Menu Bar
            The Tool Bar
      Installing the Sample Files
Importing Data
      Importing Data from External Sources
            Using Database Terminology
             Importing Data into Excel
      Importing Text Files
            Importing text files into Excel
            Importing text using the Text Import Wizard
            Refreshing data from imported text files
      Using Microsoft Query
            Adding a Data Source
            Creating a Query
      Querying Data from the Web
            Using Web Queries
            Accessing the New Web Query dialog box
            Creating a new Web Query
            Saving a Web Query
            Setting Web Query options
            Running a saved Web Query
            Refreshing a Web Query
      Refreshing Data
            Refreshing external data without losing the formatting
            Refreshing external data automatically
      Review Questions
Templates and Styles
      Working with Templates
            Using Templates
            Creating a Template
             Applying Templates
      Working with Styles
            Using Styles
            Creating a Style
            Applying a Style
            Editing a Style
            Deleting a Style
            Copying Styles from another Workbook
      Review Questions
Analyzing Data
      What-If Analysis
            Using What-If Analysis
      Goal Seek
            Using Goal Seek
            Applying Goal Seek
      Data Tables
            Using Data Tables
            Creating a one-variable Data Table
            Creating a two-variable Data Table
            Speeding up calculations with Data Tables
      Scenario Manager
            Using Scenario Manager
            Adding a Scenario
            Showing a Scenario
            Deleting a Scenario
            Editing an existing Scenario
            Summarizing Scenarios
      Solver
            Using Solver
            Installing Solver
            Applying Solver
            Changing a Constraint
            Deleting a Constraint
      Using Pivot Tables
            Understanding Pivot Tables
             Creating Pivot Tables
            Dropping data into Pivot Tables
            Modifying data and refreshing Pivot Tables
            Grouping data within Pivot Tables
      Review Questions
Macros and Custom Controls
      Working with Macros
            Using Macros
            Recording a Macro
            Assigning a shortcut key to your Macro
      Running Macros
            Running a Macro using the main menu
            Running a Macro using a shortcut key
            Running a Macro using a button
      Adding Custom Controls
            Working with Buttons
            Creating a new Button
            Renaming a Button
            Formatting Buttons
            Linking an existing Macro to a Button
            Deleting a Button
      Review Questions
Security and Proofing
      Security Features
            Working with Security Features
      Protecting Excel Files
            Specifying a password for opening a workbook
            Specifying a password for saving a workbook
            Removing a Workbook Password
            Using the Read-only option
            Creating backup files automatically
      Worksheet Protection
            Protecting Worksheets
            Un-Protecting Worksheets
            Protecting Cells
      Working with Digital Signatures
            Using Digital Signatures
            Signing a File
            Removing a digital signature from a file
      Checking Spelling
            Using the Spell Checker
      Using Data Validation
            Setting data validation
            Creating the Input Message
            Displaying an Input Message
            Creating the Error Alert
            Displaying an Error Alert
      Using Text To Speech
            Reading back a group of cells
            Using Speak On Enter
            Turning off Speak On Enter
      Documentation
            Working with Comments
            Adding a Comment
            Displaying a Comment
            Editing a Comment
            Deleting a Comment
      Review Questions
Customizing Excel 2003
      Configuring Excel 2003 Options
            Customizing Excel Options
            Customizing View Options
            Customizing Calculation Options
            Customizing Edit Options
            Customizing General Options
            Customizing Transition Options
            Customizing Custom Lists Options
            Customizing Chart Options
            Customizing Color Options
            Customizing International Options
            Customizing Save Options
            Customizing Error Checking Options
            Customizing Spelling Options
            Customizing Security Options
      Customizing the Excel Environment
            Displaying Toolbars using the Customize dialog box
            Creating a Custom Toolbar
            Adding a Menu to a Toolbar
            Attaching a Toolbar
            Deleting a Custom Toolbar
            Resetting a Menu
            Resetting a Toolbar
      Working with Workspaces
            Using Workspace files
            Saving your Workspace
      Review Questions
Collaboration and Consolidation
      Sharing Workbooks
            Using Shared Workbooks
            Allowing Workbook Sharing
            Customizing Workbook Sharing Options
            Comparing and Merging Shared Workbooks
      Sending Workbooks
            Sending Workbooks for Review
            Sending a Worksheet as Attachment
            Routing a Workbook
            Routing a Workbook to the next recipient
      Consolidation
            Consolidating
            Consolidating data over several Worksheets
            Consolidating selected rows and columns from several Worksheets
      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