Programme Summary

The Award in MS Excel for Data Analysis & Statistics (MQF Level 5) is an accreditation that shows that the user is proficient in using the different features of MS Excel as required by industry. The modules covered in this training path are:

Microsoft Excel for Beginners sets the ground for customising the Excel work environment. Subsequently, the Intermediate Microsoft Excel module covers functionality, add-ins and further customisation, whereas the MS Excel Advanced Techniques then goes into how the functionalities discovered in the Intermediate module can be leveraged to provide solutions to complex problems, especially in relation to automation and object linking and embedding.

The Award in MS Excel for Data Analysis & Statistics (MQF Level 5) course has been designed on the basis of surveys undertaken throughout Maltese industry by Equinox Advisory Ltd, and the course effectively prepares the user to be able to take on tasks that require specialised knowledge of MS Excel’s functionality.

The course is composed of the following modules.

  • Module 1: MS Excel Customisation & Configuration
  • Module 2: MS Excel Intermediate: Formulas and Formula Auditing
  • Module 3: MS Excel Advanced Techniques
  • Module 4: Using Statistics in MS Excel
  • Module 5: Producing Time-Series Forecasts in MS Excel
  • Module 6: Producing Cross-Sectional Data Decomposition using MS Excel

The target groups for the Award in MS Excel for Data Analysis & Statistics are people from all walks of life who are interested in and would like to pursue further studies in extending their knowledge of the MS Excel spreadsheet tools generally and in the data mining, data analysis and statistical areas of application.

Objectives

The high-level objectives of this course include:

  • Familiarisation with the components of a spreadsheet and how to use, manipulate and control the spreadsheet environment: Entering, editing and organising numerical and non-numeric data;
  • Familiarisation with MS Excel standard functionality and programmatic features;
  • Imparting the right skills on the usage of appropriate formulas and tools to display and efficiently summarise spreadsheet information;
  • Making the right decisions about selection and appropriate use of tools and techniques to present and to print spreadsheet information effectively;
  • Familiarising students with Open Database Connectivity (ODBC) and MS Excel integration with Databases;
  • Familiarising students with pivot tables and pivot charts, when to use them and how to use them;
  • Learning about the Data Analysis Toolpack, how it can be activated and how it can be used efficiently to solve common workplace problems.
  • Learning about Solver and accompanying skills to solve equations linearly or iteratively through Solver;
  • Acquiring the requisite skills to be able to judge when relative & absolute references should be used in code;
  • Becoming Aware of the possibilities of integrating different types of data and consolidating them into a single spread sheet or multiple, linked spread sheets;
  • Constructing charts from Data and communicating data visually (in-cell or through charts); and
  • Managing Workbook protection, versioning control and metadata.

Course Programme

Module 1: MS Excel Customisation & Configuration

(Note: Exempted through ECDL Advanced Excel)

Tutor:    Mr. Steve Mangion

Dates:    2nd, 6th November 2017

Time:     16:30 – 19:45

  • Configuring Add-ins;
  • The nature of data;
  • The ribbon environment and VBA environment (without going into VBA);
  • Importing data from other applications;
  • Configuring Print Areas;
  • Fixing Views & Splitting Screens;
  • Shortcuts and presets;
  • Basic formula structure;
  • Printing workbook contents; and
  • Customising the layout of the Excel application window.

Module 2: MS Excel Intermediate: Formulas and Formula Auditing

(Note: Exempted through ECDL Advanced Excel)

Tutor:    Mr. Steve Mangion

Date:    9th, 13th November 2017

Time:     16:30 – 19:45

  • Excel formulae and functions in MS Excel 2010;
  • Formulae Auditing;
  • Tracking Changes in MS Excel;
  • Merging data from multiple sources;
  • Open Database Connectivity;
  • Mail Merge;
  • Data Consolidation;
  • Worksheet and workbook security;
  • Summarising data;
  • Sorting & Duplicate Value Removal;
  • MS Excel Styles; and
  • Building MS Excel Models.

Module 3: MS Excel Advanced Techniques

Tutor:    Mr. Bernard Mallia

Date:    16th , 20th  November 2017

Time:     16:30 – 19:45

  • Recovering from MS Excel Crashes;
  • Conditional Formatting;
  • Building Forms in MS Excel;
  • Using MS Excel Objects;
  • Named Lists & References;
  • Workbook Automation Techniques;
  • Manual Formula Fill for Multiple Formulae;
  • Using Solver to Solve Equations Linearly or alliteratively;
  • Excel and its Visual Basic for Applications Environment; and
  • Structure workbooks with XML.

Module 4: Using Statistics in MS Excel

Tutor:    Mr. Bernard Mallia

Date:   23rd, 27th November 2017

Time:     16:30 – 19:45

  • The Data Analysis Tool pack in MS Excel 2010;
  • Excel Functions for Basic Inferential Statistics;
  • Managing Statistical Power;
  • Regression Analysis – What it is and how to use it;
  • Excel Functions for Linear Regression;
  • Comparing Means with Analysis of Variance (ANOVA);
  • Multiple Comparisons of Mean; and
  • Analysis of Covariance (ANCOVA).

Module 5: Producing Time-Series Forecasts in MS Excel

Tutor:    Mr. Bernard Mallia

Date:    30th November and 7th December 2017

Time:     16:30 – 19:45

  • Diagnostic testing tools in MS Excel 2010’s Data Analysis Tool pack;
  • Regression Analysis in a Time-Series Context;
  • Data Decomposition for time-series forecasting;
  • Estimating Forecast Reliability; and
  • Producing Excel-based Forecast Summaries.

Module 6: Producing Cross-Sectional Data Decomposition using MS Excel

