Recognition: Certificate of Completion
Course Category: Level 02
Ideal Target Audience: Learners with limited knowledge on the subject. Junior staff. Microsoft Office Beginners. Learners who require an introduction to Microsoft Excel.
Course Duration: 6 to 8 Hours
Language: English
Course Value/ Price: R1750.00 VAT Incl
   

SHORT COURSE DESCRIPTION:


As a beginner, it helps to know how to use Excel productively. This includes knowing important keyboard shortcuts, mouse shortcuts, Excel customizations & how to create an appealing, readable workbook. Once you know the basics, chances are you will be asking for more. Anyone with good Excel skills is always in demand. Excel is quite intuitive and simple to use when it comes to typing data or handling it. Because of its grid nature, it can store & manage thousands of data points with ease. Using formulas, you can calculate totals, summaries, answer questions and gain insights.

What you will learn:


Lesson 1: Introduction to Microsoft Excel
Lesson 2: Workbook Overview
Lesson 3: Working with Cells and Ranges
Lesson 4: Performing Basic Calculations
Lesson 5: Working with Tables
Lesson 6: Formatting and Visual Effects
Lesson 7: Customizing Workbooks
Lesson 8: Prepare Worksheets for Print
 

Note: For the best learning experience we recommend using the additional reading in conjunction with the interactive online training modules.

Recognition: Certificate of Completion
Course Category: Level 02
Ideal Target Audience: Learners with basic knowledge on the subject. Persons who've already attended an Excel Basics course or familiar with the basics of Excel. 
Course Duration: 6 to 8 Hours
Language: English
Course Value/ Price: R1750.00 VAT Incl
   

SHORT COURSE DESCRIPTION:


To increase your proficiency, you need to know how to perform advanced calculations, analyse data, and display spreadsheet data in a visually effective manner. In this course, you will use advanced formulas and tools to streamline and analyse spreadsheet data. You will also enhance the look and appeal of your workbooks by adding charts and other graphical objects. This course is for anyone who has used Excel before to create and alter spreadsheets and perform basic calculations. Learners must have used Excel before and be familiar with using formulae for calculations.

What you will learn:


Lesson 1: Customize the Excel Environment
Lesson 2: Creating Advanced Formulas
Lesson 3: Analysing Date with Functions
Lesson 4: Organising Datasets and Tables
Lesson 5: Visualising Data with Charts
Lesson 6: PivotTables and Pivot Charts
Lesson 7: Inserting Graphic Objects
Lesson 8: Changing Workbook Appearance
 

Note: For the best learning experience we recommend using the additional reading in conjunction with the interactive online training modules.

Recognition: Certificate of Completion
Course Category: Level 03
Ideal Target Audience: Persons with intermediate knowledge of Microsoft Excel. Financial Analysts, Credit and Risk Managers, Corporate Finance Staff.
Course Duration: 6 to 8 Hours
Language: English
Course Value/ Price: R1750.00 VAT Incl
   

SHORT COURSE DESCRIPTION:


To increase your proficiency, you need to know how to perform advanced calculations, analyse data, and display spreadsheet data in a visually effective manner. In this course, you will use advanced formulas and tools to streamline and analyse spreadsheet data. You will also enhance the look and appeal of your workbooks by adding charts and other graphical objects. This course is for anyone who has used Excel before to create and alter spreadsheets and perform basic calculations. Learners must have used Excel before and be familiar with using formulae for calculations.

What you will learn:


Lesson 1: Formulas and Data Analysis Part 1
Lesson 2: Formulas and Data Analysis Part 2
Lesson 3: Mathematics, Text and Logic
Lesson 4: Working with Date and Time
Lesson 5: Functions for Analysing Statistics
Lesson 6: Analyzing Data with PivotTables
Lesson 7: Performing What-If Analysis
Lesson 8: Automating Excel with Macros
 

Note: For the best learning experience we recommend using the additional reading in conjunction with the interactive online training modules.

