-
-
-
-
Excel 2016 Level 2 – Analyzing Data with Logical and Lookup Functions
R150.00 Ex.VAT 15%In this course, students will learn how to analyze data by using text, logical, lookup, date and financial functions. -
-
-
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.