Excel Tutorials

	Microsoft Excel 2002 Tutorials Code:VTC-33440 Price: $89.95 Quantity in Basket: none
Microsoft Excel 2002 Tutorials Producer: See all VTC titles Media: CD-ROM Author: Julia Kelly ISBN: 1932072403 Duration: 6.5 hrs / 109 lessons Compatibility: Win XP, ME, 2000, 98, NT, Mac OS X, OS 9 Microsoft Excel 2002 offers tools that make it easy to access, connect, and analyze critical data, proving that Excel spreadsheets are no longer just for financial professionals. Virtual Training Company author Julia Kelly will instruct users on how to use this powerful spreadsheet program. Excel 2002 allows users to find and format data more quickly by utilizing context sensitive options as tasks are being performed. The new Error Checking smart tag feature allows users to fix, or ignore an error. Document Recovery automatically saves current workbooks, protecting your work. Refreshable queries allow users to integrate live data from the Web, or any other source. To get started, simply click on one of the movie topics below. Try For Free Right Now To help you evaluate this training program, some of the tutorials may be viewed for free online. Listed below are all of the chapters and lessons for this title. Click on any of the linked lessons below to watch them now online! CD Contents Introduction About Excel (07:02) Open/ Save/Close Workbooks (03:20) What’s Inside the Workbook (04:10) Menus and Toolbars (04:18) What’s on a Worksheet (03:01) Getting Assistance from Excel (03:17) Getting Started Select and Navigate Cells (04:25) Enter Data (03:13) Edit and Delete Data (03:38) Undo and Redo (02:59) Cut/Copy/Paste (03:03) About the Office Clipboard (03:19) Drag and Drop (03:21) AutoFill (04:09) More Ways to Enter Repetitive Data (03:32) AutoCorrect (03:41) Use a Data Entry Form (02:57) Validate Data During Entry (03:35) Working With Worksheets Resize Rows and Columns (04:19) Insert and Delete Rows/Columns/Cells (05:03) Rename Worksheets (03:39) Move and Copy Worksheets (03:10) Insert and Delete Worksheets (02:34) Freeze and Split a Worksheet (03:31) Open Multiple Windows (03:32) Simple Calculations Calculate Without a Formula (03:03) Use AutoSum to Write Formulas (03:37) Formula Structure (05:32) Create Formulas (03:56) Edit Formulas (03:06) AutoFill Formulas (05:07) Relative and Absolute References (02:58) Functions (04:16) Use the Function Wizard (04:14) Name Cells and Ranges (03:22) Use Names in Formulas (03:37) Using Advanced Functions AVERAGE/MAX/MIN (02:52) SUMIF and COUNTIF (03:54) VLOOKUP (04:22) PMT (04:41) NOW/ TODAY/CONCATENATE (05:25) IF and Nested Functions (04:31) Organizing Data Sort Data (04:41) Filter Data with AutoFilter (03:25) AND and OR Filters (03:44) Calculate Filtered Records (04:49) PivotTables (05:56) Consolidate Data (03:49) Subtotal a Worksheet (04:58) Formatting Cells Text Formatting (04:57) Align and Wrap Text (04:18) Number Formats (05:14) Date and Time Formats (05:14) Custom Formats (04:12) Borders and Shading (05:16) Conditional Formatting (04:23) Format Painter (03:52) Styles (05:31) AutoFormat a Table (02:41) Transpose Tables and Merge Cells (03:09) Format Several Worksheets Identically (03:07) Save a File as a Template (04:34) Charting Data About Charts (04:30) Create a Chart (04:15) Resize and Relocate a Chart (03:42) The Chart Toolbar (03:13) Chart Options (03:20) Legends/Titles/Axes (03:13) Series Orientation and Order (03:09) Create 3-D Charts (03:56) Explode a Pie Chart (04:01) Add Data Labels and a Data Table (04:34) Trendlines (03:14) Secondary Axes (03:23) Format Chart Elements (04:27) Printing Data and Charts Create Page Headers and Footers (03:38) See a Print Preview (04:50) Set the Print Area (04:15) Print a Selection (02:59) Centering/ Margins/Gridlines (04:06) Print on a Specific Number of Pages (03:41) Print Multiple Worksheets/Copy/Collate Pages (03:13) Print Row and Column Labels on Every Page (04:18) Print Charts (04:59) Sharing and Protecting Data Share Data Between Workbooks (04:31) Copying/Linking/Embedding Data (06:04) Share Data with Other Programs (04:52) Share a Workbook with Other Users (03:17) Hide Worksheets (03:27) Protect Cells (03:11) Protect Worksheets and Workbooks (05:46) Analyzing Data Use Goal Seek to Find Answers (03:35) Use Scenarios to Compare Alternatives (04:41) Locate Worksheet Errors and Invalid Data (04:54) Customizing Excel Customize Your Toolbars (04:09) Create a Custom Toolbar (05:15) Automate with Macros (03:31) Record a Macro (05:00) Edit a Macro (05:04) Assign a Macro to a Toolbar Button (04:50) Create a Hyperlink to Open Another File (04:10) Graphics and The Drawing Toolbar Insert a Picture (04:52) Move/Resize/Crop (05:38) Draw Shapes and Lines (05:18) Draw AutoShapes and Assign Macros (04:30) Arrange and Group Drawing Objects (04:39) Use Drawn Objects in Charts (02:46) Create Text Boxes (04:41) Create Worksheet Comments (03:46) To view the Free Tutorials you must have Quicktime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality. Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.
	Microsoft Excel 2003 Tutorials Code:VTC-33508 Price: $89.95 Quantity in Basket: none
