Excel 2003 - Level 1 Training Class

Course ID: 5972

Excel 2003 - Level 1 Training Seminar

Overview:

In this course, you will use Microsoft Office Excel 2003 to manage, edit, and print data.

Learning Method: Instructor-led Classroom Learning

Certified Microsoft Instructors

Duration: 1.00 Day(s)

Times: Will vary depending on location(s)

Who Should Attend:

This course is designed for persons preparing for certification as a Microsoft Office Specialist in Excel, who already have knowledge of the Microsoft Office Windows 98 (or above) operating system, and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2003 worksheets.

At Course Completion:

You will create and edit basic Microsoft Office Excel worksheets and workbooks. Certificate of Completion issued.

Pre-requisite(s):

Windows XP (New Version) - Level 1

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: Getting Started with Excel An Overview of Excel Navigate in Excel Select Data Enter Data Save a Workbook Obtain Help
Lesson 2: Modifying a Worksheet Move and Copy Data Between Cells Fill Cells with Series of Data Edit Cell Data Insert and Delete Cells, Columns, and Rows Find, Replace, and Go To Cell Data Spell Check a Worksheet
Lesson 3: Performing Calculations Create Basic Formulas Calculate with Functions Copy Formulas and Functions Create an Absolute Reference
Lesson 4: Formatting a Worksheet Change Font Size and Type Add Borders and Color to Cells Change Column Width and Row Height Merge Cells Apply Number Formats Create a Custom Number Format Align Cell Contents Find and Replace Formats Apply an AutoFormat Apply Styles
Lesson 5: Developing a Workbook Format Worksheet Tabs Reposition Worksheets in a Workbook Insert and Delete Worksheets Copy and Paste Worksheets Copy a Workbook
Lesson 6: Printing Workbook Contents Set a Print Title Create a Header and a Footer Set Page Margins Change Page Orientation Insert and Remove Page Breaks Print a Range
Lesson 7: Customizing Layout Split a Worksheet Arrange Worksheets Freeze and Unfreeze Rows and Columns Hide and Unhide Worksheets

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. 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