Microsoft Excel 2010 Advanced Class

Microsoft Excel 2010 Advanced Courses in Cape Town

Becoming an Excel expert user

Unit Standards
258876 -  Work with spreadsheets (Level 4) Cr4dits 3



See our MS Office course schedule here

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)


Prepare and produce a spreadsheet
Naming Ranges
Working with Names
Deleting a Named Range
Creating names from a selection
Using Paste Special
Working with Links
Editing Links
Worksheet Protection

Data commands
Sorting Data
Working with Advanced Filters
Working with External Data
Converting Text to Columns

Advanced Functions
Database Functions
Lookup Functions
Logical Functions
Text Functions

Customising Microsoft Excel
Setting Excel Options
Excel Add-ins
Customising the Quick Access toolbar

Pivot Tables
Understanding a Pivot Table
Creating a Pivot Table
Using the PivotTable filters
Change PivotTable data
Modifying the Pivot Table placement
Change the design layout
Change the design style
Change the design style options
Change settings of a selected field
Pivot Table options
Inserting Slicers
Creating Pivot Charts
Deleting a PivotTable report or chart

Advanced Tools
Auditing tools
Goal Seek
Scenario Manager
Custom Views

Understanding Macros
Developer Tab
Macro Security levels
Trusted locations
Recording a macro
Running Macros

2KO Africa is a professional training company, delivering cutting edge programs in the IT space and in selected business applications. Our training is offered online, live online and also by instructor led classes. 2KO Africa's business courses are available world-wide, many of them leading to European Certification, enabling 2KO students the opportunity to study courses online world-wide, to ensure students have access to the best training possible.