Discovering Excel

During this course you will be taught how to develop spreadsheets using formulas and formatting; and will be shown how to create charts ensuring you leave with a comprehensive knowledge of how to make Excel work for you.

These workshops are available in Excel 2003 and Excel 2007.

Who will benefit by attending this course?

Excel users with a basic Excel knowledge that would want to take their Excel skills to the next level. To assess your Excel knowledge, download our Pre-Assessment for Discovering Excel (Excel 2003 file, 330KB)

Course Duration

Classroom – Full day (9:00 – 16:30)

Samples of Workshop Content

  • What is Microsoft Excel
  • Working with Workbooks and Worksheets
  • File Formats and Columns and Rows
  • Working with Formulae (Formulae with Absolute References and 3-D Formulae)
  • Managing and Using Multiple Worksheets
  • Creating Multiple Views
  • Formatting and Editing Worksheets
  • Printing and Page Setup
  • Using Functions (Sum, AutoSum, Average, Max, Text, Conditional Formatting)
  • Charts
  • Creating and Editing a Chart
  • Click here to view training dates.

    Download registration form

      Terms and Conditions
    • Unless otherwise specified, all prices include VAT
    • All course manuals are included in the class-room course fee
    • Learners may be required to bring their own consumable items such as a writing pad, pens, etc.
    • Payment for training is strictly to be paid at least a week before commencement date
    • No Cancellations will be accepted, the full course fee will be charged – although substitutions may be made
    • Lemay’s Training Centre reserves the right to cancel any course should there be an insufficient number of delegates booked for a course. Courses will only be run if there are sufficient learner numbers
    • Additional Modules can be arranged should there be enough of a demand or arrangements can be made for 1 on 1 training
    • Additional Modules - Manufacturing, Point of Sale, Multi Currency, Receipting, Serial Number Tracking, Time and Billing, General Ledger Manager, Multi Stores available on request
      Assessments & Certification
    • Assessments are based on information taught in the classroom and not necessary based on the training material
    • Marking of the exams will take between 2 to 4 weeks
    • Accreditation Refresher & Bridging Assessments will be based on the previous and current versions
    • Should it be required that you need to write an assessment after a course, you will need to do so within 30 days after the end of the course. No extensions will be granted
    • Students are required to purchase and book assessments
    • The pass mark is 75%
    • A student needs to write an assessment in order to obtain certification for attending a course

    Training Dates

    Jan 2012
    11-12: ACT! Ver13 User
    18-19: ACT! Ver13 Admin
    27: Payroll Year End

    Feb 2012
    7-9: Xpress V11
    13: Payroll Level 1
    14: Payroll Level 2
    15: Payroll Level 3
    16: Payroll Level 4
    17: Payroll Level 5
    13-17: Payroll Administrator

    Mar 2012
    5-8: Partner V11 Intermediate
    13: Payroll SARS Submissions
    28-29: ACT! V13 User Course

    Apr 2012
    3-4: ACT! V13 Admin
    16: Payroll Level 1
    17: Payroll Level 2
    18: Payroll Level 3
    19: Payroll Level 4
    20: Payroll Level 5
    16-20: Payroll Administrator

    View all dates and pricing


    Site design by Kangaroo Digital