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

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