Microsoft Excel Intermediate

R695.65 Excl VAT

This course is designed for those who wish to gain the necessary skills to build basic formulas, interact with spreadsheets, design well formatted spreadsheets.

 

Description

Unit Standard: 116940

 

This course is designed for those who wish to gain the necessary skills to build basic formulas, interact with spreadsheets, design well formatted spreadsheets.

 

Prerequisites: Candidates should be comfortable with the MS Excel Environment and basic formatting.

You will learn:

  • Formula building
  • Customising MS Excel & Options
  • Advanced formatting

 

Candidates who successfully complete a Portfolio of Evidence will receive a certificate of competence and awarded credits for these unit standards.

 

  • Customizing Excel
  • Working with the View Tab
  • Freezing Panes
  • Changing Excel Defaults
  • Working with multiple Sheets
  • Adjusting ranges between sheets
  • The SUM function – using BODMAS
  • Understanding formula errors
  • Absolute referencing
  • The ROUND function
  • Statistical Functions (Count, Average, Max, Min)
  • Working with Templates
  • Advanced Formatting Options (number, date, currency, percentage)
  • Advanced Border Application
  • Evaluating Spreadsheet