Home Company Information Consulting Course Catalog Contact Us Request a Quote Government Corporate
 


Profile

Login

Catalog


Search

Contact

Cart

Microsoft Excel 2000 (Beg, Int, and Adv.)
MSACCESS
English
   
Audience Details:  
16
Familiarity with any of the Windows user environments
Anyone wishing to become familiar with Microsoft Excel 2000 at more than a basic level; students wishing to become MOUS certified at Expert or Master level
To provide an introduction to the core concepts of Microsoft Excel 2000. To equip students with the knowledge and skills required to accomplish common Excel 2000 tasks efficiently, to prepare students for certification as Proficient Users of Excel 2000 and to bring proficient users of Excel 2000 to an advanced level of competence
After learning this courses you should be able to:
  Create a new spreadsheet.
Enter and edit data in a worksheet.
Edit and format cells, rows, and columns.
Format numbers and apply styles.
Create, save, preview, and print a workbook.
Create and use formulas.
Use basic and advanced functions.
Create and modify worksheets.
Check a workbook for spelling errors.
Modify page and print settings.
Create, format, and modify charts and objects.
Print a chart.
Create and apply a template.
Share, merge, and print workbooks.
Add protection to a workbook.
Collaborate with workgroups.
Audit a worksheet.
Format numbers and ranges.
Use the Lookup function.
Hands on pratice - Simulations
   
Course Structure: Unit Titles and Topics Covered
  Getting started
Starting Excel
Entering and changing data
Hands-on: Manipulating data
Hands-on: Deleting and clearing cells
Copying and moving data
Hands-on: Moving data
Formatting
Cells, rows, and columns
Hands-on: Modifying cells
Working with styles and text
Hands-on: Applying font styles
Formatting numbers
Hands-on: Applying number formats
Workbooks
Creating and saving workbooks
Hands-on: Opening and saving a workbook
Previewing and printing workbooks
Hyperlinks and e-mail
Formulas
Creating formulas
Hands-on: Entering a formula
Hands-on: Revising a formula
Automatic features
Manipulating worksheets
Using worksheets
Hands-on: Working with worksheets
Rows and columns
Hands-on: Working with rows and columns
Preparing for publishing
Hands-on: Checking spelling and publishing
Page setting and printing
Page settings
Hands-on: Manipulating page setup
Print settings
Hands-on: Printing a selection
Functions
Entering functions
Hands-on: Using basic functions
Finance and time functions
Hands-on: Using advanced functions
3-D references
Charts and objects
Charts
Hands-on: Modifying and printing a
chart
Objects
Hands-on: Working with objects
Advanced editing
Using templates
Hands-on: Using templates to create workbooks
Using comments
Hands-on: Creating and editing a comment
Sharing and merging workbooks
Printing workbooks
Toolbars
Hands-on: Working with toolbars
Security and auditing
Protecting worksheets
Hands-on: Applying and removing protection
Protecting workbooks
Workgroup collaboration
Hands-on: Applying protection to workbooks
Hands-on: Tracking changes
Auditing a worksheet
Hands-on: Tracing precedents and dependents
Numbers and ranges
umber formats

Hands-on: Formatting numbers
amed ranges
Hands-on: Working with named ranges
Lookup functions
Hands-on: Using Lookup functions
Macros and multiple workbooks
Recording and running macros
Hands-on: Recording a macro
Hands-on: Running a macro
Multiple workbooks
Hands-on: Using multiple workbooks
Sharing data
Importing data from text files
Hands-on: Importing from text files
Importing data from applications
Hands-on: Importing from other applications
Importing an HTML file
Hands-on: Importing from HTML
Exporting data
Displaying and formatting data
Conditional formats
Hands-on: Using grouping and outlines
Sorting data
Hands-on: Performing a sort

Forms and subtotaling
Data filters and validation
Hands-on: Applying data filters
Querying databases
Analyzing data
PivotTables
Hands-on: Formatting PivotTables
PivotTables and the Web
Hands-on: Creating PivotTables for the Web
PivotChart reports
Goal Seek and Solver
Hands-on: Using Solver
Scenarios
Curriculum Info:  
Microsoft Curriculum
  Personal Use License Price $159.00
  Contact your Eno Learning Consultant or call 888-742-3214 to order. For organizational purchases, please contact the sales office nearest you.

Available Online, Interactive CDs, Network