MAX: Cert in Spreadsheet Processing

£29.99

Learn at your own pace! Apply now!

Compatible with Windows & MAC OS.

Apps required: Google Sheets, Numbers or MS Excel.

Description

MAX: Cert in Spreadsheet processing grants FREE access to MAX: VLE Basic Membership Plan.

Key Features

  • Suitable for working professionals and students looking to gain additional accreditation in ICT and IT competency
  • Individual learning at own pace
  • Certificate provided upon completion with a transcript and a course completion letter [three documents]
  • Optional life-time online verification facility.

Get started:

  1. Register a FREE account and  join MAX VLE classrooms for course content.
  2. Fill our contact us form to contact your online ICT Tutor.

Course(s):

All candidates study the following topic(s):

MAXICT20 – Data Analysis 041703

Course aims & objectives

Everyone is an achiever.

MAX Cert in Spreadsheet Processing is designed for people wishing to gain a benchmark certificate in ICT which may enhance their career prospects and personal development. This course covers the main concepts of spreadsheets as financial models and allows learners to demonstrate their ability to use a spreadsheet processing [Microsoft Excel / Numbers / Google sheets] applications on Windows or MAC. You will learn how to create, modify and format spreadsheets. The course also covers some of the common features associated with spreadsheet processing such as creating business models, creating charts, using simple and nested functions, manipulating and interrogating spreadsheets.

  • This course is conducted entirely online.
  • The most significant advantage of our professional, highly skilled online courses is that they follow e-learning criteria which enable students to complete the course at their own pace and the comfort of their own home.
  • You are expected to complete all modules within 3 to 4 months.
  • Our fee is extremely affordable for students and professionals who have an eager desire to lead a successful ICT related career in a competitive world.
  • You can find additional learning resources from our more than 500 free  ICT Tutorial videos on our website.

Course Type: Part-time

Course Level: Intermediate

Course Requirements: No formal qualifications are necessary

Course Start / intake: On-going throughout the year

Course Duration: Up to 2-3 months

Course Content: The Spreadsheet Processing suite of qualifications has been designed to develop and recognize candidates’ ability to familiarize themselves with basic functions of MS Excel, and help them apply the skills they learn in MS Excel to work and daily life.

Teaching and learning activities: Online coaching, tutorials and assignments.

Entry requirements

Software Requirements

This course is compatible with both Windows and MAC operating systems. Students can also use Google Applications or any other Open-source applications.

Internet skills & technical requirements

The course is taught entirely online, using the VLE (Virtual Learning Environment). You won’t need any prior experience or knowledge of online learning, although basic experience of email and Internet is expected. Technical and pedagogical support is available for the entire duration of the course.

You may also need:

  • An Internet connection
  • A headset (best is with a USB connection) or stand-alone microphone and speakers
  • A webcam is optional
  • An up-to-date browser
  • An up-to-date media player (e.g. Windows Media Player or similar)
  • Microsoft Office Applications Suite 2010-13 or simillar.
  • You will use an online video conferencing platform for chats with course tuttor(s) several times during the course – the exact time for this is negotiated with the group. To take part in a video conferencing session you will need a headset with microphone (headsets with a USB plug are the best option). If you have a webcam, you may want to connect that during the video conferencing session, but this is optional—you will be able to see and hear your tutor even if you only have a headset. Video conferencing sessions are always recorded which means that even if you can’t attend, you will be able to watch the recording later online, in your own time. Our video conferencing platform is accessed via a web page—you do not need to download or install anything to use it during the course.

Assessment procedures

Participants need to complete a minimum of 80% of the course work for the Module / Tutorial to an acceptable standard within the time frame of the course. An overall Pass or Fail grade is awarded for the MAX: Cert in Spreadsheet Processing. In order for participants to be awarded the Certificate, course module must be passed.

Key Skills Covered in this course

Key skills covered in this module are as follows:

Interface of a Spreadsheet package
File Management

Using Simple and Nested Functions

  • IF Function
  • COUNTIF Function
  • SUMIF Function
  • MAX Function
  • MIN Function
  • AVERAGE Function
  • SUM Function
  • COUNT Function
  • LOOKUP Function
  • ROUND / AVERAGE Function

Inserting:

  • Header & Footer
  • Current Date and Current Time
  • Page Number
  • File Path
  • Currency Symbols
  • Decimal Places

Operation of the Cells and Cell Formatting:

  • Bold
  • Italic
  • Font Style / face
  • Font Size
  • Background Colour and shading
  • Creating a Named range of Cells
  • Hide unhide

Cell Alignment:

  • Centre
  • Right
  • Left
  • Justify

Charts and Graphs:

  • Pie Charts
  • Bar Charts

Importing and Exporting Data:

  • From .CSV to .XLXS Excel Workbook

Creating an extract for interrogating data

  • Using Filter
  • Sorting Data
  • Using filter containing specific word(s)

Printing Spreadsheets

  • Print Preview
  • Page break view
  • Layout view
  • Printing a selection

Saving Data at your Work area

  • Creating evidence of your work
  • Integrating Software
  • Screenshots and snipping tools

Sending an email

  • Creating a new contact
  • Adding designation or job title
  • Adding cc (carbon copy)
  • Adding subject line
  • Adding text
  • Attaching files
  • Sending an email.

Online Readiness

If you have never taken an online course at Maximus Plus, you should take time to review the Online Readiness. We have highlight 6 key readiness tips that can help you to prepare for your online learning experience.

These include:

  • Getting Oriented: Learning about learning online, how to access your course.
  • Knowing Your PC : Navigating technology and ensuring reliable Internet access is important so that it doesn’t get in the way of learning the content.
  • Reading : Access your course and ensure you read the syllabus and instructions presented.
  • Logging in Daily: This is how you attend class… by logging in!
  • Being Self-Disciplined and Engaged: Stay motivated, keep a schedule, and participate.
  • Believing in your Abilities and Asking for Help: You can do it! Don’t get behind, if you have a technical issue, ask for help. If you need help with content or the class, contact your tutor.

Corporate Partnership

Maximus Plus short courses are being conducted online in various countries. This offer is for institutes who wish to conduct Maximus Plus short-courses at their institutes or international schools. Contact us for a highly competitive business proposal.

Additional information

Weight 0.30 kg
Dimensions 21 x 29.7 x 0.50 cm

Reviews

There are no reviews yet.

Be the first to review “MAX: Cert in Spreadsheet Processing”