Course ID: 5974 | Course Duration: 1 Day
Course Dates: 
 
Career Training
 

Excel 2003 - Level 3 Training Class

Course ID: 5974
 
 
Course Snapshot View Dates Add To My Courses Get More Information About This Course Register Online Register By Fax On-Site Training View Printer Friendly Version
 
     
 

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.


 

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

 

 

 

 
     
     
  Pre-requisites  
  Suggested Prerequisites: Excel 2003 - Level 1
Excel 2003 - Level 2
Not a requirement to enrollment
 
     
     
 
On-Site Training Bring this Excel 2003 - Level 3 training class in-house at your facility. Request More Information Request More Information On Excel 2003 - Level 3
 
Career Training
 
 
Career Training
  Excel 2003 - Level 3 Training Course Dates and Locations  
     
  Course ID: 5974 | Course Duration: 1 Day  
     
  Locations:  
     
   
     
 
Start Date Price      Location/Event Details Register Online Request
More Info
  Print/Fax
Register
09/02/2008 $249.00    McLean, VA Register Online For The 09/02/2008 Event Request More Information   Register By Fax For The 09/02/2008 Event
09/03/2008 $245.00    San Jose, CA Register Online For The 09/03/2008 Event Request More Information   Register By Fax For The 09/03/2008 Event
09/04/2008 $245.00    Sacramento, CA Register Online For The 09/04/2008 Event Request More Information   Register By Fax For The 09/04/2008 Event
09/05/2008 $235.00    Denver, CO Register Online For The 09/05/2008 Event Request More Information   Register By Fax For The 09/05/2008 Event
09/05/2008 $250.00    Fort Worth, TX Register Online For The 09/05/2008 Event Request More Information   Register By Fax For The 09/05/2008 Event
09/08/2008 $295.00    Boston, MA Register Online For The 09/08/2008 Event Request More Information   Register By Fax For The 09/08/2008 Event
09/08/2008 $225.00    Jacksonville, FL Register Online For The 09/08/2008 Event Request More Information   Register By Fax For The 09/08/2008 Event
09/12/2008 $235.00    Colorado Springs, CO Register Online For The 09/12/2008 Event Request More Information   Register By Fax For The 09/12/2008 Event
09/12/2008 $329.00    Houston, TX Register Online For The 09/12/2008 Event Request More Information   Register By Fax For The 09/12/2008 Event
09/12/2008 $245.00    Hamilton, NJ Register Online For The 09/12/2008 Event Request More Information   Register By Fax For The 09/12/2008 Event
09/16/2008 $250.00    Dallas, TX Register Online For The 09/16/2008 Event Request More Information   Register By Fax For The 09/16/2008 Event
09/17/2008 $295.00    Waltham, MA Register Online For The 09/17/2008 Event Request More Information   Register By Fax For The 09/17/2008 Event
09/18/2008 $235.00    Englewood, CO Register Online For The 09/18/2008 Event Request More Information   Register By Fax For The 09/18/2008 Event
09/18/2008 $235.00    Denver, CO Register Online For The 09/18/2008 Event Request More Information   Register By Fax For The 09/18/2008 Event
09/21/2008 $245.00    Miami, FL Register Online For The 09/21/2008 Event Request More Information   Register By Fax For The 09/21/2008 Event
09/22/2008 $249.00    Washington, DC Register Online For The 09/22/2008 Event Request More Information   Register By Fax For The 09/22/2008 Event
09/22/2008 $245.00    New York City, NY Register Online For The 09/22/2008 Event Request More Information   Register By Fax For The 09/22/2008 Event
09/22/2008 $245.00    New York City, NY Register Online For The 09/22/2008 Event Request More Information   Register By Fax For The 09/22/2008 Event
09/24/2008 $245.00    Wauwatosa, WI Register Online For The 09/24/2008 Event Request More Information   Register By Fax For The 09/24/2008 Event
09/24/2008 $245.00    Plantation, FL Register Online For The 09/24/2008 Event Request More Information   Register By Fax For The 09/24/2008 Event
09/25/2008 $245.00    Hamilton, NJ Register Online For The 09/25/2008 Event Request More Information   Register By Fax For The 09/25/2008 Event
09/26/2008 $245.00    Commack, NY Register Online For The 09/26/2008 Event Request More Information   Register By Fax For The 09/26/2008 Event
09/26/2008 $235.00    Broomfield, CO Register Online For The 09/26/2008 Event Request More Information   Register By Fax For The 09/26/2008 Event
09/26/2008 $250.00    Dallas, TX Register Online For The 09/26/2008 Event Request More Information   Register By Fax For The 09/26/2008 Event
09/29/2008 $295.00    Waltham, MA Register Online For The 09/29/2008 Event Request More Information   Register By Fax For The 09/29/2008 Event
09/29/2008 $249.00    Orlando, FL Register Online For The 09/29/2008 Event Request More Information   Register By Fax For The 09/29/2008 Event
10/02/2008 $235.00    Loveland, CO Register Online For The 10/02/2008 Event Request More Information   Register By Fax For The 10/02/2008 Event
10/02/2008 $250.00    Dallas, TX Register Online For The 10/02/2008 Event Request More Information   Register By Fax For The 10/02/2008 Event
10/03/2008 $250.00    Fort Worth, TX Register Online For The 10/03/2008 Event Request More Information   Register By Fax For The 10/03/2008 Event
10/03/2008 $329.00    Houston, TX Register Online For The 10/03/2008 Event Request More Information   Register By Fax For The 10/03/2008 Event
10/08/2008 $245.00    Madison, WI Register Online For The 10/08/2008 Event Request More Information   Register By Fax For The 10/08/2008 Event
10/10/2008 $295.00    Boston, MA Register Online For The 10/10/2008 Event Request More Information   Register By Fax For The 10/10/2008 Event
10/13/2008 $245.00    New York City, NY Register Online For The 10/13/2008 Event Request More Information   Register By Fax For The 10/13/2008 Event
10/15/2008 $250.00    Dallas, TX Register Online For The 10/15/2008 Event Request More Information   Register By Fax For The 10/15/2008 Event
10/17/2008 $245.00    Sacramento, CA Register Online For The 10/17/2008 Event Request More Information   Register By Fax For The 10/17/2008 Event
10/20/2008 $329.00    Houston, TX Register Online For The 10/20/2008 Event Request More Information   Register By Fax For The 10/20/2008 Event
10/23/2008 $295.00    Waltham, MA Register Online For The 10/23/2008 Event Request More Information   Register By Fax For The 10/23/2008 Event
10/24/2008 $245.00    New York City, NY Register Online For The 10/24/2008 Event Request More Information   Register By Fax For The 10/24/2008 Event
10/24/2008 $245.00    San Jose, CA Register Online For The 10/24/2008 Event Request More Information   Register By Fax For The 10/24/2008 Event
10/29/2008 $249.00    Orlando, FL Register Online For The 10/29/2008 Event Request More Information   Register By Fax For The 10/29/2008 Event
10/31/2008 $245.00    Neenah, WI Register Online For The 10/31/2008 Event Request More Information   Register By Fax For The 10/31/2008 Event
10/31/2008 $245.00    Wauwatosa, WI Register Online For The 10/31/2008 Event Request More Information   Register By Fax For The 10/31/2008 Event
11/03/2008 $295.00    Waltham, MA Register Online For The 11/03/2008 Event Request More Information   Register By Fax For The 11/03/2008 Event
11/07/2008 $245.00    Neenah, WI Register Online For The 11/07/2008 Event Request More Information   Register By Fax For The 11/07/2008 Event
11/14/2008 $295.00    Boston, MA Register Online For The 11/14/2008 Event Request More Information   Register By Fax For The 11/14/2008 Event
11/19/2008 $245.00    Sacramento, CA Register Online For The 11/19/2008 Event Request More Information   Register By Fax For The 11/19/2008 Event
11/20/2008 $245.00    Tampa, FL Register Online For The 11/20/2008 Event Request More Information