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.


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);
  • Managing Workbook protection, versioning control and metadata.

Course Programme

(Note: Exempted through ECDL)

Tutor:  Steve Mangion

Date:  13th, 16th March 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.
  • Customising the layout of the Excel application window

(Note: Exempted through ECDL Advanced)

Tutor:  Steve Mangion

Date:  20th, 23rd March 2017

Time:  16:30 – 19:45

  • Excel formulae and functions in MS Excel 2016
  • 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
  • Building MS Excel Models

Tutor:  Bernard Mallia

Date:  27th, 30th March 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 Iteratively
  • Excel and its Visual Basic for Applications Environment
  • Structure workbooks with XML

Tutor:  Bernard Mallia

Date:   6th, 13th April 2017

Time:  16:30 – 19:45

  • The Data Analysis Tool pack in MS Excel 2016
  • 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
  • Analysis of Covariance (ANCOVA)

Tutor:  Bernard Mallia

Date:  18th, 20th April 2017

Time:  16:30 – 19:45

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

Tutor:  Bernard Mallia

Date:  27th April, 4th May 2017

Time:  16:30 – 19:45

  • Regression Analysis in a Cross-Sectional Data Context
  • Diagnostic testing tools in MS Excel 2016’s Data Analysis Tool pack
  • Data Decomposition For The Cross-Sectional Estimation Of Variable Relationships
  • Estimating Forecast Reliability
  • Producing Excel-Based Models On The Basis Of Statistics Estimated Relationships And Building In Interval Ranges


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.



Price for all 6 modules, consisting of 12 sessions is €900 which is inclusive of the following:

  • Course Notes
  • Examination Fee
  • Certificate
  • Refreshments
  • Free Parking

The modules can also be taken separately. for modules taken in isolation, the price per module is €150. This also includes the course material for that specific module.

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 :


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


Sessions for this course will be held as follows:

  • Module 1 – 13th, 16th March 2017, 16:30 – 19:45
  • Module 2 – 20th, 23rd March 2017, 16:30 – 19:45
  • Module 3 – 27th, 30th March 2017, 16:30 – 19:45
  • Module 4 – 6th, 13th April 2017, 16:30 – 19:45
  • Module 5 – 18th, 20th April 2017, 16:30 – 19:45
  • Module 6 – 27th April, 4th May 2017, 16:30 – 19:45

The sessions above will be held in English.


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