Microsoft Office Excel 2007: Level 3

Enrolment Form

Click to Download

An enquiry form about this course can be found at the bottom of the page.

Course Overview

Skill Level: 3 Advanced

Duration: 1 Day

Description: Your training in and use of Microsoft® Office Excel® 2007 has provided you with a solid foundation in the basic and intermediate skills for working in Excel. You have used Excel to perform tasks such as running calculations on data and sorting and filtering numeric data. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.

Lesson 1: Streamlining Workflow

Topic 1A: Create a Macro
Topic 1B: Edit a Macro
Topic 1C: Apply Conditional Formatting
Topic 1D: Add Data Validation Criteria
Topic 1E: Update a Workbook’s Properties
Topic 1F: Modify Excel’s Default Settings

Lesson 2: Collaborating with Others

Lesson 3: Auditing Worksheets

Lesson 4: Analyzing Data

Lesson 5: Working with Multiple Workbooks

Lesson 6: Importing and Exporting Data

Lesson 7: Using Excel with the Web

Lesson 8: Structuring Workbooks with XML

Additional Info

videoURL:
videoWidth: 250
videoHeight: 220
downloadCourseOverview: coursefiles/microsoft/excel/Excel 2007 Level 3.pdf
downloadEnrollmentForm:
testimonial1:
testimonial2:
testimonial3:

Enquiry Form

Christie's Logo
In2-Training is proud
to support Christie's

Also from
In2 Training Microsoft Excel training • Powerpoint training • Adobe CS4 Training • Microsoft Office 2007 Training • Microsoft Office 2003 Training • Quark Publishing Training • Corel Training • FileMaker Database Training • Grass Valley Training • Edius Training • Adobe Photoshop Training • Adobe Dreamweaver Training • Adobe Flash Training • Adobe Illustrator Training • Adobe InDesign Training