Microsoft Excel 2013 Intermediate Course

 

The skills and knowledge acquired in Microsoft Excel 2013 ‐ Level 2 enable users to expand
their knowledge and learn how to create more productive workbooks. It covers formulas and
function techniques, advanced formatting and charting features and data manipulation tools
like PivotTables and goal seeking.

Course Outcomes

At the completion of this course you should be able to:

  •  use filling techniques use a range of techniques to work with worksheets
  • apply a variety of page setup techniques
  • apply borders to cells and ranges in a worksheet
  • use popular and common worksheet functions
  • create more complex formulas and functions
  • use a variety of financial functions
  • use the date and time functions to perform calculations
  • create and use defined names in a workbook
  • apply a range of number formatting techniques to worksheet cells
  • apply conditional formatting to ranges in a worksheet
  • use goal seeking to determine the values required to reach a desired result
  • understand and use Excel’s Quick Analysis tools
  • work with tables in Microsoft Excel
  • understand and create simple PivotTables
  • use a range of elements and features to enhance charts
  • select and change the format of objects in a chart

Prerequsites

Microsoft Excel 2013 ‐ Level 2 assumes the learner has the knowledge required to create, edit,
print and chart simple worksheets. Understanding ranges and copying is also important.

Download Course Brochure – 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