|
|
|
Course ID: 5973
| Course Duration: 1 Day
|
|
Course Dates:
|
| |
|
| |
Excel 2003 - Level 2 Training Class
Course ID: 5973
|
|
| |
|
|
| |
|
|
| |
Excel 2003 - Level 2 Training Seminar
Overview:
In this course, you will use Microsoft Office Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.
Learning Method: Instructor-led Classroom Learning
Certified Microsoft Instructors
Duration: 1.00 Day(s)
Times: Will vary depending on location(s)
Who Should Attend:
The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web. In addition, this course helps prepare students who desire to prepare for the Microsoft Office Specialist exam in Excel or Module 2 and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.
At Course Completion:
You will apply visual elements and advanced formulas to a worksheet to display data in various formats. 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 |
|
| |
Outline:
Lesson 1: Creating and Applying Templates
Create a Workbook from a Template
Create a Custom Template
Working with Comments
Create a Hyperlink
Use Web-based Research Tools
Lesson 2: Creating and Modifying Charts
Create a Chart
Format Chart Items
Change the Chart Type
Create a Diagram
Lesson 3: Working with Graphic Objects
Insert Graphics
Create AutoShapes
Format Graphic Objects
Change the Order of Graphic Objects
Group Graphic Objects
Move, Copy, and Resize Graphic Objects
Lesson 4: Calculating with Advanced Formulas
Create and Apply a Name for a Range of Cells
Calculate Across Worksheets
Calculate with Date and Time Functions
Calculate with Financial Functions
Calculate with Statistical Functions
Calculate with Lookup and Reference Functions
Calculate with Logical Functions
Lesson 5: Sorting and Filtering Data
Sort Data Lists
Filter Data Lists
Create and Apply Advanced Filters
Calculate with Database Functions
Add Subtotals to a Worksheet
Lesson 6: Using Excel with the Web
Export Excel Data
Publish a Worksheet to the Web
Import Data from the Web
Create a Web Query
|
|
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
|
|
| |
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
Suggested:
Excel 2003 - Level 1 Training Class (Beginners Course)
Course ID: 5972
http://www.trainup.com/Information-Technology-Training/Microsoft-Office/Microsoft-PowerPoint/Microsoft-Excel/Excel-2003---Level-1-5972.htm
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
|
| |
Excel 2003 - Level 2 Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 5973
| Course Duration: 1 Day
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request
More Info |
|
Print/Fax
Register |
| | | | |
|