ICDL Professional: Advanced ICDL Modules with Microsoft Office provides coverage of the Advanced ICDL modules as part of the ICDL Professional learner profile. Readers can develop their understanding of Microsoft Office applications and prepare for their respective examinations using this step-by-step guide.
Learners have the opportunity to further their understanding of Microsoft Office applications including Word, Excel, PowerPoint and Access. The overall aim of this book is to give readers a clear, detailed guide to help them improve upon their existing skills and learn advanced features of each of the applications covered.
TOPICS COVERED INCLUDE:
Advanced Word Processing
-
Apply advanced text, column, paragraph, and table formatting
-
Use templates, fields, and forms
-
Use referencing features including footnotes, endnotes, and captions
-
Insert cross references, indexes and create a table of contents
-
Use linking and embedding features
-
Use advanced mail merge features
-
Use automation features including macros
-
Collaborate and review documents
-
Insert headers and footers, as well as watermarks
-
Apply document security features
-
Work with master documents and subdocuments
Management & Financial Spreadsheets
-
Create, edit, and format charts
-
Link cells, worksheets, and workbooks
-
Create, edit, and format spreadsheet templates
-
Use databases and data tables
-
Create and use scenarios
-
Use complex functions and formulas
-
Financial functions
-
Create and use macros
-
Implement auditing techniques to check for errors
Advanced Presentation
-
Adjust colour schemes and background effects in a slideshow
-
Include animation, video clips and sound to slides
-
Use drawing tools
-
Create and edit charts and flowcharts
-
Format text, use bullets, numbering and fonts
-
Create custom slide shows
-
Establish links to other objects outside the presentation
Advanced Database
-
Understand how to create and use advanced databases
-
Develop advanced relationships between tables
-
Use queries such as table, update, delete and append data
-
Refine data using wildcards, parameters, and calculations
-
Develop forms and use controls to improve functionality
-
Create report controls to do calculations and include subreports
-
Develop macros and use linking