Recognition: Certificate of Completion
Course Category: Level 02
Ideal Target Audience: Learners with limited knowledge on the subject. Junior staff. Microsoft Office Beginners. Learners who require an introduction to Microsoft Outlook email management.
Course Duration: 6 to 8 Hours
Language: English
Course Value/ Price: R1750.00 VAT Incl
   

SHORT COURSE DESCRIPTION:


Outlook is part of the Microsoft Office suite of apps, which also include Microsoft Access, Excel, PowerPoint, and Word. Electronic messaging keeps many of us in contact with colleagues, clients, friends, and family members. For people who are dependent on electronic communications—and even more so for those who work in enterprises that use Microsoft Exchange Server, SharePoint, and Skype for Business to manage collaboration—Outlook offers an ideal solution. From one place, you can quickly create, store, organize, manage, and retrieve messages, address books, calendars, task lists, and more.

What you will learn:


Lesson 1: Getting Started with Outlook
Lesson 2: Working with Outlook Modules
Lesson 3: Manage Email Messages
Lesson 4: Organize your Inbox
Lesson 5: Manage Contact Information
Lesson 6: Manage your Calendar
Lesson 7: Manage Email Security
Lesson 8: Customise Outlook
 

Note: For the best learning experience we recommend using the additional reading in conjunction with the interactive online training modules.

Recognition: Certificate of Completion
Course Category: Level 02
Ideal Target Audience: Learners with limited knowledge on the subject. Junior staff. Microsoft Office Beginners. Learners who require an introduction to Microsoft Word.
Course Duration: 6 to 8 Hours
Language: English
Course Value/ Price: R1750.00 VAT Incl
   

SHORT COURSE DESCRIPTION:


Microsoft Word is part of the Microsoft Office suite of apps, which also include Microsoft Access, Excel, PowerPoint, and Outlook. Microsoft Word or MS-WORD (often called Word) is a graphical word processing program that users can type with. It is made by the computer company Microsoft. The purpose of the MS Word is to allow the users to type and save documents. Similar to other word processors, it has helpful tools to make documents.

What you will learn:


Lesson 1: Getting started with Microsoft Word
Lesson 2: Navigate, Select and Edit Text
Lesson 3: Formatting Text and Paragraphs
Lesson 4: Working with Tables in Word
Lesson 5: Inserting Graphic Objects
Lesson 6: Controlling Page Appearance
Lesson 7: Proofing a Document
Lesson 8: Customizing the Word Environment
 

Note: For the best learning experience we recommend using the additional reading in conjunction with the interactive online training modules.

Recognition: Certificate of Completion
Course Category: Level 02
Ideal Target Audience: Learners with limited knowledge on the subject. Junior staff. Microsoft Office Beginners. Learners who require an introduction to Microsoft PowerPoint.
Course Duration: 6 to 8 Hours
Language: English
Course Value/ Price: R1750.00 VAT Incl
   

SHORT COURSE DESCRIPTION:


Microsoft PowerPoint is a powerful presentation software developed by Microsoft. It is a standard component of the company’s Microsoft Office suite software, and is bundled together with Word, Excel and other office productivity tools. The program uses slides to convey information rich in multimedia. PowerPoint was originally designed to provide visuals for group presentations within business organizations, but has come to be very widely used in many other communication situations, both in business and beyond. The impact of this much wider use of PowerPoint has been experienced as a powerful change throughout society.

What you will learn:


Lesson 1: Getting Started with Powerpoint
Lesson 2: Develop a Presentation
Lesson 3: Working with Slide Masters
Lesson 4: Performing Advanced Text Editing
Lesson 5: Adding Graphic Elements
Lesson 6: Adding Tables to your Presentation
Lesson 7: Adding Charts to your Presentation
Lesson 8: Preparing to Deliver your Presentation
 

Note: For the best learning experience we recommend using the additional reading in conjunction with the interactive online training modules.