Skip to content
Skip to navigation menu

 

Microsoft Excel 2010: Building Effective Worksheets and Workbooks Workbooks

Following on from the core topics for new users covered in Microsoft Excel 2010: Core Skills, this advanced course offers training for users of Microsoft Excel wanting to develop their skills further to start make use of the more complex built-in functionality offered by this application.  The internal functionality of Microsoft Excel hasn't changed across recent versions of this application so this course would be suitable for existing users of Excel who have already learnt the basics of processing worksheet data regardless of the version of Excel used.

Topics Covered

This course is suitable for anyone needing to create calculations in worksheets and effectively analyse data held on both single worksheets as well as within multiple worksheet workbooks.

By the end of this course you will be able to:

  • build effective calculations using absolute and relative addressing and use named ranges.
  • link calculations across worksheets within a workbook and between workbooks.
  • use advanced built-in functionality to make decisions based on your data using the IF function.
  • lookup data held in a workbook and use this as part of a formula using conditional logic.
  • customise the formatting of cells, creating custom formats and cell styles to standardise formatting throughout a worksheet.
  • work with tabular data to filter and sort lists, create subtotals and grand totals, group data to compact long lists.

In a change to course content for 2013/2014, please note that the creation and formatting of charts to present data visually is now covered on the Microsoft Excel 2010: Core Skills course.

Prerequisites

You must be familiar with the Microsoft Excel interface and have an understanding of how data is stored in a tabular worksheet format. To get the most out of this course you should also have practical experience of creating and formatting spreadsheets and so it is advisable to have either attended the Microsoft Excel 2010 : Core Skills course or already be using Microsoft Excel so that you have the basic prerequisite knowledge required from your current experience of using this application.  To put all that is taught on this course into practice it is desirable that you are using Microsoft Excel 2010.

Course Duration

2 x half-day (3 hours) sessions - length of course 6 hours.

Cost

£95 for members of staff and students of Cardiff University.

£125 for non-profit making organisations, e.g. other universities, charities, and government bodies, including Cardiff and Vale University Health Board.

£150 for commercial organisations (profit-making) wishing to book anyone onto this course.