MS Excel - Advanced

By attending this course, delegates will be able to:

  • Produce professional looking tables and charts
  • Manipulate large amounts of data into meaningful information (PivotTables) and give up to date results
  • Use formulas and functions e.g. date, text, financial to save time
  • Use alternative data sets to get results without losing the original information
  • Use data tools to streamline the use of the spreadsheet and prevent errors
  • Use Macros to perform repetitive tasks

Module 1:  Using Logical Functions

  • Working with names and ranges
  • Using the Function Library
  • Manually entering a function
  • Working with nested functions
  • Applying logical functions
  • Working with Lookups

Module 2:  Advanced List Management

  • Creating Data Validation rules
  • Using database functions
  • Using a formula to validate entries

Module 3:  Creating Pivot Tables

  • What is a Pivot Table?
  • The Pivot Table tools tab
  • Creating a Pivot chart from your Pivot Table
  • Analysing data using your Pivot Table using Slicers

Module 4:  Using What If Analysis

  • Using goal seek
  • Using the scenario manager
  • Creating a data table
  • Using Solver

Module 5:  Macros

  • What is a macro?
  • Displaying the Developer Tab
  • Recording and running macros
Contact Details

Contact Person: 

Bianca van Wyk
Course Details

Course Delivery Method: 

In Class In Class

Presented Presented Courses

In House In-House

On Demand On Demand

Course Duration: 

1 day

Cost: 

R1820.00

Course fee Includes: 

Lunch and refreshments