Computer Literacy
The three day Computer Literacy course has been designed for people who are new to computers or have a basic understanding.
This comprehensive three day workshop will develop users knowledge of Windows, E-mail, Internet and Word Processing.
Workshop Outcomes:
This comprehensive three day workshop will develop users knowledge of Windows, E-mail, Internet and Word Processing.
Workshop Outcomes:
- Windows Basic
- Internet
- Word Processor
Introduction to Excel
This workshop is designed for business users who wish to use the power of Excel 2007 / 2010. The workshop will teach the basics and fundamentals of Excel. The workshop will benefit users from Sales, Marketing, Human Resources, Finance and other functions of the business.
Workshop Outcomes:
Workshop Outcomes:
- Opening / Closing Spreadsheets
- Working with worksheets
- Excel User Interface
- Formatting spreadsheets
- Entering Formulas (Sum, Count, Max, Min, Average)
- Spell Check / Theseorus
- Auto Complete & Autofill
- Entering Comments
- Using Help
- Printing Spreadsheets
Advanced Excel
This two day workshop is designed for business users who are familiar with Excel and would like to learn advanced tables, graphs and data functions.
The workshop will benefit users from Sales, Marketing, Human Resources, finance and other functions of the business.
Workshop Outcomes:
The workshop will benefit users from Sales, Marketing, Human Resources, finance and other functions of the business.
Workshop Outcomes:
- Formatting Tables
- Sorting & Filtering Tables
- Aggregating Tables
- Aggregation of Sumif, Averageif, Countif Formulas
- Using Date Formulas
- Logical Formulas (Vlookup, Hlookup, If
- Text Formulas
- Finance Formulas
- Auditing Formulas
- Connecting to External Data
- Using Excel as a Database
- Creating Graphs in Excel
Introduction to PowerPoint
his one day workshop is designed for business users who wish to learn how to use PowerPoint to create effective presentations. This one day workshop focuses on the basic principles, methods and techniques of PowerPoint.
Workshop Content:
Workshop Content:
- Create a new slide presentation
- Apply a design to slides
- PowerPoint layouts
- Formatting Slides
- Save Presentations in Different Formats
- Creating Presentations from Templates
- Spelling and Grammar
- Creating Shapes and Graphics¨ Inserting Images
- Inserting Slide Shows
- Printing Slides
Advanced PowerPoint
This one day workshop is designed for business users who are familiar with PowerPoint and wish to create more effective presentations. This course teaches the processes for using SmartArt, transitions and animations.
Workshop Content:
Workshop Content:
- Working with Images, Drawings & Objects
- Create SmartArt
- Processes
- Hierarchies
- Organisational Charts
- Graphs
- Creating Master Slides
- Apply Animation to Slides
- Apply Transitions to slides
- Rehearse and Practice a Slide show
- Create Hand-outs
- Printing Slides
Intermediate Word
This two day workshop is designed for business users who wish to become familiar with Microsoft Word and its functions to create professional documents and reports.
Workshop Content:
Workshop Content:
- Formatting Text
- Using Symbols & Special Characters
- Using Borders
- Inserting Fields
- Formatting Paragraphs
- Working with Bullets
- Create Tables and Columns
- Applying Page Borders
- Page & Section Breaks¨
- Using Headers & Footers
- Creating Foot Notes & End Notes
- Working with Multiple Documents
- Creating Templates
Advanced Word
This two day workshop is designed for business users who are familiar with Microsoft Word and wish to learn advanced functions to create professional documents.
Workshop Content:
Workshop Content:
- Creating references in Word
- Table of Contents
- Table of Figures
- Table of Authorities
- Index
- Updating version information in Word
- Linking Word to Other MS Office applications
- Link to Excel
- Link to PowerPoint
- Look up & Research Information
- Insert Bookmarks
- Create Captions and Cross References
- Protecting and Securing Documents
- Creating Forms in Word
- Create a Webpage