IT Level 3 (ICDL Advanced) eBook Course

By the end of this course you shall update your IT skills in the following areas:

Microsoft Word
You will develop advanced word processing skills to format text and tables, work with referencing features and create tables of contents. You will improve your productivity by using fields, forms and templates. You will learn how to use advanced mail merge and macros, work with master documents and subdocuments, and work with watermarks, sections, headers and footers.

• Apply advanced text, paragraph, column and table formatting. Maintain a consistent design through the use of character and paragraph styles.
• Work with referencing features like footnotes, endnotes and captions. Manage citations and bibliography using a chosen citation style. Create tables of contents, indexes and cross-references.
• Enhance productivity by using fields, forms and templates.
• Apply advanced mail merge techniques and work with automation features like macros.
• Use linking and embedding features to integrate data.
• Collaborate on and review documents locally or online. Apply document security features.
• Work with watermarks, sections, and headers and footers in a document. Use a thesaurus and manage spell check settings.

Microsoft Excel
You will develop your skills with Excel to an advanced level so you can use sophisticated functions, create charts and apply advanced chart formatting features, work with tables and lists to analyse, filter and sort data. You will learn how to create and use scenarios and pivot tables, validate and audit spreadsheet data. You will enhance your productivity by working with named cell ranges, macros and templates. And you will learn about applying spreadsheet security.

• Apply advanced formatting options such as conditional formatting and customised number formatting and handle worksheets.
• Use functions such as those associated with logical, statistical, financial and mathematical operations.
• Create charts and apply advanced chart formatting.
• Work with tables and lists to analyse, filter and sort data. Create and use scenarios.
• Validate and audit spreadsheet data.
• Enhance productivity by working with named cell ranges and macros.
• Use linking, embedding and importing features to integrate data.
• Compare and merge spreadsheets. Apply spreadsheet security features.

Microsoft Access
You will develop your skills in using Microsoft Access including: understanding key concepts in database development and usage, creating a relational database, designing and refining queries using wildcards, parameters and calculations, using controls and sub forms to enhance forms and improve functionality. You will also learn how to create report controls to perform calculations and work with macros.

• Understand key concepts of database development and usage.
• Create a relational database using advanced table creation features and complex relationships between tables.
• Design and use queries to create a table, update, delete and append data. Refine queries using wildcards, parameters and calculations.
• Use controls and subforms to enhance forms and improve functionality.
• Create report controls to perform calculations. Create subreports and enhance report presentation.
• Enhance productivity by working with macros and use linking and importing features to integrate data.

Microsoft PowerPoint
You will learn how to make advanced PowerPoint presentations including: how to understand your target audience, creating and modifying templates and formatting slide backgrounds. You will learn how to use built-in drawing and image tools, apply advanced chart formatting features and create and edit diagrams, insert movies and sound and apply built-in animation features. You will focus on how to work with custom slide shows, apply slide show setting, and control a slide show.

• Understand target audience, venue and technical considerations in presentation planning.
• Create and modify templates and themes, and work with slide master layouts.
• Enhance a presentation using built-in drawing and image tools. Use alternative text for accessibility.
• Apply advanced chart formatting features and create and edit diagrams.
• Insert audio and video, create audio and screen recordings, and apply built-in animation features.
• Use linking, embedding, importing and exporting features to integrate data. Use password protection to secure a presentation.
• Work with custom slide shows and apply slide show settings. Use presenter view and control a slide show.

Improving Productivity of Using IT
Finally, you will focus on how to improve your productivity in general through IT use.