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
• Protect files
Module 2: Automating Worksheet Functionality - Automating worksheet functionality to spreadsheet
• 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.
• 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
Module 5: Managing Large Workbooks - Consolidate, link and sort data within spreadsheets.
• 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.
• Analyze data using PivotCharts
Module 7: Analysing Data with Logical and Lookup Functions – Specialized functions specific to text analysis.
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.
