MICROSOFT EXCEL EXPERT (1 DAY) - DLS CONSULTING

Subject

Becoming an Excel expert user

Unit Standards

• Not available

Pre-requisites

Prior knowledge and skills to:

• Read, write, communicate and comprehend at least at GET level.
• Competent in mathematical fundamentals at least at NQF level 1.
• Operate a personal computer system.
• Use generic functions in a Graphical User Interface (GUI)-environment. (PC’s and Windows Essentials)
• Use a Graphical User Interface (GUI)-based spreadsheet application to create and edit spreadsheets. (Microsoft Excel Essentials)
• 116940 Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem  (6 Credits) Level 3 (Mastering Microsoft Excel)
• 116943 Using a Graphical User Interface (GUI)-based spreadsheet application, enhance the functionality and apply graph /charts to a spreadsheet ( 3 Credits) Level 4 (Mastering Microsoft Excel)

Level

Advanced

Modules

Introduction

• Naming Ranges
• Working with Names
• Deleting a Named Range
• Paste Special
• Working with Links
• Editing Links
• Worksheet Protection

Data commands

• Sorting Data
• AutoFilter
• Subtotals
• Working with Advanced Filters
• Working with External Data
• Converting Text to Columns
• Validation

Pivot Tables

• Creating a Pivot Table
• The Pivot Table toolbar
• Pivot Table Layout
• Pivot Table Options
• Using the Filters
• Field Settings
• Pivot Charts

Advanced Functions

• Database Functions
• Lookup Functions
• Logical Functions
• Text Functions

Advanced Tools

• Auditing tools
• Goal Seek
• Solver
• Scenario Manager
• Custom Views

Customising Microsoft Excel

• Setting and Changing Options
• Changing Toolbar options
• Customising Toolbars

Macros

• Recording Macros
• Running Macros
• Assigning Macros to Objects