ICP Consulting
Tel: 011 510 0555
  • Home
  • About Us
  • Discipline
    • Conducting a Disciplinary Hearing
    • Discipline in the Workplace
  • Softskills
    • Supervisor Training
    • Conflict Management
    • Health and Safety>
      • SHE Awareness
      • SHEQ Representative
      • Legal Liability
    • Communicate
    • Customer Care
  • Microsoft Office
    • Computer Literacy
    • Introduction to Excel
    • Advanced Excel
    • Introduction to PowerPoint
    • Advanced PowerPoint
    • Intermediate Word
    • Advanced Word
  • Insight
    • Business Data Analysis
    • PowerPivot
  • Contact Us

Computer Literacy

Picture
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:
  • Windows Basic
  • Internet 
  • E-mail
  • Word Processor


Introduction to Excel

Picture
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:
  •  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

Picture
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:
  • 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

Picture
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:
  • 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

Picture
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:
  •  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

Picture
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:
  • 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

Picture
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:
  • 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

SETA Accreditation 4057, BEE Status 4