Spreadsheets (Microsoft Excel 2010)
Update Courses for Windows 7 and Office 2010
Self-service Training Resources
Office 2010 Training Materials
Who can attend these courses?
These courses are being run alongside the University wide upgrade of PCs to Windows 7 / Office 2010 and are available to both Staff and Postgraduate students (a small charge may apply for Postgraduates).
Please Note: These training courses are not available to members of the public or external organisations.
What training options are available?
- Instructor-led, classroom based training
- Self-paced, supervised training with an instructor on hand to provide assistance if needed.
What levels of training are available?
- Level 1 courses are the easiest and are suitable for beginners
- Level 2 courses are more suitable for users who are confident in using Microsoft Windows and Microsoft Office, but want to learn more about the applictions.
- Level 3 courses are more advanced courses, usually focusing on a single topic or subject in greater depth than most courses.
Courses
All courses assume you have already completed the Upgrading to Office 2010 Core Changes training or have some previous experience using Office 2010, some courses also have additional pre-requisites, to enable you to get the most of the course please ensure you read these carefully to help you decide on the most apporiate courses for your needs.
Expand All
Collapse AllTutor Led Training
Excel 2010 : Basic Concepts
Course Level: Level 1
Mode of Delivery: Tutor Led Workshop (also available as a self paced session see below)
Pre-Requisites: This course is an introduction to the basics of creating and managing spread sheets with Excel. The course assumes little or no knowledge of Excel. However, trainees should be confident with using the Windows 7 environment and already have some experience of using Office 2010.
Course Description: After completing this course, you will be able to:
- Understand the Microsoft Excel screen
- Navigate in Excel and use the Ribbon, Backstage View and Options
- Create and manage workbooks
- Select cells, rows, columns and ranges
- Create simple formulas
- Understand the options for copying data in Excel
- Format and align text and numbers in cells
- Change column width and row height
- Hide and unhide columns and rows
- Create, edit and print charts
Target Audience: Staff and Post Graduates who are using Office 2010 and who would like to start learning about Microsoft Excel or refresh their current Excel skills.
Course Dates
| Dates | Courses require a minimum of 2 attendees. | |
| This course is run on demand to arrange a suitable date please email us |
Excel 2010 : Formulae and Functions
Course Level: Level 1
Mode of Delivery: Tutor Led Workshop
Pre-Requisites: Trainees should be confident with using the Windows 7 environment and already have some experience of using Office 2010. They should have a basic understanding of Microsoft Excel including how to navigate in Excel and use the Ribbon, use Backstage View and Options, select cells, rows, columns and ranges, and format and align text and numbers in cells.
Course Description: After completing this course, you will be able to:
- Create and edit formulae
- Use AutoSum
- Understand relative and absolute referencing
- Use the Formulas tab
- Create Range Names and use them in formulae
- Insert functions in Excel
Target Audience: Staff and Post Graduates who are using Office 2010 and who would like to start learning about Microsoft Excel or refresh their current Excel skills.
Course Dates
| Dates | Courses require a minimum of 2 attendees. | |
| Monday 3 June 2.00pm - 4.00pm | Book Now | |
| To be added to the waiting list for future courses please email us |
Excel 2010 : Creating Charts
Course Level: Level 2
Mode of Delivery: Tutor Led Workshop
Pre-Requisites: The course assumes you already have a working knowledge of Excel. Trainees should be confident with using the Windows 7 environment and familiar with using Office 2010.
Course Description: This course will help you to gain an understanding of how charts are created and presented in Excel. Charts are used to summarise data, reflecting proportions, trends, and anomalies in your data Representing your data graphically in a chart helps people to interpret the data. This course is for Excel users who wish to learn the most important features of Charts.
After completing this course, you will be able to:
- Create charts in Microsoft Excel
- Change the chart type
- Change the location of a chart
- Format chart elements
- Add trend lines and error bars to charts
- Save a chart template
Target Audience: Staff and Post Graduates who are using Office 2010 and who would like to learn how to create charts or improve your knowledge of charts in Excel 2010
Course Dates
Dates Courses require a minimum of 2 attendees. Friday 21st June 10.00am - 12.00noon Book Now To be added to the waiting list for future courses please email us
Excel 2010 : Database Techniques
Course Level: Level 2
Mode of Delivery: Tutor Led Workshop
Pre-Requisites: Trainees should have a basic familiarity with Excel 2010 and be able to create and manipulate workbooks. Some knowledge of working with files and folders in the Windows environment is also assumed.
Course Description: After completing this course, you will be able to:
- Understand and apply basic Sort Orders
- Understand and apply basic Filters
- Understand and apply complex filters and sorts
- Work with sub-totals
- Work with Tables in Excel 2010
Target Audience: Staff and Post Graduates who are using Excel 2010 who wish to understand more about Excel’s database techniques.
Course Dates
| Dates | Courses require a minimum of 2 attendees. | |
| Monday 1 July 2.00pm - 4.00pm | Book Now | |
| To be added to the waiting list for future courses please email us |
Excel 2010 : Pivot Tables
This course is now run as a self paced course and full details can be found in the Self Paced section
Excel 2010 : Advanced
This course is now run as a self paced course and full details can be found in the Self Paced section
Self Paced
Excel 2010 : Self Paced
Course Level: Level 1 and Level 2
Mode of Delivery: Self Paced Workshop, you may choose to complete either or both courses each course takes around 2 hours to complete but as they are self paced you may find that you finish the material in a shorter or longer time.
Excel 1
Pre-Requisites: This course is an introduction to the basics of creating and managing spread sheets with Excel. The course assumes little or no knowledge of Excel. However, trainees should be confident with using the Windows 7 environment and already have some experience of using Office 2010.
Course Description: After completing this course, you will be able to:
- Understand the Microsoft Excel screen
- Navigate in Excel and use the Ribbon, Backstage View and Options
- Create and manage workbooks
- Select cells, rows, columns and ranges
- Create simple formulas
- Understand the options for copying data in Excel
- Format and align text and numbers in cells
- Change column width and row height
- Hide and unhide columns and rows
- Create, edit and print charts
Target Audience: Staff and Post Graduates who are using Office 2010 and who would like to start learning about Microsoft Excel or refresh their current Excel skills.
Excel 2
Pre-Requisites: This session will introduce you to some of the more advanced features of Excel. The course assumes you already have a basic working knowledge of Excel and can manage workbooks, select and edit cells, create simple formulas and charts. Trainees should be confident with using the Windows 7 environment and familiar with using Office 2010.
Course Description: After completing this course, you will be able to:
- Insert, copy, rename, delete, hide and unhide worksheets
- Hide, unhide and freeze rows and columns
- Manage options for page setup and printing worksheets
- Sort and filter data
- Protect worksheets and workbooks
- Link worksheets and workbooks
- Apply conditional formatting
- Create logical functions
- Create pivot tables and pivot charts
Target Audience: Staff and Post Graduates who are using Office 2010 and who would like to learn more about the advanced features of Excel 2010.
Course Dates
Either course level can be followed on either date.
| Date | Courses require a minimum of 2 attendees. | |
| Wednesday 7 August 10.00 AM - 12 Noon |
||
| This course is run on demand to arrange a suitable date please email us |
Excel 2010 : Pivot Tables
Course Level: Level 3
Mode of Delivery: After a brief introduction from one of our tutors the rest of the course is a self paced workshop
Pre-Requisites: This course is for experienced Excel users and assumes you already have a good working knowledge of Excel. Trainees should be confident with using the Windows 7 environment and familiar with using Office 2010.
Course Description: Using a pivot table will allow you to change a large quantity of data into more manageable sections. After a brief introduction from one of our tutors, you will work through a set of examples and exercises which allow you to learn and practice the most common features of Pivot Tables.After completing this course, you will be able to:
- create a PivotTable
- filter the data in a PivotTable report
- switch fields around and apply formatting to a PivotTable
- insert a Slicer.
- hide and show grand totals and subtotals in a PivotTable report
- show values in a PivotTable as a percentage of total
- find the difference between specific values in a PivotTable
- group fields in a PivotTable
- create a running total in a PivotTable
- create calculated fields in a PivotTable report
- create custom names for PivotTable fields
- change PivotTable options
- sort values in a PivotTable.
- create and edit a PivotChart
Target Audience: Staff and Post Graduates who are using Excel 2010 who wish to understand more about using Pivot Tables.
Course Dates
| Dates | Courses require a minimum of 2 attendees. | |
| Wednesday 31 July 2.00pm - 5.00pm | Book Now | |
| To be added to the waiting list for future courses please email us |
Excel 2010 : Advanced
Course Level: Level 3
Mode of Delivery: After a brief introduction from one of our tutors the rest of the course is a self paced workshop
Pre-Requisites: This course is for experienced Excel users and assumes you already have a good working knowledge of Excel. Trainees should be confident with using the Windows 7 environment and familiar with using Office 2010.
Course Description: This course will show you how to use conditional formulas and formatting that will automatically decide what information or formatting to put into cells, based on the rules applied to them. You will also learn how to use HLOOKUP and VLOOKUP to return information displayed in other lists within a formula.
- Create an IF function to display text or to calculate values
- Create a nested IF function
- Use the IFERROR function
- Use an AND, OR and NOT statements
- Use the CountIF and SumIF functions
- Create a HLOOKUP function (using a horizontal table)
- Create a VLOOKUP function (using a vertical table)
- Edit LOOKUP functions
- Use Lookups to display exact matches
- Use Lookups to display non-exact matches
- Understand Reference Functions
- Use ROW, COLUMN and ADDRESS
- Use INDIRECT and OFFSET functions
Target Audience: Staff and Post Graduates who are using Excel 2010 who wish to understand more about using some of the more advanced Excel features and functions.
Course Dates
| Dates | Courses require a minimum of 2 attendees. | |
| Tuesday 6 August 9.30am - 12.30pm | Book Now | |
| To be added to the waiting list for future courses please email us |
Additional / Online Excel training
Please check our online training page, where you will find various Excel 2003 and 2010 training materials and links to online Moodle based courses.