|We are here to help...|
|With easy ways to get the answers you need:|
|Or call us at:|
||Microsoft Excel 2000 (Beg, Int, and Adv.)
||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
||Unit Titles and Topics Covered
Entering and changing data
Hands-on: Manipulating data
Hands-on: Deleting and clearing cells
Copying and moving data
Hands-on: Moving data
Cells, rows, and columns
Hands-on: Modifying cells
Working with styles and text
Hands-on: Applying font styles
Hands-on: Applying number formats
Creating and saving workbooks
Hands-on: Opening and saving a workbook
Previewing and printing workbooks
Hyperlinks and e-mail
Hands-on: Entering a formula
Hands-on: Revising a formula
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
Hands-on: Manipulating page setup
Hands-on: Printing a selection
Hands-on: Using basic functions
Finance and time functions
Hands-on: Using advanced functions
Charts and objects
Hands-on: Modifying and printing a chart
Hands-on: Working with objects
Hands-on: Using templates to create workbooks
Hands-on: Creating and editing a comment
Sharing and merging workbooks
Hands-on: Working with toolbars
Security and auditing
Hands-on: Applying and removing protection
Hands-on: Applying protection to workbooks
Hands-on: Tracking changes
Auditing a worksheet
Hands-on: Tracing precedents and dependents
Numbers and ranges
Hands-on: Formatting numbers
Hands-on: Working with named ranges
Hands-on: Using Lookup functions
Macros and multiple workbooks
Recording and running macros
Hands-on: Recording a macro
Hands-on: Running a macro
Hands-on: Using multiple workbooks
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
Displaying and formatting data
Hands-on: Using grouping and outlines
Hands-on: Performing a sort
Forms and subtotaling
Data filters and validation
Hands-on: Applying data filters
Hands-on: Formatting PivotTables
PivotTables and the Web
Hands-on: Creating PivotTables for the Web
Goal Seek and Solver
Hands-on: Using Solver
||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