Microsoft Excel 2010 Advanced Course

This course aims to provide skills and knowledge which will allow the attendee to create
lookup functions, set Excel working options, enhance charts, protect worksheet data, perform
advanced data operations using summarising, PivotTables, data consolidations, goal
seeking, and Solver, and create and use macros..

Course Outcomes

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

  • modify Excel options
  • protect data in worksheets and workbooks
  • import data into Excel and export data from Excel
  • use data linking to create more efficient workbooks
  • group cells and use outlines to manipulate the worksheet
  • create summaries in your spreadsheets using subtotals
  • use the Data Consolidation feature to combine data from several workbooks into one
  • create, use and modify data tables
  • create and work with scenarios and the Scenario Manager
  • create and edit a PivotChart
  • construct and operate PivotTables using some of the more advanced techniques
  • use advanced filters to analyse data in a list
  • use a variety of data validation techniques
  • use a range of Information functions
  • use a range of text functions
  • create and use a range of controls in a worksheet
  • share workbooks with other users
  • create recorded macros in Excel

Prerequsites

Microsoft Excel 2010 ‐ Level 3 assumes some knowledge of the software as well as a general
understanding of personal computers and the Windows operating system environment.

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