Excel Intermediate

Description

After successful completion of the introduction and overview of the basic features of Excel learners will have an understanding of creating spreadsheets, handling simple lists of data, charts and be able to print formatted sections of a spreadsheet.

The intermediate course is intended to advance a learner‘s skills and confidence in  working with Excel.  Upon completion an understanding of advanced formatting, data searching using criteria based searches, analysis, summarising of data and creating customise charts will be acquired.

If you are familiar with creating and editing spreadsheets, have some knowledge of Excel or spreadsheets, able to launch and close applications, navigate to stored information and manage files and folders then this course will assist you to gain the necessary skills to plan, produce and use spreadsheets to solve problems using a spreadsheet application.

 Learning outcomes

  • Modify worksheet data
  • Formatting a worksheet
  • Basic calculations
  • Modify a workbook
  • Printing workbook contents
  • Enhancing basic formulas
  • Managing workbooks
  • Customise the environment

Target Group
For people who have some knowledge of Excel or spreadsheets

Learning Delivery Method
Stand-alone classroom-based accredited course

Unit Standard Alignment
SAQA ID:         116940                        NQF Level: 3                            Credits: 6
US Title:           Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem.

 Assessment
Optional

Duration
2 Days