Microsoft Excel 2003 Tutorials Producer: See all VTC titles Media: CD-ROM Author: Kate J. Chase ISBN: 1932072977 Duration: 6 hrs / 117 lessons Compatibility: Win XP, ME, 2000, 98, NT, Mac OS X, OS 9 Excel 2003 enables you to turn data into information with powerful tools to analyze, communicate, and share results. Excel 2003 can help you work better in teams, and help protect and control access to your work. In addition, you can work with industry-standard Extensible Markup Language (XML) data to make it easier to connect to business processes. Author Kate J. Chase's extensive knowledge of Excel 2003 will have you using it like a pro by the end of the tutorial. From simple spreadsheets to complex databases, it is all covered in VTC's Microsoft Excel 2003 tutorial. To begin learning today, simply click on the links below. Try For Free Right Now To help you evaluate this training program, some of the tutorials may be viewed for free online. Listed below are all of the chapters and lessons for this title. Click on any of the linked lessons below to watch them now online! CD Contents Introduction To Excel 2003 First Glance at Excel 2003 (02:50) Why Choose Excel 2003? (04:27) About Spreadsheets (02:27) Touring Excel – Pt.1 (03:10) Touring Excel – Pt.2 (03:49) Features New to Excel 2003 (03:24) Installing Excel 2003 Recommendations Before You Install (03:27) Minimum System Requirements (03:03) Using Excel Setup (03:37) Troubleshooting Excel 2003 Installation (04:18) Performance Issues with Excel 2003 (03:42) Getting Assistance With Excel 2003 Ways to Increase Your Aptitude (02:29) Exploring the Assistance Menu (03:13) Type a Question for Assistance (02:51) Using Microsoft Office Online (03:17) Excel 2003 Basic Concepts Worksheets and Workbooks (02:52) Organization (02:03) Differences Between Text & Data Values (03:05) Labels and Names (03:21) More About Labels (02:28) More about Cells and Cell Ranges (02:34) About Mathematical Operators & Operands (03:03) About Formulas & Calculations (02:13) The Role of Functions (03:21) Types of Charts (02:05) Forms/Including Data Forms (02:48) The Job of Queries (02:25) What are Workbook Audits (02:47) Importing and Exporting (01:57) Linking and Embedding (01:35) Absolute vs Relative Cell References (03:11) What About Smart Tags? (02:14) What is XML? (02:29) Locking/Freezing Cells/Splitting Work Area (03:31) About Excel Security (02:53) First Hands On In Excel Launching Excel 2003 (03:19) Planning Your Worksheet or Workbook (01:54) Labeling & Naming Worksheet/Workbook (03:38) A Look at Our Example Layout (02:51) Naming and Saving Your Workbook (02:59) Renaming and Deleting a Workbook (02:58) Printing Your Workbook (02:00) Double Check Workbook & Exit (02:58) Opening an Existing Workbook (02:14) Customizing Excel 2003 About Excel Customization (01:39) Customizing Excel Menu Bar (02:01) Customizing Excel Toolbars (04:31) Changing Page Setup (02:32) Modifying Default Location of Saved Work (03:23) Setting Up Options – Pt.1 (02:20) Setting Up Options – Pt.2 (03:14) Entering Your Information About Entering Your Information (03:35) Entering Labels and Values (04:02) More About Multiple Entries (02:55) Understanding Multiple Selections (02:27) Inserting/Deleting Rows & Columns (03:07) Copying & Pasting Columns/Rows & Cells (04:06) Moving Columns/Rows & Cells (03:05) Adding a Smart Tag (03:59) Editing Your Work (03:53) Formatting Your Work Introduction to Formatting (02:45) Formatting Text & Data Pt.1 (03:58) Formatting Text & Data Pt.2 (04:46) Using AutoFormat (02:09) Changing AutoFormat Options (02:09) Adding Colors and Patterns (03:04) Adding Borders (03:17) What is Conditional Formatting? (02:30) Applying Conditional Formatting (03:11) Copying Cell Formatting (02:34) About Styles (02:00) Creating a Style (03:15) Applying and Modifying a Style (02:52) Adding Elements To A Workbook Introduction to Adding Elements (02:30) Adding Images to a Workbook (03:42) Modifying Images Inserted in Workbook (04:14) Adding Clips (02:37) Diagramming in Excel (04:15) Adding an Organizational Chart (02:15) Changing an Organizational Chart (02:08) Adding WordArt (03:10) Adding a Hyperlink (04:03) Inserting Objects Such as AutoShapes (05:04) Calculation With Formulas and Functions About Formulas and Calculation (02:12) Creating a Formula – Pt.1 (03:50) Creating a Formula – Pt.2 (03:19) Spotting Problems & Editing a Formula (04:04) More About Functions (05:10) Managing Data With Excel Use it or Lose it (04:29) Using Forms/Particularly Data Forms (03:06) Entering Data Using a Data Form (03:38) Managing Data from a Data Form (02:21) About Using Excel as a Database (02:10) What are Lists? (03:47) Creating a List (05:22) Entering Data into a List (02:58) Sorting Data in a List (03:22) Using Filters to Sort Lists (04:43) Auditing Excel Data (03:50) Other Validation and Error Checking (04:26) More About Validation for Data Entry (02:55) Performing Queries (04:01) Exporting Data from Excel (01:56) Linking Data Pt.1 (05:37) Linking Data Pt.2 (03:47) Working With Charts About Charts (02:24) Creating Your Chart (03:40) Modifying & Relocating Your Chart (03:17) Other Changes to Your Chart (02:56) Sharing & Collaborating With Excel 2003 Sharing Your Worksheet or Workbook (02:11) Sending Your Workbook for Review (02:39) Using Online Collaboration (02:32) Protecting Your Workbook (03:10) Change Different Versions of a Workbook (03:57) Adding/Editing/Deleting Comments (03:38) Creating & Sharing a Workbook Template (04:10) Credits About this Author (01:51) To view the Free Tutorials you must have Quicktime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality. Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.