Module 1	Introduction to ICDL Advanced
Unit 1	Intro to ICDL 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.
Unit 12	ICDL Word Processing - Practice Test 1
Unit 13	Video training - Microsoft Word 2019 Advanced
Unit 14	01-01 - Introduction
Unit 15	01-02 - Getting Help
Unit 16	01-03 - Exercise 01
Unit 17	02-01 - Keyboard Shortcuts
Unit 18	02-02 - ScreenTips
Unit 19	02-03 - The Ribbon
Unit 20	02-04 - Using Rulers
Unit 21	02-05 - Find and Replace Formatting
Unit 22	02-06 -Find and Replace Special Characters
Unit 23	02-07 - Navigation Pane and GoTo
Unit 24	02-08 - Checking Spelling, Grammar and Conciseness
Unit 25	02-09 - AutoCorrect
Unit 26	02-10 - Grouping Objects
Unit 27	02-11 - Aligning Objects
Unit 28	02-12 - Exercise 02
Unit 29	03-01 - The View Tab
Unit 30	03-02 - Reading & Focusing on Documents
Unit 31	03-03 - Print and Web Layout View
Unit 32	03-04 - Draft & Outline View
Unit 33	03-05 - Exercise 03
Unit 34	04-01 - Table Style
Unit 35	04-02 - Table Breaks and Repeat Headings
Unit 36	04-03 - Formulas in Tables
Unit 37	04-04 - Exercise 04
Unit 38	05-01 - Formatting WordArt
Unit 39	05-02 - Filling Shapes with Pictures
Unit 40	05-03 - Compressing Pictures
Unit 41	05-04 - Quick Parts
Unit 42	05-05 - Icons and 3D Models
Unit 43	05-06 - Inserting Captions
Unit 44	05-07 - Creating Table of Figures
Unit 45	05-08 - Exercise 05
Unit 46	06-01 - Text Box Gallery
Unit 47	06-02 - Text Box Alignment and Margins
Unit 48	06-03 - Sidebars
Unit 49	06-04 - Linking Text Boxes
Unit 50	06-05 - Exercise 06
Unit 51	07-01 - Layout Tab
Unit 52	07-02 - Section and Page Breaks
Unit 53	07-03 - Inserting Section and Page Breaks
Unit 54	07-04 - Headers and Footers in Sections
Unit 55	07-05 - Page Borders in Sections
Unit 56	07-06 - Field and Documents Properties
Unit 57	07-07 - Column Breaks
Unit 58	07-08 - Master and Sub-documents
Unit 59	07-09 - Exercise 07
Unit 60	08-01 - Inserting Hyperlinks
Unit 61	08-02 - Linking to Excel Data
Unit 62	08-03 - Exercise 08
Module 4	Advanced Word Processing - Quizzes / Practice Exams
Unit 1	Quiz - Advanced Word Processing
Module 5	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
Unit 18	2.1.6 Use financial functions fv, pv, pmt
Unit 19	2.1.7 Use lookup functions vlookup, hlookup
Unit 20	2.1.8 Use database functions dsum, dmin, dmax, dcount, daverage
Unit 21	2.1.9 Create a two-level nested function
Unit 22	2.1.10 Use a 3-D reference within a sum, average, minimum, maximum function
Unit 23	2.1.11 Use mixed references in formulas
Unit 24	3.1.1 Create a combined chart like column and line, column and area
Unit 25	3.1.2 Create Sparklines
Unit 26	3.1.3 Add a secondary axis to a chart
Unit 27	3.1.4 Change the chart type for a defined data series
Unit 28	3.1.5 Add, delete a data series in a chart
Unit 29	3.2.1 Re-position chart title, legend, data labels
Unit 30	3.2.2 Change scale of value axis minimum, maximum number to display, major interval
Unit 31	3.2.3 Change display units on value axis without changing data source hundreds, thousands, millions
Unit 32	3.2.4 Format columns, bars, pie slices, plot area, chart area to display an image
Unit 33	4.1.1 Create, modify a pivot table/datapilot
Unit 34	4.1.2 Modify the data source and refresh the pivot table/datapilot
Unit 35	4.1.3 Filter, sort data in a pivot table/datapilot
Unit 36	4.1.4 Automatically, manually group data in a pivot table/datapilot and rename groups
Unit 37	4.1.5 Use one-input, two-input data tables/multiple operations tables
Unit 38	4.2.1 Sort data by multiple columns at the same time
Unit 39	4.2.2 Create a customized list and perform a custom sort
Unit 40	4.2.3 Automatically filter a list in place
Unit 41	4.2.4 Apply advanced filter options to a list
Unit 42	4.2.5 Use automatic, manual outline features group, ungroup, sub-total
Unit 43	4.2.6 Expand, collapse outline detail levels
Unit 44	4.3.1 Create named scenarios
Unit 45	4.3.2 Show, edit, delete scenarios
Unit 46	4.3.3 Create a scenario summary report
Unit 47	5.1.1 Set, edit validation criteria for data entry in a cell range like whole number, decimal, list, date, time
Unit 48	5.1.2 Enter input message and error alert
Unit 49	5.2.1 Trace precedent, dependent cells. Identify cells with missing dependents
Unit 50	5.2.2 Display all formulas in a worksheet, rather than the resulting values
Unit 51	5.2.3 Insert, edit, delete, show, hide commentsnotes in a worksheet locally, online
Unit 52	6.1.1 Name cell ranges, delete names for cell ranges
Unit 53	6.1.2 Use named cell ranges in a function
Unit 54	6.1.3 Activate, deactivate the group mode
Unit 55	6.2.1 Use paste special options add, subtract, multiply, divide
Unit 56	6.2.2 Use paste special options values numbers, transpose
Unit 57	6.2.3 Creating a spreadsheet based on an existing model
Unit 58	6.2.4 Modifying a model
Unit 59	6.3.1 Insert, edit, remove a hyperlink
Unit 60	6.3.2 Link data within a spreadsheet, between spreadsheets
Unit 61	6.3.3 Update, break a link
Unit 62	6.3.4 Import delimited data from a text file
Unit 63	6.4.1 Record a simple macro like change page setup, apply a custom number format, apply autoformats to a cell range, insert fields in worksheet header, footer
Unit 64	6.4.2 Run a macro
Unit 65	6.4.3 Assign a macro to a custom button
Unit 66	6.4.4 Activating, deactivating revisions Tracking changes
Unit 67	6.4.5 Accepting, rejecting changes in a worksheet
Unit 68	7.1.1 Compare and merge spreadsheets
Unit 69	7.1.2 Add, remove password protection for a spreadsheet to open, to modify
Unit 70	7.1.3 Protect, unprotect cells, worksheet with a password
Module 6	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
Unit 21	Video Training - Microsoft Access 2019
Unit 22	01-01 - Introduction to Access 2019
Unit 23	01-02 -  Acquiring Access 2019
Unit 24	01-03 -Structure of the Course
Unit 25	02-01 - Using Database Template
Unit 26	02-02 - Creating, Saving, and Opening Databases
Unit 27	02-03 - Access Workspace and Backstage
Unit 28	02-04 - Online Help
Unit 29	03-01 -  Working with the Ribbon
Unit 30	03-02 - Quick Access Toolbar
Unit 31	03-03 - Contextual Menus
Unit 32	03-04 - The Status Bar
Unit 33	04-01 - Keyboard Shortcuts
Unit 34	04-02 - Key Tips
Unit 35	05-01 - Access Options
Unit 36	06-01 - Creating a Table and Fields
Unit 37	06-02 - Indexing Fields
Unit 38	06-03 - Lookup Wizard
Unit 39	06-04 - Numeric Fields
Unit 40	06-05 - Exercise 01
Unit 41	07-01 - Importing Data from Excel
Unit 42	07-02 - Exercise 02
Unit 43	08-01 - Backing Up Your Database
Unit 44	08-02 - Compact and Repair
Unit 45	09-01 - Design in the Datasheet View
Unit 46	09-02 - Sorting and Filtering in Datasheet View
Unit 47	09-03 - Entering and Modifying Data in Datasheet View
Unit 48	10-01 - Creating a Link Table
Unit 49	10-02 - Setting Up Relationships
Unit 50	10-03 - Exercise 03
Unit 51	01 - 01 Advanced Course Overview and Content Part 2
Unit 52	02-01 - Primary Keys and Indexing Rules and Guidelines
Unit 53	02-02 - More About Indexes
Unit 54	03-01 - Setting Up Northwind Database
Unit 55	03-02 - Working in Datasheet View
Unit 56	03-03 - Customizing Datasheet View, Sorting and Filtering Options
Unit 57	03-04 - Subdatasheets
Unit 58	03-05 - Exercise 01
Unit 59	04-01 -  Linking to Tables in Other Databases
Unit 60	05-01 - Acquiring and Installing SQL Server Express
Unit 61	05-02 - Exercise 02
Unit 62	06-01 - Splitting Database into Front-end and Back-end
Unit 63	06-02 - Converting a Shared Table into a Local Table
Unit 64	06-03 - Exercise 03
Unit 65	06-04 - Addressing Multi-User Issues when Sharing Data
Unit 66	07-01 - Basics of Macros
Unit 67	07-02 - Macros on Events; AutoExec
Unit 68	07-03 - More about AutoExec
Unit 69	07-04 - Macro Security Settings
Unit 70	07-05 - Exercise 04
Module 7	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
Unit 30	Video training - Microsoft PowerPoint PowerPoint 2019
Unit 31	01-01 - Welcome and Overview
Unit 32	02-01 - Navigate a PowerPoint Presentation
Unit 33	02-02 - Overview of the Screen and Views
Unit 34	02-03 - Exercise 01
Unit 35	03-01 - Presentation Tips and Guidelines
Unit 36	03-02 - Creating a New Presentation
Unit 37	03-03 - Working with Slides
Unit 38	03-04 - Saving a Presentation
Unit 39	03-05 - Exercise 02
Unit 40	04-01 - Formatting Text
Unit 41	04-02  - Working with Bullets and Numbered Lists
Unit 42	04-03 - Exercise 03
Unit 43	05-01 - Inserting Shapes
Unit 44	05-02 - Inserting Graphics
Unit 45	05-03 - Inserting Icons and 3D Models
Unit 46	05-04 - Inserting Pictures
Unit 47	05-05 - Exercise 04
Unit 48	06-01 - Selecting Objects
Unit 49	06-02 - Editing Objects
Unit 50	06-03 - Formatting Objects - Part 1
Unit 51	06-04 - Formatting Objects - Part 2
Unit 52	06-05 - Arranging Objects
Unit 53	06-06 - Grouping Objects
Unit 54	06-07 - Exercise 05
Unit 55	07-01 - Picture Options
Unit 56	07-02 - Cropping Pictures
Unit 57	07-03 - Formatting Pictures
Unit 58	07-04 - Things You Can Do with Pictures
Unit 59	07-05 - Exercise 06
Unit 60	08-01 - Creating SmartArt
Unit 61	08-02 - Modifying SmartArt
Unit 62	08-03 - Creating a Flowchart using SmartArt
Unit 63	08-04 - Exercise 07

Powered By WP Courseware