-
-
-
Excel 2016 Level 2 – Enhancing Workbooks
R150.00 Ex.VAT 15%Your workbooks can be customized in a number of different ways. Over the course of this topic, we will focus on customization through the addition of comments, hyperlinks, watermarks, and background pictures. -
Excel 2016 Level 2 – Organizing Worksheet Data with Tables
R150.00 Ex.VAT 15%This course covers how to create, format, and modify tables. We also cover using structured references, as well as the subtotal and database functions. -
Excel 2016 Level 2 – Creating Advanced Formulas
R150.00 Ex.VAT 15%In this course, students will learn how to use range names in formulas and functions, as well as how to use specialized functions. -
Excel 2016 Level 3: Automating Worksheet Functionality
R150.00 Ex.VAT 15%In Excel 2016, you can view, add, or even edit the properties of an existing workbook. These properties can include information such as who authored the workbook, date information, and more. This type information is referred to as metadata, and it can very useful when managing multiple workbooks. Over the course of this topic you will learn all about workbook properties and how to work with them. -
Excel 2016 Level 3: Auditing Worksheets
R150.00 Ex.VAT 15%To assist you in creating and troubleshooting formulas in a worksheet, the Trace Cells feature will graphically display where data is coming from and where it is going. For example, it can apply a colored outline to a range in a formula, as well as to where the solution of the formula is displayed. During this topic, you will learn about the Trace Cells feature and its related components. -
Excel 2016 Level 3: Analyzing and Presenting Data
R150.00 Ex.VAT 15%One way that you can add visual elements to data in a worksheet is to use Sparklines. Sparklines are essentially miniature graphs that can be inserted into just one cell in a worksheet. This system allows you to not only present worksheet data visually, but also not overwhelm or obstruct the numerical data itself. Over the course of this topic you will learn about Sparklines and how they can be inserted into your worksheets. -
Excel 2016 Level 3: Working with Multiple Workbooks
R150.00 Ex.VAT 15%Often times, users of Excel will be juggling multiple workbooks at once and this course takes a look at that skill. This course will teach students how to: consolidate data, link cells in different workbooks, and merge workbooks. -
Excel 2016 Level 3: Exporting Excel Data
R150.00 Ex.VAT 15%While Microsoft Excel is a very popular application, not everyone may have access to it. If you are in a situation where you need to send Excel data to someone and you are unsure if they have access to Microsoft Excel, you can export the data into a more universal format. Over the course of this topic, you will learn how to export Excel data into different file formats, as well as how to share workbooks with other users. -
Excel 2016 Level 2 – Inserting Graphics
R150.00 Ex.VAT 15%While the default appearance of your worksheets can be quite plain, Excel offers you access to a variety of graphical objects that you can use to enhance their visual appeal. Over the course of this topic, you will learn all about the various different types of graphical objects that you can add to your worksheets, as well as the various contextual tabs that are used to work with them. -
Excel 2016 Level 2 – Analyzing Data with PivotTables, Slicers, and PivotCharts
R150.00 Ex.VAT 15%One of the most powerful tools that you have your disposal when analyzing data in Excel is the PivotTable. While extremely useful, these interactive objects are somewhat cumbersome to execute properly and are often misused. For this reason it is important to understand how they work and gain some fundamental understanding of their purpose before creating PivotTables of your own data. -
Excel 2016 Level 2 – Visualizing Data with Charts
R150.00 Ex.VAT 15%While pure data can be analyzed by those familiar with this data and the tools that Excel provides, sometimes you need graphical assistance to help interpret it. Additionally, charts are an enormous help when people do not have time to study the data and only need a brief overview of the relevant information. Over the course of this topic, you will learn how to create charts of different types, using different methods in Excel 2016. -
-
Excel 2016 Level 3: Importing and Exporting XML Data
R150.00 Ex.VAT 15%XML (Extensible Markup Language) is a commonly used programming language that is frequently used to describe data. As such, you may find yourself needing to import and/or export XML data to and from Excel. Over the course of this topic, you will learn about these tasks. -
-
Mastering The Interview
R599.00 Ex.VAT 15%In this course, you will learn how to prepare for and participate in a job interview. Well share the types of questions to expect, as well as the questions that you should think about asking. You will also learn how to prepare for second interviews, testing, and shadowing, as well as how to follow up after an interview. -
Delegation: The Art Of Delegating Effectively
R599.00 Ex.VAT 15%This course will teach you how delegation can make you more successful, ways that you can delegate, techniques for giving instructions, how to monitor delegation results, and how to give good feedback. You will also learn an eight-step delegation process that you can customize for any situation. -
Influence and Persuasion
R599.00 Ex.VAT 15%In this course, you will learn how to speak persuasively, communicate with confidence, build rapport, develop a strong presentation, and leverage storytelling. Youll also receive an introduction to basic neuro linguistic programming techniques. -
Effective Planning and Scheduling
R599.00 Ex.VAT 15%This course will teach you how to use a variety of planning and scheduling tools, including the work breakdown structure, network diagrams, program evaluation and review technique (PERT), and Gantt charts. You will also learn how to properly estimate time, schedule resources, identify task dependencies, manage risks, communicate your schedule, and keep the schedule updated. -
Planning for Workplace Safety
R599.00 Ex.VAT 15%This course gives you the tools to create a workplace safety plan that covers the all the bases you need to begin to build a safe work environment. You will learn many topics including the basics of a safety policy along with the introduction of a safety plan and how to develop a communications plan. You will learn how to decide upon training solutions for common accidents/incidents and learn of the importance and structure of incident response plans. Also, the course covers 6S inspections, checklists, plus the value of an appendix for the safety plan. -
Women and Leadership: Owning Your Strengths and Skills
R599.00 Ex.VAT 15%At the end of this course you will understand a brief history and evolution of women and leadership. You will recognize leadership barriers, how to handle them, and use them to create benefits. You will know about social and emotional intelligence, and self-awareness. You will be able to develop a basic vision and brand for your leadership and understand essential leadership skills. You will also examine decision making and create a workplace philosophy statement and action plan. -
Working with the Media: Creating a Positive Working Relationship
R599.00 Ex.VAT 15%You are going to have a good grasp of the interview process when you are done of this course, from the perspective of a regular citizen or as a professional spokesperson. In addition to speaking to the media, youre going to learn how to pass your message along via a press release or media package. Libel and slander will come under consideration as well as various types of media outlets and the concept of a professional relationship with the media versus a personal one. -
-
-
Trade Shows: Getting the Most Out of Your Trade Show Experience
R599.00 Ex.VAT 15%You are going to learn about people who attend trade shows and how to interact with them. You are also going to learn about the importance of pre-show promotion and then follow up afterwards. These topics will be explored in great depth as they get broken down into areas such as creating good opening lines and good conversations, targeted promotional giveaways, booth behavior, and prospecting activities. -
-
-
-
Excel 2016 Level 1: Customizing the Excel Environment
R150.00 Ex.VAT 15%In this lesson, you will begin examining how to customize Microsoft Excel 2016 to suit your specific needs. This topic will teach you how to choose and apply various language options, as well as set some more general options. -
Transgender Employees: Creating an Inclusive Work Community
R599.00 Ex.VAT 15%Transgender Employees: Creating an Inclusive Work Community is a one-day course to introduce the importance and elements of safe inclusive workspaces for Transgender persons – those identifying as a gender other than the one assigned at birth. This course will offer an introduction to terminology, elements, policies, and resources to build and sustain a safe, inclusive environment for Transgender employees and increase the comfort level and productivity off all in your organization. -
Hiring for Success: Behavioral Interviewing Techniques
R599.00 Ex.VAT 15%Interviewing sounds easy enough: you arrange for a conversation between you and potential candidates, and then select the best person for a particular position. But what if you could refine the process in such a way that you were confident that you are selecting the right person? How do you separate the good from the great, when they have similar work experience and strengths to offer? This workshop will give you the skills and tools to hire successful candidates.