Tutor:    Mr. Bernard Mallia

Date:    11th, 14th December 2017

Time:     16:30 – 19:45

  • Regression Analysis in a Cross-Sectional Data Context;
  • Diagnostic testing tools in MS Excel 2010’s Data Analysis Tool pack;
  • Data Decomposition for The Cross-Sectional Estimation of Variable Relationships;
  • Estimating Forecast Reliability; and
  • Producing Excel-Based Models On the Basis of Statistics Estimated Relationships and Building in Interval Ranges.

Trainers

Bernard Mallia

Our trainer for this module, Bernard Mallia is not just another run-of-the-mill MS Excel trainer. Our training is exclusively designed for professionals and we strongly believe that professionals should not just expect a trainer who can showcase the tools of MS Excel using rote operations. If this is what you are after, you are better off going for the ECDL Advanced module. Our training aims, and is accordingly designed, to be much more than that.

We choose our trainers on the basis of their proven business and problem-solving abilities, and Bernard Mallia is a case in point. Bernard is an experienced business professional with strong number crunching and data analysis skills who also happens to be passionate about lecturing and imparting skills. Bernard is the person with whom our clients share practical real-life scenarios and difficulties with the intent of learning how to exploit the software platform being explored to solve them. This makes our method of delivery a well-balanced trade-off between broad-insight lecturing (as Bernard brings to the table not only his expertise in MS Excel but also his vast knowledge of its integration with other information systems and his thorough knowledge of econometrics and statistics) and problem-specific consulting. The feedback that we have elicited from our bespoke training sessions given by Bernard were invariably very positive both inasmuch as the trainer himself is concerned, and also with respect to the delivery method utilised by Equinox Academy on the basis of the market research conducted by Equinox Advisory Ltd.
The prices we charge, despite being affordable, might not be the absolute cheapest on the market, but they undoubtedly represent the best value for money proposition available out there.

Bernard is an experienced independent consultant and adviser in the fields of economics, project management, ICT and Information Systems. He has a polymathic background and was awarded his first degree in Commerce with a specialisation in Public Policy and Economics, as well as an honours degree in Public and Private Sector Management from the University of Malta. He pursued post- graduate studies at the University of Edinburgh where he read for a M.Sc. in Economics, and at the European University where he read for a M.Sc. in Information Systems. He has also been the recipient of diplomas in Computerised Bookkeeping (IAB), Project Management (CIC), and Advertising and Public Relations (CIC). Bernard is a certified MS Office advanced user and a SQL Server 2005 Microsoft Certified Professional. Bernard delivers courses in:

  • MS Excel
  • Odds and Gaming
  • Financial Planning & Budgeting
  • Risk Management
  • Project Management
  • Regulatory Policy and Institutions
Steve Mangion

Steve Mangion is the Managing Director of IBP Consultancy. As a Business Analyst, he is the bridge between the business problems and the technology solutions. His main areas of specialisation are Business System set up, Internal Business Process improvements, Change Management and setting up Strategic and Operational analytical reporting.

For the past few years he has been consulting various small to medium sized companies in improving their internal business processes.

Steve holds a 1st degree in Management and Economics from the University of Malta. He also pursued a Post Graduate Diploma in Business Administration from the Henley University at Reading UK.

Steve is also a member of the IIBA, International Institute of Business Analysis.

Fees

The Fee for the Course is as follows:

  • Registration Fee (Non-Refundable): EUR 35.
  • Course Fee including: Lectures, Course Notes, Certificate of Attendance, Refreshments (Please see our Terms & Conditions on changes, rejections & cancellations): EUR 875
  • Examination Fee (Optional) including NCFHE-Accredited Certification upon accomplishment of the Exam: EUR 40

By registering for the course, you are agreeing to be bound by all the terms and conditions including payment terms. Upon Registration, an invoice will be issued for payment which includes the Registration Fee, the Course Fee (which you will not be required to pay in terms of rejection but for which you are agreeing to pay in case of acceptance in line with our Terms and Conditions) and Examination Fee. The invoice is to be paid in its entirety within 15 days from the day of issuance. However, should you not meet the Eligibility Criteria for the selected course, the Course Fee will either not be levied or will be refunded if it has already been paid; the Registration Fee will remain non-refundable, whereas the Examination fee shall be settled upon registration for the exam. Should you wish to check about your Eligibility or clarify any other issues prior to Registering, kindly contact us on: equinoxacademy@equinoxadvisory.com

The course qualifies for the Jobsplus “Training Pays Scheme”, where a grant equivalent to 75% of the direct training cost can be availed of. For more information and the application form, please visit: https://jobsplus.gov.mt/schemes-jobseekers/training-pays-scheme.

Get Qualified Logo

This course qualifies for Get Qualified funding, where you might be able to get back 70% of the costs of the course. For more information and for the application forms, please visit : http://www.maltaenterprise.com/en/support/get-qualified

NCFHE Logo

Equinox Academy is licensed as a Higher Education Institution (License number 2015-005) by the National Commission for Further and Higher Education.

Sessions

Sessions for this course will be held as follows:

  • Sessions for this course will be held as follows:
    • Module 1 – 2nd, 6th November 2017, 16:30 – 19:45
    • Module 2 – 9th, 13th November 2017, 16:30 – 19:45
    • Module 3 – 16th, 20th November 2017, 16:30 – 19:45
    • Module 4 – 23rd, 27th November 2017, 16:30 – 19:45
    • Module 5 – 30th November and 7th December 2017, 16:30 – 19:45
    • Module 6 – 11th , 14th December 2017, 16:30 – 19:45

Location

To be advised closer to start-of-course date.