Pre-Registration Required

July 30, 2009

2:30pm - 8:30pm

Instructors or teachers who want to increase their skills with any of the Microsoft Office software programs are invited to sign up for these special conference trainings.

Workshops and courses will be administered at CTREC Hilton IT Academy. The facility is located by the Westin Oaks hotel, which is walking distance from the Westin Galleria.

Microsoft Certified Application Specialist Excel 2007 Workshop

$250 per person
special conference pricing

• One application exam voucher (no retake—conference pricing)
• One online MCAS Quick Reference Guide
• One TS Certiprep license to take home
• Six-hour workshop with Tips and Tricks (get curriculum at the same time you are getting certified)

Workshop Objectives

Creating and Manipulating Data

• Insert data by using AutoFill
• Ensure data integrity
• Modify cell contents and formats
• Change Worksheet Views
• Manage worksheets
  

Formatting Data and Content

• Format worksheets
• Insert and modify rows and columns
• Format cells and cell content
• Format data as a table
  

Creating and Modifying Formulas

• Reference data in formulas
• Summarize data using a formula.
• Summarize data using subtotals.
• Conditionally summarize data by using a formula
  
• Look up data by using a formula.
  
• Use conditional logic in a formula.
  
• Format or modify text by using formulas.
  
• Display and print formulas.
  

Presenting Data Visually

• Create and format charts
  
• Modify charts
  
• Apply conditional formatting
  
• Insert and modify illustrations
  
• Outline data
  
• Sort and filter data
  

Collaborating and Securing Data

• Manage changes to workbooks
  
• Protect and share workbooks
  
• Prepare workbooks for distribution
  
• Save workbooks
  
• Set print options for printing data, worksheets, and workbooks