Module 1 Introduction to ICDL Advanced
Unit 1 Intro to ECDL Advanced
Module 2 Advanced Word Processing
Unit 1 Intro to ICDL Advanced Word Processing
Unit 2 1.1.1 - Text Wrapping
Unit 3 1.1.2 - Find & Replace - Page Formatting
Unit 4 1.1.2 - Find & Replace Font Formatting
Unit 5 1.1.2 - Find & Replace Words & Phrases
Unit 6 1.1.3 - Using the Paste Special Options
Unit 7 1.2.1 - Line Spacing
Unit 8 1.2.2 - Paragraph Pagination
Unit 9 1.2.3 - Modify A Multilevel List
Unit 10 1.3.1 - Update a Character Style
Unit 11 1.3.2 - Modify a Paragraph Style
Unit 12 1.3.2 - Update Paragraph Style
Unit 13 1.4.1 - Apply & Change Column Layout
Unit 14 1.4.2 - Change Column Widths & Spacing
Unit 15 1.4.3 - Insert & Delete a Column Break
Unit 16 1.5.1 - Apply a Table Autoformat or Table Style
Unit 17 1.5.1 Pt2 - Split a Table Horizontally & Vertically
Unit 18 1.5.2 Pt1 - Merge & Split Cells in a Table
Unit 19 1.5.3 - Change Cell Margins Alignment & Text Direction
Unit 20 1.5.4 - Automatically Repeat Heading Row
Unit 21 1.5.5 - Allow or Do not Allow Rows to Break Across Pages
Unit 22 1.5.6 - Sort Data by One or more Columns
Unit 23 1.5.7 - Convert Delimited Text to a Table
Unit 24 1.5.8 - Convert Table to Text
Unit 25 2.1.1 & 2.1.2 & 2.1.3 - Add Edit or Delete a Caption Above or Below a Grapical Object
Unit 26 2.1.4 - Insert & Modify Footnotes
Unit 27 2.1.5 - Convert Footnotes to Endnotes and Endnotes to Footnotes
Unit 28 2.2.1 & 2.2.2 - Insert, Edit a Citation, Set & Edit a Style
Unit 29 2.2.3 - Create & Update a Bibliography
Unit 30 2.3.1 - Create & Update a Table of Contents
Unit 31 2.3.2 & 2.3.3 - Edit a Table of Contents - Styles Format & Leaders
Unit 32 2.3.4 - Mark an Index & Create an Index
Unit 33 2.3.5 -Create & Update an Index
Unit 34 2.4.1 & 2.4.2 & 2.4.3 - Insert and Delete Bookmarks and Cross-references
Unit 35 3.1.1 - Insert & Delete FieldsFilename Path Total Number of Pages
Unit 36 3.1.2 - Insert a Formula Field in a Table
Unit 37 3.1.3 - Change Field Number and Date Format
Unit 38 3.1.4 - Lock & Unlock Update Field
Unit 39 3.2.1 & 3.2.2 - Create & Modify Form with Text Checkbox and Dropdown Menu - Protect a Form
Unit 40 3.2.3 - Save a Document as a Template
Unit 41 3.2.4 - Modify The Default Template
Unit 42 3.3.1 - Edit Sort Filter Mail Merge Recipient List
Unit 43 3.3.2 - Insert Ask...Then...Else... Fields
Unit 44 3.3.3 - Merge a Document with Recipient List
Unit 45 3.4.1 - Insert & Edit & Remove a Hyperlink
Unit 46 3.4.2 - Link Data from a Document as an Object or Icon
Unit 47 3.4.3 - Update or Break a Link
Unit 48 3.4.4 - Embed Data into a Document as an Object
Unit 49 3.4.5 - Edit or Delete Embedded Data
Module 3 Advanced Word Processing - Additional Training / Extra Resources
Unit 1 Formatting - Text - Apply text wrapping options for graphical objects (picture, image, chart, diagram, drawn object), tables.
Unit 2 Formatting - Text - Use find and replace options like: font formats, paragraph formats, paragraph marks, page breaks.
Unit 3 Formatting - Text - Use paste special options: formatted text, unformatted text.
Unit 4 Formatting - Paragraphs - Apply line spacing within paragraphs: at least, exactly/ fixed, multiple/proportional.
Unit 5 Formatting - Paragraphs - Apply, remove paragraph pagination options.
Unit 6 Formatting - Paragraphs - Apply, modify outline numbering in multi-level lists.
Unit 7 Formatting - Styles - Create, modify, update a character style.
Unit 8 Formatting - Styles - Create, modify, update a paragraph style.
Unit 9 Formatting - Columns - Apply multiple column layouts. Change number of columns in a column layout.
Unit 10 Formatting - Columns - Change column widths and spacing. Insert, remove lines between columns.
Unit 11 Formatting - Columns - Insert, delete a column break.
Module 4 Advanced Spreadsheets
Unit 1 Intro to ICDL Advanced Spreadsheets
Unit 2 1.1.1 - Apply Conditional Formatting
Unit 3 1.1.2 - Create and Apply Custom Number Formats
Unit 4 1.1.3 - Split Text to Columns
Unit 5 1.2.1 - Copy & Move Worksheets Between Spreadsheets
Unit 6 1.2.2 - Split a Window & Move & Remove a Split Bar
Unit 7 1.2.3 Pt1 - Hide & Show Rows Columns
Unit 8 1.2.3 Pt2 - Hide & Show a Worksheet
Unit 9 1.2.4 - Save a Spreadsheet as a Template
Unit 10 2.1.1 - Use Date & Time Functions for Today Now Day Month & Year
Unit 11 2.1.2 - Use Logical Functions AND OR XOR & NOT
Unit 12 2.1.3 Pt1 - Use Mathematical Functions Rounddown & Roundup
Unit 13 2.1.3 Pt2 - Use Mathematical Functions SUMIF
Unit 14 2.1.4 - Use Statistical Functions COUNTIF COUNTBLANK and RANK
Unit 15 2.1.5 Pt 1 - Use Text Functions LEFT RIGHT CONCATENATE
Unit 16 2.1.5 Pt 2 - Use Text Function LEN
Unit 17 2.1.5 Pt 3 - Use Text Function MID LEN & TRIM
Module 5 Advanced Databases
Unit 1 Intro to ICDL Advanced Databases
Unit 2 1.1 - Understanding Databases
Unit 3 1.2 - Understanding Databases - Key Concepts
Unit 4 1.3 - Understanding Databases - Database Organisation
Unit 5 1.4 - Understanding Databases - Relationships
Unit 6 1.5 - Understanding Databases - Operation
Unit 7 2.1 - Using the Application
Unit 8 2.2 - Using the Application - Working with Databases
Unit 9 2.3 - Using the Application - Common Tasks
Unit 10 3.1 - Tables
Unit 11 3.2 - Tables - Records
Unit 12 3.3 - Tables - Design
Unit 13 4.1 - Retrieving Information
Unit 14 4.2 - Retrieving Information - Main Operations
Unit 15 4.3 - Retrieving Information - Queries
Unit 16 5.1 - Doing More with Access
Unit 17 5.2 - Doing More with Access - Forms
Unit 18 6.1 - Outputs
Unit 19 6.2 - Outputs Reports, Data Export
Unit 20 6.3 - Outputs - Printing
Module 6 Advanced Presentations
Unit 1 Intro to ICDL Advanced Presentations
Unit 2 1.1.1 - 1.2.3 - Presentation Planning
Unit 3 2.1.1 - Insert a New Slide Master or Layout
Unit 4 2.1.2 Pt 1 - Format Bullet Lists & Background in Master Layouts
Unit 5 2.1.2 Pt 2 - Placeholder Position and Deletion
Unit 6 2.1.3 - Apply A Custom Master to Specific Slides
Unit 7 2.2.1 - 2.2.2 - Create a New Template & Save a Presentation as a Template
Unit 8 3.1.1 - 3.1.5 - Formatting Drawn Objects
Unit 9 3.2.1 - 3.2.3 - Formatting Pictures & Images
Unit 10 3.3.1 - 3.3.2 - Turn On Ruler & Gridlines & Position to Specific Co-ordinates 0r Horizontal & Vertical Co-ordinates
Unit 11 3.3.3 - Add Modify Remove Alternative Text
Unit 12 3.3.4 - 3.3.5 - Distribute Selected Graphical Objects Horizontally Vertically Relative to a Slide and Each Other
Unit 13 3.3.6 - Crop a Grapical Object
Unit 14 3.3.7 - Convert a Picture to a Drawn Object and Edit the Drawn Object
Unit 15 3.3.8 - Save a Graphical Object as a File Format like BMP GIF JPEG or PNG
Unit 16 3.3.9 - Omit Display Background Graphics on a Slide
Unit 17 4.1.1 - Format Chart Title Legend Data Labels & Axes Labels
Unit 18 4.1.2 - Change the Chart Type for a Defined Data Series
Unit 19 4.1.3 - Change the Gap Overlap Between Columns Bars in a Chart
Unit 20 4.1.4 - Format Columns Bars Plot Area Chart Area to Display an Image
Unit 21 4.1.5 - Change Scale of Value Axis Min Max Number to Display Major Interval Between Plotted Numbers
Unit 22 4.2.1 - 4.2.2 - Create a Diagram Using Built-In Option & Add Move & Delete Shapes
Unit 23 4.2.3 - Add Change Delete Connectors in a Flowchart
Unit 24 5.1.1 - 5.1.2 - Imbed and Online Video into a Slide & Play Automatically or on Click
Unit 25 5.1.3 - 5.1.4 - Create and Insert Audio to Play Automatically or on Mouse Click
Unit 26 5.1.6 - Insert Audio to Play in Background for an Appropriate Duration
Unit 27 5.2.1 - Change Custom Animation Effects to Change Sequence in a Slide
Unit 28 5.2.2 - Apply Automatic Settings Bulleted Points Dim to Colour
Unit 29 5.2.3 - Animate Chart Elements by Series Category & Elements in Series without Grid or Legend