|
Provided by: 123-CBT Computer Based Training Excel 2003 Expert Part 2 |
 |
Training
Provided by 123-CBT Computer Based Training
This course, along with the Excel 2003 Expert: Part 1 course, maps to the Microsoft Office Expert certification objectives for the Excel 2003 Expert exams. Learners completing these courses should be well prepared for the certification exams, and have a solid foundation in basic Excel skills.
Learn To
The target audience will range from new users to power users. It is expected that the vast majority of learners will have at least had some exposure to previous versions of Excel. Fundamental PC and Windows skills are assumed.
Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs
Language Options
German, French, US English
Total Learning Time
3 to 4 hours
Objectives
Unit 1: Managing Named Ranges and Functions (1 hour)
Check data in Excel.
Use Evaluate Formula, cell Watch, and Data Validation.
Structure data using XML.
Analyze and project data in Excel. Unit 3: Modifying Excel and Working with Macros (1 hour)
Learn To
- To manage a named range.
- To manage a function in Excel.
- To check data in Excel.
- To use Evaluate Formula, cell Watch, and Data Validation.
- To analyze and project data in Excel.
- To modify default Excel settings.
- To modify toolbars, menus, and workbook properties.
- To create, edit, and run a macro.
The target audience will range from new users to power users. It is expected that the vast majority of learners will have at least had some exposure to previous versions of Excel. Fundamental PC and Windows skills are assumed.
Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs
Language Options
German, French, US English
Total Learning Time
3 to 4 hours
Objectives
Unit 1: Managing Named Ranges and Functions (1 hour)
- Manage a named range.
- Manage a function in Excel.
- Modify default Excel settings.
- Modify toolbars, menus, and workbook properties.
- Create, edit, and run a macro.
|
|
||||||||||
Excel 2003 Expert Part 2
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6.10
- Access 2003
- Acrobat 6.0
- ASP
- ASP.NET
- C
- Captivate 1.0
- Crystal Reports 8.5
- Crystal Reports v10
- Dreamweaver MX
-...
