Microsoft Excel 2003 - Level 3

You would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. In this course, you will do all of these things.

Course Outline

You have used Microsoft® Office Excel 2003 to perform tasks such as running calculations on data and sorting and filtering numeric data. You would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. In this course, you will do all of these things.

Course Objective: 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.

Target Student: 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.

Performance-based Objectives Upon successful completion of this course, students will be able to:

• Customize workbooks.
• Collaborate with others using workbooks.
• Audit worksheets.
• Analyze data.
• Work with multiple workbooks.
• Import and export data.
• Structure workbooks with XML.

Course Outline Lesson 1: Streamlining Workflow
Topic 1A: Create a Macro
Topic 1B: Edit a Macro
Topic 1C: Customize Access to Excel Commands
Topic 1D: Apply Conditional Formatting
Topic 1E: Add Data Validation Criteria
Topic 1F: Update a Workbook's Properties
Topic 1G: Modify Excel's Default Settings

Lesson 2: Collaborating with Others
Topic 2A: Protect Files
Topic 2B: Share a Workbook
Topic 2C: Set Revision Tracking
Topic 2D: Review Tracked Revisions
Topic 2E: Merge Workbooks
Topic 2F: Adjust Macro Settings
Topic 2G: Administer Digital Signatures

Lesson 3: Auditing Worksheets
Topic 3A: Trace Cell Precedents
Topic 3B: Trace Cell Dependents
Topic 3C: Locate Errors in Formulas
Topic 3D: Locate Invalid Data and Formulas
Topic 3E: Watch and Evaluate Formulas
Topic 3F: Group and Outline Data

Lesson 4: Analyzing Data
Topic 4A: Create a Trendline
Topic 4B: Create Scenarios
Topic 4C: Perform What-If Analysis
Topic 4D: Develop a PivotTable© Report
Topic 4E: Develop a PivotChart© Report
Topic 4F: Perform Statistical Analysis with the Analysis ToolPak

Lesson 5: Working with Multiple Workbooks
Topic 5A: Create a Workspace
Topic 5B: Consolidate Data
Topic 5C: Link Cells in Different Workbooks
Topic 5D: Edit Links

Lesson 6: Importing and Exporting Data
Topic 6A: Export to Microsoft Word
Topic 6B: Import a Word Table
Topic 6C: Import Text Files

Lesson 7: Structuring XML Workbooks
Topic 7A: Develop XML Maps
Topic 7B: Import, Add, and Export XML Data
Topic 7C: Manage XML Workbooks
Topic 7D: Apply XML View Options

Additional Details

Pre-Requisites

To ensure your success, we recommend you first take the following courses or have equivalent knowledge: - Microsoft Excel 2003 - Level 1 - Microsoft Excel 2003 - Level 2

Certificates offered

Certificate of completion

Cancellation Policy

Students are required to give notice if they are unable to attend their class:

2 weeks (10 full business days) or longer prior to training date = full refund
1 to 2 weeks (5 - 9 full business days) prior to training date = 50% of course fee refund
Less than 1 week (4 full business days or fewer) prior to training date = 0% refund

NOTE: You may substitute classes or students at any time.

Map & Reviews

New Era Technology Training
[ View Provider's Profile ]

Reviews

 

We have not received any reviews specific to this course as yet, however here are some reviews of the training vendor.

   

It was hard to see the instructors screen. It was a projector that was turned toward a white board.

Reviewed by Arlene R. 2012

   

Jason Hall is fantastic and I look forward to taking another course with him. My last experience at New Era was not great; the instructor did not meet our expectations and the computers were not working when we arrived. But Jason made the day fly by and I felt like I learned not only the set curriculum but gained lots of additional presentation skills.

Reviewed by Maya D. 2012

   

The instructor in this class was EXCELLENT. I would highly recommend her as she really knew what she was doing and her etaching style was great. AWESOME instuctor.

Reviewed by Pamela T. 2012

   

The trainer was very knowledgeable and kept the course moving at a great pace. I wish I could take her home with me, so she could help me teach photoshop at the school I work at.

Reviewed by Michelle . 2012

   

The course was very helpful and the instructor was very knowledgable and made the effort to make sure all class members were understanding the excersizes and were on the same page. My only complaint is that the computers seemed a little worn out. Throughout the day most students in the class ran into some sort of issue with the computer not working the way it should. And during our practice time closer to the end of the day all the computers started crashing.

Reviewed by Lori F. 2012

   

The Instructor was fabulous and is the reason that I truly enjoyed the course.

Reviewed by Michelle F. 2011

   

Alex was extrememly helpful and knowlegeable.

Reviewed by Dawn G. 2011

   

The course was excellent, but I felt a little out of my league. The participants in the course were designers and IT people who had used other versions of SharePoint. While I benefited from their questions and comments during the class, I feel "lost" now that I'm back on my own at the office. Perhaps I was in the wrong coarse, but it did say power "user".

Reviewed by Sharon T. 2011

   

Alex is great!

Reviewed by ellen m. 2011

   

Jane is a wonderful teacher! i will gladly take any class she teaches!

Reviewed by Essante P. 2011

   

Jane is an excellent teacher! She is very knowledgable and is enthusiastic about the course!

Reviewed by Essante P. 2011

   

Very good - presented course material in an engaging way.

Reviewed by Claudine T. 2011

   

The instructor didn't provide a lot of structure to the class, he just skimmed through the material and didn't go into it very deep. As a result, the class finished up 1.5 h early as well. He tried to add material from PMI (which was missing from the course materials) but this sometimes just made things more confusing. The PMI material should really be in the course material to start with. Otherwise, the instructor was helpful, knowledgeable and had a good demeanor.

Reviewed by Laverne R. 2011

   

It was informative

Reviewed by Amanda N. 2011

   

Very good course with a very knowledgeable instructor. Class was at full occupancy and I felt that the class size was too large.

Reviewed by Amanda B. 2011

   

There were only 4 students so it went fast and we finished early. Personally I would have liked to spend more time practicing. Perhaps some reference to the book and if there were any practice exercises in there that we could use to gain more experience with Visio.

Reviewed by Denise T. 2011

   

The course started 40 minutes late because they did not have the correct computers set up for the program. It's like they were not even expecting us. I found it very disorganized. For the price I paid for this course, I expected a more professional presentation.

Reviewed by Karyn J. 2011

   

Instructor was very soft spoken did not have all the answres but did get answers later in the class.

Reviewed by Thomas H. 2011