Lean how to get the most out of your office application suite. Knowing the proper use of the tools at your disposal will both improve productivity and the quality of documents produced.
|Course||Who Should Attend||Prerequisites||Duration|
|Computer Orientation||Anyone who is not confident in using a computer, who does not know how to type on a PC, or who is not practiced with using a computer.||Read and write English||1 Day|
|Excel 2013 VBA||Excel Advanced User||Excel Knowledge preferably Advanced Excel||3 days|
|Excel Dashboards||Excel Intermediate||1 Day|
|Excel for Statistical Analysis||Any person currently using Excel at an advanced level and needs to use Excel tools to draw statistical analyses on data.||Proficiency in Excel with evidence of experience in tools from Basic to Advanced. Complete our Basic to Advanced Excel Course if not.||2 day|
|Excel Productivity||Excel users who need to develop and produce quality reporting on a regular basis.||Good understanding of Excel and excel formulas.||3 Days|
|Microsoft Access 2007||This Microsoft Access course will benefit Database Developers and Users who are looking for a flexible environment for creating relational databases.||Computer Literacy||2 Days|
|Microsoft Excel 2013: Advanced||This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyse worksheet data, incorporate multiple data sources, and import and export data.||To ensure your success, we recommend you first take the following courses or have equivalent knowledge: Microsoft Office Excel Basic and Microsoft Office Excel Intermediate||1 Day|
|Microsoft Excel 2013: Basic||This course is designed for people preparing for certification as a Microsoft Certified Application Specialist in Excel, who already have knowledge of Microsoft Office, Windows 2000 (or above), and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2013 worksheets.||Students should be familiar with using personal computers and have used a mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer.||1 Day|
|Microsoft Excel 2013: Intermediate||The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyse data, and work with Excel on the web||Microsoft Office Excel Basic||1 Day|
|Microsoft Outlook Level 1||For multiple or individual users in organizations and/or for personal use. This course is intended for people have a basic understanding of Windows and want or need t know how to Use Outlook as an email client to mange their emails communications, calendar events, contact information, and other||Using Windows 8 or 10 Computer Literacy||1 Day|
|Microsoft Power BI Desktop Advanced Course||IT staff, technical business analysts, database administrators, data analysts, BI specialists, knowledge workers, and those involved in the maintenance of the master data model of the company||The Power BI Desktop course is a pre-requisite for the course. Alternatively, delegates should have at least 3 months experience in using Power BI Desktop for creating reports and dashboards The delegates be experienced in accessing different data sources, including Excel workbooks and Microsoft SQL Server. The delegates may have experience in building data models, using ETL, cleaning data and creating new data columns and measures.||3 day|
|Microsoft Power BI Desktop User Course||It is intended for use by non-IT staff, including both Line and Senior Managers, Personal Assistants, Business Analysts, BI Specialists, and Knowledge Workers||Delegates must have a working knowledge of Microsoft Windows, and either Microsoft Edge, Microsoft IE, or Google Chrome Delegates should have a working knowledge of either Microsoft Excel or another reporting tool Delegates should have experience in doing reporting||2 day|
|Microsoft PowerBI Dashboard User Course||Roles include the executive team, their personal assistants, divisional heads, line managers, as well as personnel who need to receive alerts on changes in data||Delegates must have a working knowledge of Microsoft Windows, and either Microsoft Edge, Microsoft IE, or Google Chrome. Delegates should be able to use one of the Microsoft Office applications on a basic level. Delegates should have some experience in doing reporting||1 day|
|Microsoft PowerPoint Level 1||The Microsoft PowerPoint course is for business professionals, entrepreneurs, and students who would like to, create or use presentations as a part of their work.||To ensure success, students should be familiar with using personal computers, and should have experience using a keyboard and mouse. Students should be comfortable in the Windows® 8 environment, and be able to use Windows 8 to manage information on their computers. Specific tasks the students should be able to perform, include launching and closing applications, navigating basic file structures, and managing files and folders. To meet this prerequisite, you can take any one or more of the follo||1 Day|
|Microsoft PowerPoint Level 2||This course is intended for students who have a foundational working knowledge of PowerPoint 2013, who wish to take advantage of the application's higher-level usability, security, collaboration, and distribution functionality.||To ensure success, students should have experience using PowerPoint 2013, running within the Windows® 8 operating system, to create, edit, and deliver multimedia presentations. To attain this level of knowledge and skills, you can take the following Logical Operations courses: • Using Microsoft® Windows® 8 • Microsoft® Windows® 8 Transition from Windows 7 • Microsoft® Office PowerPoint® 2013: Level 1||1 Day|
|Microsoft Project 2013||This course is for project managers and users to assist them in developing plans, assigning resources to tasks, tracking progress, managing budgets, and analysing workloads.||
If you are bringing your own laptop please make sure you have the 2013 version.
|Microsoft Visio||Business Analysts, management, IT Staff, Engineers||
If you are bringing your own laptop please make sure you have the 2013 version.
|Microsoft Word Level 1||
This course is intended for people who want to learn fundamentals Microsoft Word skills.
||Computer Literacy||1 Day|
|Microsoft Word Level 2||This course is designed for students who wish to use Microsoft Word to create and modify complex documents and use tools that allow them to customize those documents.||
To ensure success, students should be comfortable in Wimdows 8 or 10 environment, and be able to use Windows to manage information.
Specific tasks you should be able to perform include:
Before starting this course, student should have completed the following course:
|OpenOffice Writer||Everyone who would like to learn writer||Should be able to type||1 Day|
|US116937 Spreadsheet Assessment||Anyone who has a working knowledge of Microsoft Excel or any spreadsheet program who would like to be formally assessed as competent as per MICT SETA EQTA and earn credits on the NQF.||Basic Computer Skills Course or MS Excel Level 1 course if not proficient with using a spreadsheet. Delegates need to be able to type on a keyboard and have basic English literacy and computer literacy. LEARNING ASSUMED TO BE IN PLACE AND RECOGNITION OF PRIOR LEARNING The credit value of this unit standard is calculated assuming a person is competent in: Operate a personal computer system (ID 116932 - NQF Level 1) and Use generic functions in a Graphical User Interface (GUI)-environment (ID 1179||1 day|
|Windows 10 Basic Computer Course||End users, Office Administrators, Receptionist, Window 7 users who have updated to Windows 8 operating system||Familiarity with Windows on the desktop.||2 Days|
|Windows 7 Basic Computer Course||End users||Familiarity with Windows on the desktop.||2 Days|
|Windows 8 Basic Computer Course||End users, Office Administrators, Receptionist, Window 7 users who have updated to Windows 8 operating system||Familiarity with Windows on the desktop.||2 Days|