EXCEL 2010 Level 2 (Powerful spreadsheet techniques and data manipulation)

General Description

Microsoft Excel 2010 Level 2 is the second of a 3 Level study program for Microsoft Excel 2010. This level extends the learner's basic knowledge of Excel and provides the learner with skills and knowledge to produce more effective and productive workbooks. It covers formulas and function techniques, more intricate formatting, setting complex printing options, using intricate charting features, and working more effectively with existing worksheets and workbooks.


At the completion of this course participants will be able to:

  • use the fill operations available to fill a data series, and move the contents of cells and ranges within and between workbooks
  • work with logical functions in Excel
  • use a range of formula techniques
  • apply a range of number formatting techniques to data
  • apply conditional formatting to ranges in a worksheet
  • apply borders to cells and ranges
  • apply a variety of page setup techniques and work with various elements of a worksheet
  • use a range of find and replace techniques
  • sort and filter data in a list in a worksheet
  • use a range of techniques to enhance charts.

On-Site Training

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.

User Reviews

Good Stuff (Rating based on 182 reviews)

of respondents recommend this course to a friend.

Click here to Read Reviews

Course Info

Next Step

Enquire Now
Tell a Friend
Email Course Outline

Course files