Microsoft Office 2007 Courses

• Learn the changes made from Excel 2003 to Excel 2007, including "ribbons," the removal of toolbars and menus, XML file formatting, and more.
   
• Master the Excel interface and fundamentals, such as mouse controls, keyboard shortcuts, and dialog boxes.

• Select, retrieve, view, and chart data.

• Discover how to use Excel as a database and understand how and why we use spreadsheets.

• Review sorting & filtering, formulas, functions, charts, and graphs.

• Enter labels and values into a workbook.

• Navigate, name, and save a workbook.

• Enter and work with date values and AutoComplete.

• Edit, clear, replace cell contents, and use the Clipboard.

• Cut, Copy, Paste, Paste Special, and move cells.

• Insert and delete cells, rows, and columns, and adjust row height and column width.

• Use Undo, Redo, and Repeat.

• Find and replace information.

• Understand and effectively incorporate Smart Tags.

• Insert cell comments.

• Format fonts and values.

• Use the Format Painter to copy formatting.

• Work with AutoFormat, create a customer number format, find and replace formatting, and use conditional formatting.

• Create, apply, and modify a Style.

• Merge cells, align a cell's contents, add borders and colors, and rotate text.

• Preview and print worksheets and use advanced print options.

• Create charts, format objects in charts, change a chart’s source data and chart type, and work with a 3-D chart and custom charts.

• Work with and understand Absolute and Relative cell references.

• Hands-on exercises with time set aside to practice what you have learned.

Our training features a two-instructor approach to maximize learning and allow for more “hands-on” practice. You also receive a copy of Microsoft Office Excel 2007 QuickSteps – a full-color, user-friendly manual.
  

Course includes lunch, continental breakfast, refreshments, certificate, and all course materials.