CODE: LCL I301

Pre-requisites/ Input Criterion: The candidate should:

Have completed the LAQSH Computer Literacy Skills- LCLF300 Program
OR
Fulfil the Exit Criterion Assessment for the LAQSH Computer Literacy Skills- LCLF300 Program

Duration: 36 hours

Course description: This course offers to get you to the next step of working on MS Office. This course is designed for those users who wish to step up their current knowledge of MS Office to take advantage of the more complex features.

• MS Word:
  • Reusing styles between documents, Adding text columns
  • Footnotes, Master documents, Creating sections to break up documents, Document outlines
  • Creating the template to receive merged data
  • Merging data into letters, Merging data into labels, Merging data into lists
  • Inserting hyperlinks, Inserting bookmarks, HTML elements
  • Inserting spreadsheets, Preparing and inserting graphic elements
  • Distributing documents electronically, Exporting Web pages
• MS Excel:
  • Cell referencing, ranges and functions
  • Using special formulas and auditing them
  • Creating Advanced Filters
  • Sharing Workbooks
  • Custom Views, report Managers
  • Creating Hyperlinks and using the Outlining feature
• MS PowerPoint:
  • Building Custom Presentations
  • Using Multimedia in Presentations
  • Using Advanced Organisation Charts and Formatting and modifying Tables
  • Advanced Presentation Techniques
  • Advanced Presentation Delivery Options
  • Customising the Environment
  • Microsoft Office Integration

{showhide title=”Read More…” template=”strong” changetitle=”Hide This…” mousetitleistitle=true closeonclick=true titleasspan=true}

Subsequent to course completion: You will be able to:

• Work on all Menus and Options in MS Word.
• Perform calculations and functions within a workbook in Excel
• Manipulate data lists and create custom charts which will enable the user to maintain and present data in a professional environment.
• Make your statistical data usage clear and formatted for longer and intense numerical calculations
• Use templates to build custom presentations in MS PowerPoint
• Introduce much more stimulating graphical and animated content.
• Interrelate your presentation with both Excel and Word files.

{/showhide}