Join the
Assist Training
& Consultancy Ltd
mailing list

---

Email:

24 Barrington Street
Limerick, Ireland.
353 (0) 61 317500
353 (0) 61 316517
info@assisttraining.ie

ECDL Modules
Click here for module details -- BASIC MODULES --- Module 1 - Basic Concepts of IT Module 2 - Using a PC & Managing Files Module 3 - Word processing Module 4 - Spreadsheets Module 5 - Database Module 6 - Presentation Module 7 - Information Network Services -- ADVANCED MODULES --- Advanced Module AM3 - Word Advanced Module AM4 - Excel Advanced Module AM5 - Access Advanced Module AM6 - PowerPoint

Computer Training Courses

Advanced ECDL Module AM4 - Excel

Session 1 - Introduction Introduction to the course Discussion of needs Session 2 - Basics Review Creation of Spreadsheets Shortcuts and proper practice Using formulas Session 3 - Moving & Copying Data Moving & Copying data Absolute References Fill Series Handle Session 4 - Formatting Number Formats & Text Alignments Copying & Pasting Formats Special & Custom Formatting Conditional Formatting Session 5 - Linking & Consolidating Data Linking Cells & Worksheets Goal Seek Scenarios Auditing Tools

Session 6 - Advanced Formulae Nested Functions If Functions Lookup Functions Customising toolbars Creating Templates Session 7 - Charts & Graphics Creating charts Modifiying Charts Formatting Charts Using Graphic Objects Session 8 - Database Features Sorting Data Filtering a list Custom Criteria Session 9 - Pivot Tables Creating Pivot Tables Editing Pivot Tables Session 10 - Macros Running a Macro Recording a Macro Assigning a Macro to a toolbar

Back to Top

Click here to reserve a place on this course