Microsoft Excel 2003 Training

Our Microsoft Excel Training teaches you about spreadsheet capabilitiesof the software and the powerful tools for creating and sharing professional worksheets online and on the Web. Our training covers basic spreadsheet concepts, workbook and file management, using formulas and functions, editing and formatting tools, working with graphics and charts, online collaboration, and working on the Web.

Our Microsoft  Office Excel Training combines audio, animation, and software simulation with a unique user interface to make the "discovery" of computer programs both effective and entertaining. The products are also designed to help users learn at their own pace, allowing them to repeat topics or jump to anywhere in the course. You will find our interface is intuitive and easy to use: The Main Menu displays all the categories within the course. The topics within each category provide detailed explanations and examples, as well as hands-on exercises, so users can practice what they're learning. After completing all the topics in a category, users can find out how much they've learned by taking the Category Quiz. They can also test their overall knowledge of Excel 2003 at any time by accessing the global Test feature. Our unique Glossary provides a quick reference of terms. In many cases, users can jump directly to the exact portion of the course for a more detailed explanation. A detailed Help function is always available to ensure users never lose their way.

Our Training Course Features

FREE Microsoft Office Demo Email:   For Email Marketing you can trust

• Training done in full multi-media flash format
• Over 12 hours of training
• Covers Beginner to Advance Levels
• Interactive Exercises- allows you to practice what you have learned
• Review Questions
• Microsoft Office 2003 Software not required
• Covers 100% of the objectives of Microsoft's requirements for Office training
  MOS Microsoft Office Specialist
• Available as single user CD-ROMs, Library License and Network Version
• Used by Thousands of Companies -

Microsoft Office Excel 2007
Microsoft Excel 2000
Microsoft XP (2002)

Microsoft Excel 2003 Training CDs Single License	dsec03cd	$99.95
Microsoft Excel 2003 Training CDs Library License Details	dsec03lb	$299.95

Library License- This licensing allows you to train an unlimited amount of users on a single computer or for the training to be kept at a single location and individuals would take the training CDs to their individual computer  or workstation to do their training. The Training CDs can not be loaded to a server, installed on the internet or intranet.

Microsoft 2003 Excel Training Course contains the Following

