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|
|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|
|Intermediate Excel Saturdays||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 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|
|Advanced Excel Saturdays||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 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.||Computer Literacy.
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:
|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 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:
|Excel 2013 VBA||Excel Advanced User||Excel Knowledge preferably Advanced Excel||3 days|
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.
|Basic Excel Saturdays||Any Person wanting to learn Microsoft Excel||Computer Literate||1 day|
|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 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 Power BI Boot Camp||
It is intended for use by non-IT staff, including both Line and Senior Managers, Personal Assistants, Business Analysts, BI Specialists, and Knowledge Workers
No prior experience with Power BI or other BI tools is required, some experience with excel is desirable but not mandatory
|Microsoft Power BI Desktop Advanced Course||
This course is intended for people who have been working with Power BI, Excel pivot tables or SSAS tabular and are looking to understand how to create richer data models to enable deeper insight into their data.
The Power BI boot camp 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.
|Microsoft PowerBI Dashboard End User Course||
This is a bespoke course for specific audiences and is therefore not on our public schedule. This course needs to be customised to the unique settings of a business and will, therefore, be quoted on separately. The possible audience includes 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. This is a group course for between 6 - 8 delegates from one company. Extra delegates charge at R1000 per person.
|Microsoft Visio||Business Analysts, management, IT Staff, Engineers||Computer literacy
If you are bringing your own laptop please make sure you have the 2013 version.
|OpenOffice Writer||Everyone who would like to learn writer||Should be able to type||1 Day|
|Spreadsheet Assessment US116937||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. This is an RPL course - 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||1 day|
|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|
|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|