Training Center
Computer Training courses online, at your pace !

Computer Training Online


Or call 800 639 0160

Course catalog - Improve Job Skills or Study For Certification Exams.                              








Excel 2000 Expert
 Join over 1 million people who learn online, with these complete interactive computer training courses.




See How It Works
This online course includes tutorials for: Time Needed
Importing and Exporting Data 4 hours
Working with Templates, Links, and Report Manager 2 hours
Formatting, Sorting, and Filtering Data 3 hours
Naming Ranges, Working with Macros, and Customizing Toolbars 5 hours
Validating and Auditing Data 2 hours
Analyzing Data and Using PivotTables 3 hours
Sharing Work and Adding Security 3 hours
Estimated time needed to complete entire course 22 hours


Receive your login ID to take the training courses online, as many times as you wish, for 1 year.  Click here for group orders.

Buy this entire online training course with one easy payment of $37

OR

Buy the Office Value pack, and receive this course plus many more, for only $97



Benefits
  • Unlimited access for 1 year
  • Learn anytime, anywhere
  • You control the pace
  • Start & stop wherever you want
  • No books to read
  • No software needed
  • Value Packs include Free online tech support
  • Double guarantee
  • 100% Money back guarantee
  • One time payment No monthly fee
  • Use the course index for review anytime
  • Answer course questions with at least 70% accuracy and print your own certificates of completion to prove that you have mastered each training course.
  • Free status reports for company managers

Requirements
All you need is a PC with Windows, the Microsoft Internet Explorer (browser) and an Internet connection.
Note: The online computer training is designed to work only with Internet Explorer.  Prices shown are per user.




What You will Learn
This online training course is designed to help you prepare for the MOS Excel 2000 Expert examination. It covers expert level Excel topics such as importing and exporting data, working with templates, linking workbooks, and using the Report Manager. It also covers advanced worksheet formatting, including page setup and printing, and sorting and filtering data. More advanced topics covered include ranges, macros and customization, validating and auditing data, and creating and using charts, graphs, and pivot tables. Data analysis, file sharing, and security issues are also discussed.




Importing and Exporting Data
  • Import data from a text file
  • Import data from an application
  • Import a table from an HTML file
  • Query a database
  • Export data to an application



Working with Templates, Links, and Report Manager
  • Create a template
  • Apply a template to a workbook 
  • Edit a template
  • Use a workspace
  • Link workbooks
  • Preview worksheets
  • Print worksheets
  • Use the Report Manager



Formatting, Sorting, and Filtering Data
  • Apply accounting, currency, and number formats to data
  • Create a custom number format
  • Use and apply conditional formatting
  • Sort data
  • Generate subtotals
  • Group and outline data
  • Use a data form for data entry and retrieval 
  • Create a data filter
  • Extract data



Naming Ranges, Working with Macros, and Customizing Toolbars
  • Add and delete a named range
  • Use a named range in a formula
  • Use lookup functions (HLOOKUP and VLOOKUP) 
  • Record a macro
  • Run a macro
  • Edit a macro
  • Assign a macro to a toolbar button
  • Hide and display toolbars
  • Customize a toolbar



Validating and Auditing Data
  • Validate data
  • Trace cells referenced in a formula (precedents)
  • Use the Auditing toolbar
  • Trace formulas that depend on contents of a cell (dependents)



Analyzing Data and Using PivotTables
  • Use Goal Seek to backsolve from a solution to its values
  • Use Solver
  • Work with scenarios
  • Use PivotTables for data analysis
  • Use the PivotTable AutoFormat feature
  • Create PivotChart reports 
  • Create an interactive PivotTable for the Web
  • Add fields to a PivotTable using the Web browser



Sharing Work and Adding Security
  • Create, edit, and remove a cell comment
  • Change workbook properties
  • Apply and remove worksheet and workbook protection
  • Apply and remove file passwords
  • Track changes
  • Create a shared workbook
  • Merge workbooks







 

          Tutorials for success

Copyright © 2010 TrainingCenter.com