Consulting

  • Public Speaking
  • Human Resources
  • Public Relations

Training

  • Computer Applications
  • Business Training 
  • Continuing Education 
  • HR Certification

Development

  • Database Sytems
  • Website CMS
  • Web Based Testing

Excel 2007 Essentials

Need to learn to use 2007 Excel to create powerful computerized spreadsheets? MTI's hands-on computer class is exactly what you need! 

If you're responsible for creating spreadsheets and tracking information for your organization, learning how to effectively use Microsoft Excel 2007 can increase your effectiveness, help you save time, and allow you to effectively track critical business information. MTI's Microsoft Excel 2007 Essentials course is designed to provide attendees with the skills they need to create and use Excel spreadsheets.

Learning Objectives

This course is designed to provide participants with the skills they need to effectively utilize Microsoft Excel. This two-day hands-on seminar is taught in a computer lab. Participants will receive practical, hands-on training on an individual PC.  

Topics Covered Include:

  • Creating, Saving, Opening Workbooks
  • Adding and Naming Worksheets
  • Editing Data in Cells
  • Selecting Cells
  • Formatting a Worksheet
  • Merging Cells
  • Cell Alignment
  • Changing Row Height and Column Width
  • Page Breaks
  • Formulas (Addition, Subtraction, Multiplication, Division)
  • Order of Operations
  • AutoSum
  • Relative / Absolute References
  • Filling Formulas
  • Functions (Average, Min, Max, Sum, Count)
  • Selecting nonadjacent cells
  • Inserting/Deleting Cells, Rows, Columns
  • Borders and Shading
  • AutoFormat/Format Painter
  • Hide/Unhide columns, rows
  • Paste Special… Options
  • Hyperlinks

_________________________________________________________________________________________________________________

Want to bring this seminar to your company or association? Contact MTI for information about on-site training options, available at any U.S. location. _________________________________________________________________________________________________________________

Click here for MTI's current open enrollment training schedule. ________________________________________________________________________________________________________________

Training Level: 
Essentials
Total Meeting Days: 
Two Days
Total Training Hours: 
8hrs.
Approved Continuing Education Credit: 
AL CPAs
AL Engineers and Land Surveyors
AL HVAC Contractors
AL Nursing Provider ABNP 1276 exp 3-12
AL Nursing Home Administrators
AL Occupational Therapy

Computer Lab Rentals

  • Computer Labs
  • Lecture or Meeting Rooms
  • High Speed Internet 
  • Daily, Weekly, Monthly

Authorized Testing Center

  • Prometric
  • LaserGrade
  • Host/Kryterion
  • Castle