-
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. -
-
-
-
-
-
