MS Excel 2010 Intermediate Training Course

This second class in a series, begins to really show the power of Excel 2010.

Topics like linking workbooks, advanced formatting, outlining, chart formatting options and Pivot Tables are covered in depth.

This dynamic training course is available now throughout the US, including Atlanta, Baltimore, Boston, Charlotte, Chicago, Dallas, Los Angeles, Manhattan, Miami, Orlando, Philadelphia, and Seattle.

Learning Outcomes - MS Excel 2010 Intermediate Training Course

By the end of this training course, participants will:

• Switch between workbooks
• Create 3-D formulas linking worksheets & workbooks
• Add a Watch window
• Create a workspace
• Use functions to format text
• Transpose data
• Add backgrounds & watermarks
• Name cells & ranges
• Sort & filter data
• Create, format and modify tables
• Use structured references in table formulas
• Calculate SUM, AVERAGE and COUNT values in filtered tables
• Insert, edit and delete hyperlinks
• Send worksheets via e-mail
• Create combination charts & trendlines
• Insert sparklines
• Use audit features
• Protect a worksheet
• Customize the Ribbon
• Download templates
• Create PivotCharts

Times

Public classes start at 9:00am and finish around 4:30pm.

Class Size

Public classes will be a small relaxed group of between 4 and 12 people.

The small group helps ensure that everyone will gets a chance to ask questions and learn at their own pace.

What is provided?

All participants will be provided with morning tea, afternoon tea, printed bound courseware to keep and a MS Excel 2010 Intermediate Training Course Certificate of Completion.

Certificates of Completion are issued to each participant