ICDL SPREADSHEETS

about the track

The Spreadsheets module covers the main concepts and skills needed to use spreadsheets, such as tasks associated with developing, formatting, modifying, and using a spreadsheet.
Organising and analysing data using a spreadsheet application produces useful insights for all types of organisation. In addition to using standard formulas and functions, this module covers visualisation of data through creating and formatting graphs or charts.
The analysis of numerical data is an important activity in a wide range of job roles. Accountants, project managers, sales executives, engineers – and many more – rely
on spreadsheets to carry out crucial calculations.
Develop the key skills needed to organise and analyse data using spreadsheet software
Module overview


Category

Skill set

Using the application

  • Working with spreadsheets
  • Enhancing productivity

Cells

  • Insert, select
  • Edit, sort
  • Copy, move, delete

Managing worksheets

  • Rows and columns
  • Worksheets

Formulas and functions

  • Arithmetic functions
  • Functions

Formatting

  • Numbers/dates
  • Contents
  • Alignment, border effects

Charts

  • Create
  • Edit

Prepare outputs

  • Setup
  • Check and print

Main learning outcomes
Successful candidates will be able to use a spreadsheet application to create and work with spreadsheets. After passing this module, candidates will feel confident entering, moving, editing, and deleting data, as well as performing common spreadsheet tasks. They will be able to:

  • understand the key concepts of spreadsheets
  • use available help resources and shortcuts to enhance productivity
  • recognise good practice in inserting, editing, and deleting data
  • apply a range of mathematical and logical formulas and functions
  • know how to communicate information using charts and graphs

Browse Other program tracks

The True value of Partnership

Any partnership, big or small, will work best when there is a shared goal. Developing value-aligned partnerships that focus on common goals and complementary strengths is key to ensuring successful outcomes for all. Working collaboratively with partners generates the kind of energy that fuels growth, innovation and creativity. In our experience, we have found that communication and collaboration are in fact key factors in successful and productive partnerships. Our partners are critical in the success and growth of our business and we are constantly learning from them. We will deepen partnerships with neighboring countries and promote our values.

Contact Us

Mericler is a Canadian educational umbrella under which a range of services is delivered worldwide by experts and professionals who have accumulated years of international experience in their specialty fields. Starting from Toronto, Canada...

CANADA

20 Carlton St. (Suite
      no. 121), Toronto,
      Ontario, M5B 2H5,
      Canada

+1 647 933 9098

  +1 647 627 3938

+1 647 933 9097

info@mericler.net

TÜRKIYE

Esentepe, Yazarlar Sk.
      No 21, 34381
      Şişli/İstanbul

+90 212 27 555 12/3

  +90 544 294 46 38/9

info@mericler.net

USA

8315 Spectrum Irvine
      California 92618

+1 949 771 7214

+1 949 771 7214

info@mericler.net

INDIA

Focus Education &
      Immigration B-32
      Supath-2 Opp. Hotel
      Fairfield, Nr. Old
      Wadaj Ashram Road,
      Ahmedabad 380 013,
      Gujarat, India

+91 97235 96061

+91 97235 96061

india@mericler.net

NIGERIA

48 Sakponba road,
      opposite First bank,
      IK pharmacy building,
      2nd floor, Benin city,
      Edo state, Nigeria

+234 905 599 7001

+234 905 599 7001

nigeria@mericler.net