Excel 2: Managing Data
Microsoft TeamsContinuing from Excel 1: Essentials, this course looks at how to arrange and display both numeric and non-numeric data in Excel to present it in a meaningful manner. Through a […]
Loading view.
Data
Excel: Creating Charts
Microsoft TeamsThis specialised course looks at the improved charting feature in Excel 2007 and discusses some of the different types of charts that can be created, in particular, line, scatter, pie, […]
Excel: Introduction to PivotTables
Microsoft TeamsThis is a half day course that includes a presentation and a variety of practical exercises. This is an advanced course aimed at staff who are experienced at using Microsoft […]
Excel: Get and Transform
Microsoft Teams“Power Query and Power Pivot aka Get and Transform are the best thing to happen to Excel in 20 years”. Bill Jelen, Excel MVP How long would it take you […]
Excel 3: Data Analysis
Microsoft TeamsThis advanced course looks at some of the data analysis tools and functions available in Excel 2010 and involves a range of practical exercises using different types of data. Participants […]
Introduction to Database Part 1 (covers ICDL DB)
This is part 1 of a 2 part course to help staff prepare for ECDL Module 5. The course covers: what a database is in terms of tables, records and […]
Introduction to Database Part 2 (covers ICDL DB)
This is part 2 of a 2 part course to help staff prepare for ECDL Module 5. The course covers: what a database is in terms of tables, records and […]