Award in MS Excel for Data Analysis & Statistics (MQF Level 5)

||Award in MS Excel for Data Analysis & Statistics (MQF Level 5)

Award in MS Excel for Data Analysis & Statistics (MQF Level 5)

The Award in MS Excel for Data Analysis & Statistics (accredited at MQF Level 5) is plainly the most comprehensive and most advanced MS Excel course that you will be able to find on the Island. It starts from a basic level and goes all the way up to a very advanced level. Successful completion shows that the user is proficient in using a comprehensive suite of different MS Excel features that industry considers to be essential or desirable.

Although this course targets a wide audience at the entry level, the advanced modules of this course are not for everyone. Those who lack motivation and the avenue or time to practice what they learn should not enroll for the advanced modules as they will find them difficult to complete. On the other hand, those who are keen to become power users of this increasingly popular tool will find that our MS Excel course will give them the right tools to handle most business problems requiring some form of numerical analysis, be it through regression analysis, predictive analytics or linear and dynamic programming. Our past students for this course who have also attended MS Excel courses offered by the competition claim that Equinox Academy's MS Excel course is by far the best, most comprehensive and most advanced course they have been to.

MS Excel for Data Analysis & Statistics 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.

MS Excel for Data Analysis & Statistics 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.

MS Excel for Data Analysis & Statistics 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

Jobs+ Training Funds

The course qualifies for the Jobsplus “Training Pays Scheme” and “Investing In Skills” scheme, where a grant equivalent to 75% of the direct training cost or a sum to be determined on an ad hoc basis through a Jobs+ dynamic spreadsheet can be availed of. For more information and links to the application forms, please click on the button below.

Malta Enterprise Get Qualified Scheme for Training Funding

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 links to the application forms, please click on the button below.

MS Excel for Data Analysis & Statistics Sessions

Sessions for this course will be held as follows:

  • Module 1 – 3rd, 7th May 2018, 16:30 – 19:45
  • Module 2 – 10th, 14th May 2018, 16:30 – 19:45
  • Module 3 – 17th, 21st May 2018, 16:30 – 19:45
  • Module 4 – 24th, 28th May 2018, 16:30 – 19:45
  • Module 5 – 31st May and 4th June 2018, 16:30 – 19:45
  • Module 6 – 11th, 14th June 2018, 16:30 – 19:45
National Commission for Higher Education Accredited

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

Microsoft Education Institution Partner

Equinox Academy is registered as a Microsoft Partner Network Member as an Education Institution.

MS Excel for Data Analysis & Statistics Detailed Course Programme

(Note: Can be Exempted through ECDL Advanced Excel)

Tutors:    Steve Mangion / Reece Delia

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.

(Note: Exempted through ECDL Advanced Excel)

Tutor:    Steve Mangion / Reece Delia

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.

Tutor:    Bernard Mallia

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.

Tutor:    Bernard Mallia

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).

Tutor:    Bernard Mallia

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.

Tutor:    Bernard Mallia

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.

MS Excel for Data Analysis & Statistics 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.

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.

Reece Delia

Reece Delia is the trainer for this course. Reece is an experienced business professional with strong MS Excel, finance and customer service skills and ample experience in the Corporate Sector. He is currently Equinox Advisory’s CFO and acts as the treasurer for IRISS and MIICT.

Reece is a qualified accountant and was awarded his first-class Bachelor in Commerce with a specialisation in Accountancy and Banking and Finance from the University of Malta. He subsequently read for a Master in Accountancy within the same University, graduating with Distinction.

For a number of years he also worked in the field of Customer Care where he mastered the challenge of effective customer relations. One of his previous roles at Centrecom entailed handling airline client calls and emails, together with follow-ups through Centrecom’s CRM system. Reece also has previous experience in the field of accounting and finance, previously having worked for PriceWaterhouseCoopers.

Other Equinox Academy Courses

Location where the Training will be Held

Equinox Academy Ltd.

36, Archbishop Street
Valletta VLT 1447
Malta
Phone: +35621376242
Email: academy@equinoxadvisory.com

Parking Arrangements

Given the time in which this course will take place, it would be best to park within Valletta itself. After 2 PM there is no cost for vehicles entering and staying in Valletta for more than half an hour and by that time there should be ample parking space available for all course attendees. In the unlikely event that you are unable to find parking in the immediate vicinity of the training venue, it is likely that there will be free-of-charge parking space in the Valletta ring road (4 minutes away on foot from the training venue) and Hastings (4 minutes away on foot from the training venue).

Registration Terms and Conditions apply.

4 reviews for Award in MS Excel for Data Analysis & Statistics (MQF Level 5)

  1. Luke Spiteri

    This course goes beyond MS Excel, as it covers a very evident gap in the training market in Malta by combining a very useful suite of intuitive non-mathematical statistics and a tour-de-force of Excel functionality. If only I had known about this course in my University days, I might have been able to ace the statistics component without the hassle I’ve had to go through. Highly recommended for anyone who hates statistics taught in an unnecessarily parrot-like manner where formulas have to be regurgitated during an exam and forgotten soon thereafter. Definitely a 5-star rating.

  2. Oxana Bystrouva

    I work on MS Excel almost all day, but I would never have imagined that the tool I was using was so powerful if I had not attended this course. Well done on a very well-structured and very much-needed course.

  3. Roderick Agius

    Great course delivered by great tutors. Bernard’s amazing mastery of Excel, its hidden tools and the routines behind them is second to none, as is his ability to answer any question the students posed, however complex. I’ve been to other MS Excel courses both locally and abroad, but this one beats them all hands down.

  4. Lara Baldacchino

    Great course – highly recommendable to anyone who works with numbers and who needs to understand what’s going on with common routines.

Only logged in customers who have purchased this product may leave a review.