|
Roscommon |
|
Trojan Building Elphin Street Boyle, Co. Roscommon Phone: 071 966 4510 Fax: 071 966 2909 |
|
Advanced Excel (ECDL) This hands-on course is designed for individuals who have already achieved an ECDL certificate. The course will enable students to edit and enhance numeric, text and graphical data and to sort, query and link. Students will be able to carry out advanced formatting and presentation operations on charts and graphs, while also using functions such as those associated with statistical or mathematical operations.
Duration 6 Weeks
Outline Session 1 Review of ECDL Excel to assess student knowledge Name cell range Automatic & conditional formatting Formatting cells and custom numbers Paste special Importing text files Exporting files into Excel Basic mathematical functions Lookup & reference Comments: creating, editing, printing, deleting Session 2 Scenarios Creating a scenario from a defined cell range Creating a scenario Summary Report Date & time functions Mathematic functions Text functions Financial functions Sorting Data & custom Sorting Subtotal Filtering Display Options Freezing row & column titles Hiding rows, columns, and worksheets Linking data and charts between worksheets and spreadsheets and external applications Creating a workbook Session 3 Functions: statistical, database, nested Consolidating data in adjacent worksheets Advanced filtering Introduction to Charts Session 4 Protection & security What-if tables Consolidating data Auditing Session 5 Templates Macros Pivot tables Charts Pre-test evaluation Session 6 Final Exam
Prerequisite Students must have successfully completed ECDL prior to this course
Cost €275
Funding Availability Funding may be available. Please contact us for details.
|