Microsoft Excel 2010 Intermediate Course

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.

Course Outcomes

At the completion of this course you should 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

Prerequisites

Microsoft Excel 2010 Level 2 assumes the learner has the skills and knowledge required to
create, edit, print and chart simple worksheets. Understanding ranges and the copying
process is important. It would also be beneficial to have a general understanding of personal
computers and the Windows operating system environment.

Download Course details – Click Here

For more information or to book your place on a course please contact Claire Graham at enquiries@sivatech.co.uk or telephone 01296 717800

Phone: 01296 717800
Fax: 01296 717818
Email: enquiries@sivatech.co.uk