COURSE OUTCOMES

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

Want to have this course in-house?

Contact 012 430 2101 or marinkie@raisingthestandards.org.za

COURSE OUTLINE

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

Want to produce professional looking tables and charts using MS Excel?

HAVE QUESTIONS?