Microsoft Office Excel Advanced Course outline.

Module 1: Enhancing Workbooks - Customise workbooks in several different ways. In this topic you will learn how to customise in more ways.

Customize workbooks

Create and use templates

Protect files


Module 2: Automating Worksheet Functionality - Automating worksheet functionality to spreadsheet 

Update workbook properties

Create and edit a macro

Apply conditional formatting

Add data validation criteria to a workbook


Module 3: Analysing and Presenting Data - Analysing data and presenting data in logical manner.

Create Sparklines

Create a Data List Outline

Perform statistical analysis with the Analysis ToolPak

Create interactive data with Power View


Module 4: Import and Export Data - Importing and exporting data to and from Excel.

Export Excel data

Import a delimited text file

Integrate Excel data with the web

Create a web query

Import and export XML data


Module 5: Managing Large Workbooks - Consolidate, link and sort data within spreadsheets.

Consolidate data

Merge workbooks

Sort and filter data


Module 6: Analysing data within PivotTables, Slicers and PivotCharts - Analysing data in Excel using PivotTables. Covering fundamentals and creation of PivotTables.

Create a PivotTable

Filter data using slicers

Analyze data using PivotCharts


Module 7: Analysing Data with Logical and Lookup Functions – Specialized functions specific to text analysis.

Use text functions

Use logical functions

Use lookup functions

Use date functions

Use financial functions

Use specialised functions

Special OfferBlack Friday special until 29 November 2021 R1200


HGG NPO Sustainability Solutions (Pty) Ltd offers a National Certificate in IT: End User Computing NQF Level 3, which will put you in the front line of the employment queue and give you valuable and sought-after skills. This course develops a range of computer skills that will enable students to be qualified and capable in their chosen industry.

The purpose of the qualification is to build the knowledge and skills required by office workers in end user computing. When applying for any office administration job, this qualification lets your employer know that you have studied and are knowledgeable about all aspects of end-user computing, giving you a competitive advantage in the job market. This qualification is also recognised in New Zealand, Australia and Britain.

Cost: R5 000


Please Login or  Signup if  you want to register and are not logged in yet.