Course Name

MS Excel Level 3

Overview

This course will assist learners in acquiring sufficient knowledge and skill to apply Microsoft Excel at an advanced level.

Course Objectives

► Labels and names
♦ Labels And Names Explained
♦ Accepting Labels In Formulas
♦ Using Text Labels
♦ Creating Labels
♦ Creating Names Using The Name Box
♦ Using Names To Select Cells
♦ Using Names In Formulas
♦ Creating Names Between Workbooks
♦ Creating Names For Constants
♦ Creating A List Of Names
♦ Changing The Range For Names
♦ Deleting Labels And Names

► Linking Workbooks
♦ Linking Data In Excel
♦ Linking Within A Workbook
♦ Linking Between Workbooks
♦ Updating Links between Workbooks

► Sharing Workbooks
♦ Use A Non-Shared Workbook
♦ Sharing A Workbook
♦ Working With A Shared Workbook
♦ Checking And Removing Sharing
♦ Tracking Changes
♦ Accepting Or Rejecting Changes
♦ Discontinuing Change Tracking

► Chart data techniques
♦ Adding Data To A Chart
♦ Formatting Data Series
♦ Renaming Data Series
♦ Changing The Order Of Data Series
♦ Deleting Data Series

► Logical functions
♦ Logical Function Concepts
♦ Displaying Information Using IF
♦ Displaying Values Using IF
♦ Nesting An IF Function
♦ Using The AND Function
♦ Using The OR Function
♦ Using The NOT Function

► Lookup functions
♦ Requirements of Lookup Functions
♦ The CHOOSE Function
♦ The ISERROR Function
♦ The VLOOKUP Function
♦ Testing Lookup Functions
♦ Using VLOOUP For Exact Matches
♦ The INDEX Function

► Sorting
♦ Performing A Simple Sort
♦ Sorting On More Than One Column
♦ Sorting Numbers
♦ Sorting By Rows

► Auto Filter
♦ Applying and Using AutoFilter
♦ Creating Compound Filters
♦ Creating Custom Filters
♦ Multiple Value Criteria
♦ Using Wildcards in Multiple Criteria

► PivotTables
♦ PivotTable Theory
♦ Creating A PivotTable
♦ Adding A Row Field To A PivotTable
♦ Using A Page Field In PivotTable
♦ Filtering Row And Column Values
♦ Formatting A PivotTable
♦ Counting With PivotTable
♦ PivotTable Summary Options
♦ Show Data As Percentages in PivotTables
♦ Calculating Field in PivotTable
♦ Calculating Items in PivotTable
♦ Creating A Pivot Chart
♦ Modifying A PivotChart Via The PivotTable

► Importing and Exporting
♦ Importing From Another Spreadsheet Program
♦ Text File Formats
♦ Importing Tab-Delimited Text
♦ Exporting To Microsoft Word
♦ Exporting Data as Text

► Recorded Macros
♦ Recorded A Simple Macro
♦ Running A Recorded Macro
♦ Relative Cell References
♦ Running A Macro With Relative References
♦ Viewing A Macro Module
♦ Modifying A Recorded Macro

Target Group

This course targets all computer users who have daily duties on Excel spreadsheets at an advanced level.

Minimum Delegates

6 Delegates

Maximum Delegates

10 Delegates

Accreditation

No

Number of Days

1 Day

Learning Approach

Practical - Computer will be provided if delegates do not have laptops

Cost per Delegate

R1,265

Send an Enquiry Form

Click here to close Window