Proficient Level Expert Level EXCEL 2003 BASICS Introducing Excel 2003 Office 2003 Overview Excel 2003 Overview Screen Layout Title Bar, Menus & Toolbars The Task Pane Create & Open A Workbook What Is A Workbook? Creating A New Workbook Use A Template Open An Existing Workbook Closing A Workbook View A Workbook What Is A View? Page Break Preview Custom Views Splitting A Worksheet Freeze Rows & Columns Comparing Workbooks Save A Workbook The Save & Save As Commands Save A Workbook For Use In Another Program Print Workbooks Print Worksheet & Workbooks Modify Page Setup Set Print Area Help in Excel 2003 Microsoft Office Online Type A Question For Help Excel Help Task Pane Detect And Repair WORK WITH CELLS Cell Basics What Is A Cell Reference? Select Cells Navigating A Worksheet Enter Data Entering Data What Is A Value? What Is A Label? Edit Data Edit Worksheet Data Find & Replace Data Copy And Move Data Copying & Moving Data Copy & Move Data Use The Office Clipboard Insert & Delete Cells Insert & Delete Cells CALCULATE YOUR DATA Formulas What Is A Formula? Create A Formula Edit A Formula Cell References Types Of Cell References Using Relative References Use Absolute References Mixed References Functions What Is A Function? Enter A Function Manually Insert A Function Use A Date Function Financial Functions Use A Financial Function Logical Functions Use A Logical Function WORK WITH YOUR WORKBOOK Modify A Worksheet Insert/Delete Rows & Columns Resizing Rows & Columns Resize Rows & Columns Hide Rows & Columns Modify A Workbook Insert & Delete A Worksheet Move/Copy A Worksheet To Another Workbook Rename A Worksheet Format Worksheet Tabs FORMAT A WORKSHEET Format Characters Formatting Text & Numbers Format Text Formatting Numbers Format Numbers Use A Custom Number Format Format Cells Formatting Cells Aligning Cell Content Align Cell Content Merge Cells Apply Borders & Shading Format Painter Clear Cell Formatting Find & Replace Cell Formatting AutoFormat Use AutoFormat WORK WITH GRAPHICS Work With Graphics Graphics In Excel Insert Clip Art Add Charts Adding Charts The Chart Wizard Modify A Chart AUTOMATE YOUR WORK AutoFill What Is AutoFill? Use AutoFill AutoComplete Using AutoComplete AutoCalculate Use AutoCalculate COLLABORATE WITH OTHERS Collaborate On Workbooks Distributing Workbooks E-Mail A Workbook Work With Comments Add Comments To A Worksheet CUSTOMIZE EXCEL 2003 Advanced Features & Customization Advanced Features Customizing Excel Customize Menus The Menu Bar Creating Custom Menus Customize Toolbars Toolbars Customize A Toolbar Create A New Toolbar CALCULATE YOUR DATA Work With Named Ranges Using Named Ranges Range Naming Rules Create Range Names Using Labels Define Range Names For Data Without Labels Use A Named Range In A Formula Viewing Named Ranges In A Worksheet Use Subtotals Add Subtotals To A Worksheet Use Lookup Functions What Is A Lookup Function? The VLOOKUP Function Use The VLOOKUP Function Find & Correct Errors Auditing Worksheets Trace Precedents & Dependents Trace Errors Use Data Validation Circle Invalid Data MANAGE & ANALYZE DATA Create & Filter Lists What Is A List? Use A Data Form Use The List Feature AutoFilter & Advanced AutoFilter Sort List Data Sort Data Subtotal Columns Outline A Worksheet Using Outlines30 Add & Remove An Outline Outline A Worksheet Manually Query External Databases Use The Query Wizard XML Documents What Is XML? Save A Workbook As An XML Document Goal Seek & Solver Use Goal Seek Use Solver Scenarios What Is A Scenario? Create & View Scenarios Link & Consolidate Data Data Consolidation Consolidate Data Link Consolidated Data Consolidate Data From Multiple Workbooks PivotTables & PivotCharts Using PivotTables & PivotCharts Create A PivotTable Modifying A PivotTable Create A PivotChart FORMAT A WORKSHEET Conditional Formatting What Is Conditional Formatting? Use Conditional Formatting Styles What Is A Style? Create & Apply A Style USE MACROS Create Macros What Is A Macro? Record A Macro Absolute Vs. Relative Recording Work With Macros Assign A Macro Edit A Macro "Step Into" A Macro Macro Security MANAGE DATA & WORKBOOKS Link & Consolidate Data Data Consolidation Consolidate Data Link Consolidated Data Consolidate Data From Multiple Workbooks Import & Export Data Use The Office Clipboard Import Data From Text Files Import Data From Other Applications Import Data From The Web Export Data To Other Applications COLLABORATE WITH OTHERS Share Workbooks Create A Shared Workbook Resolve Conflicts Track Changes In A Shared Workbook Track Changes View The Change History Workbook Protection & Properties Worksheet Protection Protect Cells In A Worksheet Apply Workbook Protection Apply Password Protection Workbook Properties Change Workbook Properties EXCEL & THE WEB Create Web Pages Publish A Worksheet To The Web Create Hyperlinks Publish A PivotTable To The Web Using Smart Tags To Retrieve Web

This Study guide and/or material is not sponsored by, endorsed by or affiliated with Cisco Systems, Inc. Cisco®, Cisco Systems®, CCDA™, CCNA ™, CCDP™, CCNP ™, CCIE™, CCSI™, the Cisco Systems logo and the CCIE logo are trademarks or registered trademarks of Cisco Systems, Inc.

sales@cdicomp.com
webmaster@netwind.com
Copyright  © CDi Communications Inc. 1996-2003
Netwind Learning Center is a registered trademark of CDi Communications, Inc.