>

Excel 2007-2010 Intermediate Training

Excel 2007-2010 Intermediate Training

Intermediate Users

Perfect for excel_logo-300x300users that have become reasonably proficient with the basic functions of excel, this Excel 2007-2010 intermediate provides you with further knowledge of the application and enables you to use advanced formulas, manage database lists, create advanced charts and graphics and analyse data using Pivot Tables.

What will I learn

This Excel 2007/2010 intermediate course will teach the participants to:

  • Use multiple excel workbooks
  • Use advanced formatting
  • Outline and subtotal
  • Create and use names
  • Use filters and lists
  • Work with tables
  • Work with the web
  • Use advanced charting
  • Use group features such as auditing
  • Create and manage excel document templates 

Course Outline

Microsoft Excel course content:

Using multiple excel worksheets and workbooks

  • Using multiple excel workbooks
  • Linking worksheets with 3-D formulas
  • Linking excel workbooks
  • Managing excel workbooks

Advanced formatting

  • Using special number formats
  • Using functions to format text
  • Working with styles
  • Working with themes
  • Other advanced formatting

Outlining and subtotals

  • Outlining and consolidating data
  • Creating subtotals

Cell and range names

  • Creating and using names
  • Managing names

Lists and tables

  • Examining lists
  • Sorting and filtering lists
  • Advanced filtering
  • Working with tables

Web and Internet features

  • Saving workbooks as Web pages
  • Using hyperlinks
  • Distributing workbooks

Advanced charting

  • Chart formatting options
  • Combination charts
  • Graphic elements

Documenting and auditing

  • Auditing features
  • Comments in excel cells and workbooks
  • Protection
  • Workgroup collaboration

Templates and settings

  • Application settings
  • Built-in templates
  • Creating and managing excel templates

Delivery Formats:

All our in house training course are available tailored to yours and your companies/delegates needs with our CTP (customised training programme) solution. Designed to meet any challenge or level required. Ask for a full proposal for your training, tailored to suit you.

In house training at your premises – £949 for a group of up to 12 per day  (ex travel charged at 45 pence per mile)

Please contact us if you are interested in attending a public course

 

Send this to a friend