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

Microsoft Excel 2003 Courseware Advanced Level 1. 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 2. 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 3. 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 4. 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 5. 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 6. 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 7. 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 data over several Worksheets Consolidating selected rows and columns from several Worksheets

Copyright ©2008, www.galaxy.ps

Designed By: Mohammed Fuqaha