Excel 2003 - Level 3 Training Class

Course ID: 5974

Excel 2003 - Level 3 Training Seminar

Overview:

In this course, students will learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Learning Method: Instructor-led Classroom Learning

Certified Microsoft Instructors

Computers & Materials Provided

Class Size: Small class 12-15 students

Duration: 1.00 Day(s)

Times: Will vary depending on location(s)

Who Should Attend:

This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Office Specialist exam in Excel 2003 or Module 2-Key Applications of the Internet and Computing Core Certification (IC3) exam, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

At Course Completion:

You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. Certificate of Completion issued.

This course offers a traditional classroom delivery method - instructor lecture and demonstration, followed by student practice through hands-on exercise - has been enhanced to include Web-based resources during and after class.

Students receive a Learning Guide as a reference tool while in class. But now, a full electronic version of the user manual, eCourseware, is available for a post-class period of six months. Updates to the content within an eCourseware manual are automatic, providing the student with access to the latest version of the material.

As the Classroom Learning experience evolves to include Web-based resources, this course continues to provide valuable learning tools that create the finest and most rewarding environment possible for students.

Agenda

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

Student Testimonials

"Mentored Learning revolutionizes the conventional way of gaining knowledge, information and confidence. Truly, the cost of mentored/self-paced training is worth the investment to the very last centavo!!!"

"It is a brilliant learning experience! I am much more confident about my future in the IT industry now "
Richard Saaiman - Cape Town, South Africa

"I started my training courses for A+ and Network+ in January 2005. By the time I was finished in March, I received my first IT job offer. My resume has never looked better!" Greg Harris - Salinas, CA

"I believe that between the quality of learning and the great instructors, the best opportunity for me to find a job in the IT field. With their help I now have one."
Mark Johnson - Englewood, CO

"Competent instructors, up-to-date material, and an overall astounding quality of the training plus the equipment and facilities first-rate training environment???..

"?????? heartfully as THE training institute for technical IT education"

"The instructor's proficiency in technology and leadership skills offers superior training to any other training provider??????!"

"The overall experience was extremely satisfying in the sense that they took someone with no computer knowledge and helped give me the courage to begin my new career."
David Currier - Grand Rapids, MI

"The instructors are very knowledgeable about everything. Plus, they have real world experience to go with it to back up their teaching."
Mariah DiDomenico - Beaverton, OR

"The trainers are extremely proficient in their knowledge and understanding of the topics, they bring the classroom structure to real-world situations. From the front desk to the classroom, everyone has made me feel great about the entire experience. "
Brett Knight - Nashville, TN

"I found my learning experience to be well beyond my expectations. The instructors I had for various Web courses were both skillful and possessed the knowledge required to present the material to the classes. The classroom equipment and software were state-of-the-art. In addition, the course of instruction was immediately applicable."
Glyn Barrows - San Antonio, TX

This course is Integrated Learning - which guides an organization and an individual learner through all stages of the learning lifecycle. It consists of five components - Assess, Learn, Reinforce, Support and Validate - to create the most effective learning experience available in the industry. Integrated Learning is an effective learning solution because it allows individual learners and training managers to tie learning solutions to business objectives. Simply select the methods of training that work best within the determined budget.

Integrated Learning also has ability to assess the skills of individuals, track progress, increase retention, and manage training across the entire company, thereby offering a better return on the investment of time and money.

Whether you are an individual looking to improve your skills or a corporate training manager, Integrated Learning means working with the premier training provider for a comprehensive learning solution that delivers quantifiable results. This Integrated approach to learning continues to prove that the right training, delivered in the right way, at the right time is the formula for long-term success.