| Duration |
1-day session - 9.00am 4.30pm and online |
| Comment |
This course will be run throughout 2013 both classrooom based and online |
| Course Fee |
Advised on application |
| Subjects Taught |
Lesson 1:
Calculating Data with Advanced Formulas
Apply Cell and Range Names
Calculate Data Across Worksheets
Use Specialised Functions
Analyse Data with Logical and Lookup Functions
Lesson 2:
Organising Worksheet and Table Data
Create and Modify Tables
Format Tables
Sort or Filter Worksheet or Table Data
Use Functions to Calculate Data in a Table or Worksheet
Lesson 3:
Presenting Data Using Charts
Create a Chart
Modify Charts
Format Charts
Lesson 4:
Analysing Data Using PivotTables, Slicers, and PivotCharts
Create a PivotTable Report
Filter Data Using Slicers
Analyse Data Using PivotCharts
Lesson 5:
Inserting Graphic Objects
Insert and Modify Pictures and ClipArt
Draw and Modify Shapes
Illustrate Workflow Using SmartArt Graphics
Layer and Group Graphic Objects
Lesson 6:
Customising and Enhancing Workbooks and the Excel Environment
Customise the Excel Environment
Customise Workbooks
Manage Themes
Create and Use Templates |
| Enrolment and Start Dates Comment |
The course will be run on 29th, 30th April and 20th, 21st and 22nd May 2013 - enrolment any time before that date.
Places are limited and allocated on first-come first served basis. |
| Financial Support |
Free places are available for those who are unemployed (Please enquire about eligibility criteria). |
| Careers or Further Progression |
Upon successful completion of this course, students will be able to:
- use advanced formulas.
- organise worksheet and table data using various techniques.
- create and modify charts.
- analyse data using PivotTables, Slicers, and PivotCharts.
- insert and modify graphic objects in a worksheet.
- customise and enhance workbooks and the Microsoft® Office Excel® environment. |
| Entry Requirements |
The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyse data, and work with Excel on the web. In addition, this course helps prepare students who desire to take the Microsoft Office Specialist exam in Excel and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets. |
| Further Enquiries |
ICOS Skillnet
Tel: 01 613 1348
E-mail: icosskillnet@icos.ie |
| Download Application Form |
http://www.icos.ie/skillnet/book-a-course/ |
| Trainer |
Professional Training Solutions Ltd. |
| Location of Course |
Cork City |