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
- 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 -
- Inquire about our Network Licenses and Learning Management Software (LMS).
Please Note***Demo requires a popup window. Please turn off your Browser's popup blocker as well as the popup blocker in your Google toolbar if you have one running.
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
|
|
|
Microsoft Office 2003 Training On CD-ROMs Access, Excel, Oulook, PowerPoint and Word
|
dsof03cd
|
$369.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
|
|
|