Course Catalog > Microsoft Office 2003 > Advanced Microsoft Excel 2003
Advanced Microsoft Excel 2003
Advanced Microsoft Excel 2003 (1 Day)
Our Microsoft Excel 2003 training will show you features you need to be a an effecient Excel user. Microsoft Excel is the standard spreadsheet application for both the business world and personal use. Whether you are new to Excel or an advanced user, Current Technologies courses for Excel will cover what you need to know to become an Excel power user.
This Advanced Microsoft Excel 2003 course covers the skills needed to create Macros, protect and share documents using Excel 2003, import and export data with other applications, format Excel spreadsheets for HTML, and structure workbook using XML.
Come Experience the Current Technologies Computer Learning Center Way of Training. We take great care of all of our students.
The CTCLC Difference
Current Technologies Computer Learning Center uses our own certified instructors that will help guide you to a sucessful completion of your Microsoft Office training and certification. Our Instructors are simply the best instructors you will find. Let our great instructors help you get started in understanding and using your Microsoft Office applications. CTCLC has convenient day or night schedules to fit your needs. We can also do onsite classes with our top notch portable labs.
Our instructors are the very best and give 110% to their Students. We care about every student that we train and we have a Free Resit Policy for all of our courses for the same revision. You will not find a better training experience anywhere.
Current Technologies Computer Learning Center is Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Partner, CompTIA Learning Alliance Member, EC-Council Accredited Training Center, and many others. We offer the highest quality, authorized training that you will find anywhere.
Intended Audience
People who desire to gain the skills necessary to:
- Increase productivity and improve efficiency by streamlining your workflow
- Collaborate with others using workbooks
- Audit worksheets
- Analyze data
- Work with multiple workbooks
- Import and export data
- Use Excel with the web
- Structure workbooks with XML
- Increase productivity and improve efficiency by streamlining your workflow
- Employees who need to use excel in their job
- This course is designed for people preparing for certification as a Microsoft Office Specialist (MOS).
Duration
- 1 Day ( 8:30am to 4:30pm)
CTCLC Special Discounts
Advanced Microsoft Excel 2003 $249.00 List Price $299.00 Special Discounted Student price for 3 or more from the same Company $199.00
For More Information About Advanced Microsoft Excel 2003 or to Register for Courses
EMail: Sales@ctclc.com
Phone: (219) 764-3800
Course Outline
Advanced Microsoft Excel 2003
Lesson 1: Streamlining Workflow
- Create a Macro
- Edit a Macro
- Customize Access to Excel Commands
- Apply Conditional Formatting
- Add Data Validation Criteria
- Update a Workbook's Properties
- Modify Excel's Default Settings
Lesson 2: Collaborating with Others
- Protect Files
- Share a Workbook
- Set Revision Tracking
- Review Tracked Revisions
- Merge Workbooks
- Adjust Macro Settings
- Administer Digital Signatures
Lesson 3: Auditing Worksheets
- Trace Cell Precedents
- Trace Cell Dependents
Locate Errors in Formulas- Locate Invalid Data and Formulas
- Watch and Evaluate Formulas
- Group and Outline Data
Lesson 4: Analyzing Data
- Create a Trendline
- Create Scenarios
- Perform What-If Analysis
- Develop a PivotTable© Report
- Develop a PivotChart© Report
- Perform Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
- Create a Workspace
- Consolidate Data
- Link Cells in Different Workbooks
- Edit Links
Lesson 6: Importing and Exporting Data
- Export to Microsoft Word
- Import a Word Table
- Import Text Files
Lesson 7: Structuring XML Workbooks
- Develop XML Maps, Import, Add, and Export XML Data
- Manage XML Workbooks, Apply XML View Options
Lesson 8: Using XML in Word
- Tag an Existing Document
- Save a Document as XML
- Transform an XML Document
Certification Path
Required Exam(s) |
Recommended Training |
|
|---|---|---|
| Microsoft Office Specialist (MOS) - Excel | ||
For More Information About Advanced Microsoft Excel 2003 or to Register for Courses
EMail: Sales@ctclc.com
Phone: (219) 764-3800